SQL Server Articles, Tips and Tricks
OUTER APPLY(SELECT TOP 1) pattern is widespread, even baked into some frameworks like Entity Framework. But is it a good practice? This demo will show. Based on a real-world optimization problem and solved with great success. The demo shows it …
There is no official information (that I am aware of) on how to calculate maximum capacity one can get from physical disks of different sizes in Storage Spaces. Based on partial documentation and logic, I got the formula that all …
If you still leave your databases at default settings, namely default isolation (READ COMMITTED – does it suck?), you are risking three things: increased blockage and deadlocks NOLOCK hints everywhere exposing users to dirty read issues wrong results! The third …
Did you know that SUM() aggregate can be used together with OVER() clause? A short intro to windowing functions:
|
1 2 3 4 |
SELECT SUM(Amount) OVER() -- What!? FROM dbo.PersonCityAmount |
The result is graphically visualized by using only SQL Server Management Studio and unicode characters:
Have you noticed that storage is a major bottleneck in all cloud providers (Azure, AWS, Google Cloud)? Machine throughput (total MB/s) for storage is severely limited. Even on very expensive server VMs they give you not much more than about …
Introduction If you are in search for a good ORM, keep reading. Alan Hyneman, the author of SQLPlus.net was very kind to give an interview and answer tough questions that a developer might ask. Feel free to ask more in …
When multiple sessions insert into the same table, and something unique is there (uq index, uq constraint), a “duplicate key” error (2601, 2627) occurs from time to time, almost inevitable. If your app is affected with intermittent “duplicate key” surprises, …
Introduction EVERYBODY should read this! Whether you have a big database that needs speed, or other valuable data like documents or just personal pictures you do not want to lose when disk fails (disks DO fail without notice, just a …
Introduction There are thousands of indicators (Perfmon Counters, system views, …) one can track to monitor SQL Server, but not all of them are relevant. If I need to pick one, that would be “Processes Blocked”.
While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because GUI integration with new SSMS versions were different every time and too much for my poor csharp knowledge. I am a DB guy after …
