Single-Row Deadlock
Introduction Demonstration of the smallest possible deadlock: only one statement, one table, one row. Without transactions …
TSQL and SQL Client Code
Query with optional filters (catch-all query)
In almost every database we have a process that filters the same data with different filters.…
Formatting TSQL code
How do I format my TSQL code? Everybody has it’s own preferences on formatting SQL or …
CommandTimeout – How to handle it properly – code example
Properly closing a connection to Sql Server in DotNet is more challenging than one might think. …
CommandTimeout – How to handle it properly – code example Read more →
CommandTimeout – How to handle it properly?
ADO.Net Data Provider for SQL Server (System.Data.SqlClient namespace in System.Data.dll assembly) has two common classes we …
Sort records without ORDER BY?
How often you see some smartie “optimizes” the query by removing ORDER BY, justifying that query …
READ COMMITTED sucks!
Are you still using READ COMMITTED transaction isolation level? Default transaction isolation level on all SQL …
