We can kill a session by using KILL command. However, KILL command requires a positive number; executing KILL with negative number returns an error: Msg
Issues with CU6 for SQL Server 2014 SP1
Microsoft released an update to CU6 (link) for SQL Server 2014 SP1; this update was to address an issue where even having NOLOCK hint in
Dissecting SQL Server Execution Plans
Dissecting #SQLServer Execution Plan by @GFritchey.
Know How to Resolve Microsoft SQL Server Error 5172
Overview SQL Server is a relational database management system, developed by Microsoft that is used for storage and retrieval of data whenever required. Database on
SQL Server 2016 Launch Event in Edmonton SQLPASS
SQL Server 2016 release date is June 1st; to help get the moment started, Edmonton SQL Pass is holding a launch event on June 25,
SQL Skills: SQL Server Wait Types & Latch Classes Library
Microsoft has documented wait types and latches in a minimum fashion on books online; often there are wait types that are just not documented. Paul
SQL Canada (SQLCAN) 