For those of you looking to avoid the news today, check out @mutesky.app, which mutes political and distressing keywords. Temporarily set it to Complete filtering which adds about 1500 mute keywords. Performance will be impacted a bit but worth it. After the hubbub, set it back to Minimal.

You work with partitioning and know the advantages of this technology? You use this technology in DWH to improve workloads or in OLTP to optimize scaling? It should be avoided or optimized for a specific type of workload.
www.db-berater.de/2025/01/is-s...
#sqlserver #partitioning #optimization

Trust me, DBCC FREEPROCCACHE is definitely NOT executed every time an INDEX REBUILD is performed. This doesn't get any more true than some well-known SQL Server "expert" says. The plan cache is not even touched!

#sqlfamily #sqlserver #fail

You often read on social networks that a DBA’s job is to optimize databases, among other things. I think that’s a misinterpretation of the – important – role of a DBA.

#sqlfamily #sqlserver

www.db-berater.de/2024/12/the-...

Do you know that Foreign Key Constraints can help to improve your queries?

JOIN Elimination is a technique which might be useful in high transactional OLTP systems.
#sqlfamily #sqlserver

www.db-berater.de/2024/12/fore...

Me, when tuning was successful.

jealous of my wife. She’s in Norway for whale watching. Awesome!
#sqlfamily

Database don't need Foreign Key constraint; the application is taking care of it. Standard arguments are:
- to slow
- limit my handling of data
I took the time to run a few tests with and without Foreign Key Constraints. Surprising results...
www.db-berater.de/2024/11/use-...
#sqlfamily #sqlserver

Are you using the correct data types for parameters in your queries? If not, you should know what consequences this can have.
#sqlserver #sqlfamily

www.db-berater.de/2024/11/cons...

is it possible to filter on [attach_activity_id_seq] = 0 when i create an xevent?

Example: CREATE EVENT SESSION
...
WHERE attach_activity_id_seq = 1
#sqlhelp #sqlserver #sqlfamily

Hey SQL experts, don’t use ISNULL() to search in your tables. You can do it better, don’t you?

www.db-berater.de/2024/11/isnu...

#sqlserver #sqlfamily

Why not in Germany, too?

www.spiegel.de/auto/italien...

Unit Tests / Demos - do you need a random key value from a large table very quick? Optimize the process significantly...

www.db-berater.de/2024/11/opti...
#sqlserver #sqlfamily

Although my workshop is at the #sqlkonferenz in February, I'm already preparing the labs. I'm wondering if it won't be more of a comedy event. So many bad examples that I've collected over the years suggest a lot of fun.
#sqlserver #performance #tuning #sql #sqlfamily

Don’t let the asterisk (*) make you think it has the same use as in "SELECT *" statement. NO! COUNT(*) will not go through the whole table before returning the number of rows, making itself slower than COUNT(1)!

#sqlserver #Performance #SQL #sqlfamily

Note! If your SQL Server is suffering from "Tempdb Latch Contention" is is NEVER a problem of SQL Server! It's your application!

Want to learn more about it? In February 2025 I will be doing a workshop at #sqlkonferenz in Hanau (Germany).

sqlkonferenz.de/precon-works...
#sqlserver

I like database gurus who immediately recognize that databases have nothing to do with normalization. Why else would you allow up to 2 GB for a phone number, for example?
#sqlserver #rdbms #development #EF

I wonder why so many people ask silly SQL Server quiz questions on LinkedIn. What is the point of this nonsense? Can you win something? (asking for a friend).
#sqlserver #dataplatform

Dear community, moved from Twitter (@dbberater) to BlueSky.
I hope that things are more civilized and respectful here.
I look forward to interesting tweets and a friendly exchange with followers and those I follow.