Uwe Ricken

MuteSky — Mute in Bulk on Bluesky MuteSky helps you efficiently manage your Bluesky experience by providing powerful bulk muting capabilities. Filter your feed, manage content, and customize your experience with ease.

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.

Is SWITCH PARTITION a bad idea? How can SWITCH PARTITION be a bad idea? Do you work with partitioning and know the many advantages that this technology offers? Do you use this technology in DW

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

Yep. A new Plan will be generated, IF the Optimizer detects changes in the statistics.

eg: create a table + Index.
Run a select to create a plan.
Rebuild the Index.
Plan is in the Cache.
Run the würd again and Check for recompile (xevent)….

If statistics changed… the plan got obsolet but there is no FREEPROCCACHE for each Index rebuild :)

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

The role of a DBA is NOT Tuning but Operations 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

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-...

Foreign Key Constraints - JOIN Elimination JOIN Elimination in Microsoft SQL Server is an optimization technique with foreign key constraints where the query engine removes redundant JOIN operations duri

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

Use Foreign Key Constraints in your Databases - Part I When revising one of my popular sessions on scenarios in which indexes no longer help, one of the topics covered was foreign key constraints for data integrity

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

Consider the correct data type in queries Although an index should provide a fast query, Microsoft SQL Server either does not want to use that index at all or does not want to use it optimally. The caus

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...

Hi @aschenbrenner.bsky.social not sure what exactly you mean. But the blockers are in sys.dm_os_waiting_tasks and/or sys.dm_exec_requests.

Mabye that's what you are looking for?

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

Updating an expired SQL Server TDE certificate In this tip we cover how to update an expired SQL Server TDE certificate.

No, just replace it.

www.mssqltips.com/sqlservertip...

Next time I do. Good advice.
Thank you…

ISNULL() and SARGable queries Database developers like to use the ISNULL() function to check two conditions and compare them with a search value. This is often done with the intention of fin

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

Happy to see you both there…

Neue Straßenverkehrsordnung in Italien: Handy am Steuer, 1000 Euro Wer in Italien am Lenkrad mit dem Mobiltelefon hantiert, muss künftig mit drastischen Strafen rechnen. Auch Fahrern, die ihr Auto unter Alkohol- oder Drogeneinfluss steuern, drohen deutlich härtere Ko...

Why not in Germany, too?

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

Frauen nicht?

Optimize search for a random key value from a table Unit tests/demos in workshops and conference sessions sometimes require a random key value from an existing table. In this article I present a solution that acc

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.