Instant SQL Masterpieces
Some common operations if done in a classic way will take ages on big tables. That …
TSQL and SQL Client Code
How to pass arrays to SQL? TVP – The Ultimate Guide
You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide …
How to pass arrays to SQL? TVP – The Ultimate Guide Read more →
How NOT to use CROSS APPLY
OUTER APPLY(SELECT TOP 1) pattern is widespread, even baked into some frameworks like Entity Framework. But …
Have SUM() fun!
Did you know that SUM() aggregate can be used together with OVER() clause? A short intro …
SQLPLUS.net – an interview with Alan Hyneman
Introduction If you are in search for a good ORM, keep reading. Alan Hyneman, the author …
Insert if NOT exists – duplicate key problem
When multiple sessions insert into the same table, and something unique is there (uq index, uq …
sp_xdetails – index and table info
While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because …
Plan Cache Tsunami
Your SQL Server may be slow for a peculiar reason: a run-away query that pushes-out all…
SQL Profiler for Developers and Testers
Introduction You developed a new TSQL code and want to check is there a slow SQL …
ROWVERSION/TIMESTAMP skipping rows problem
Do you use ROWVERSION/TIMESTAMP to pull changed data? If you do, you might experience a problem …
