len vs datalength - measuring data size | 21 June 2015 |
Changing a schema of an object in SQL Server | 06 June 2015 |
Nesting transactions and SAVE TRANSACTION command | 24 May 2015 |
ORDER BY and NULLS LAST in SQL Server | 14 March 2015 |
Checksum vs Torn Page Detection - performance | 25 April 2014 |
Full-Text Search - practical introduction [video] | 21 March 2014 |
Testing T-SQL script before execution | 09 March 2014 |
Moving Transaction Log file to a different location | 15 February 2014 |
Checking current IDENTITY value | 08 February 2014 |
View deadlock details in Error Log | 27 December 2013 |
Restore a backup on lower version of SQL Server | 25 November 2013 |