Spring 2015 Advanced Programming in SQL Server
The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course...
Spring 2015 Advanced Programming in SQL Server
The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course...
Fall 2014 Advanced Programming in SQL Server
The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...
Fall 2014 Advanced Programming in SQL Server
The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...
READPAST: what is it good for?
After my last post about monitoring deadlocks, I will now show a way to prevent deadlocks and unnecessary locks and to improve system...
CASE Study
Sometimes we want to populate a table with random data, mainly for testing purposes. For example, let’s consider the following table:...
Truncating and Rounding Results
Last month, in the SQL Server Users Group meeting, I presented a session called “Things You didn’t Know about SQL Server”. The first...