-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Gavin Draper's SQL Server Blog

Software Dev/DBA living the dream in sunny Brighton, UK. I've been playing with SQL Server about nearly 20 years now and still feel just as clueless as I did back then. I love writing about things I find as I go along.

Archives: November 2018

SQL Server Guide To NULL Handling

Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite nasty unexpected results.

In some languages NULL == NULL will be true and in others it will be false, SQL has a couple of caveats around this to be aware… Read more

0 comments, 2,990 reads

Posted in Gavin Draper's SQL Server Blog on 29 November 2018

Live Query Stats of Running Queries

Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives you feedback as it runs). If you’ve not seen this before then you can give it a go by…

Read more

0 comments, 210 reads

Posted in Gavin Draper's SQL Server Blog on 24 November 2018

Live Query Stats of Running Queries

Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives you feedback as it runs). If you’ve not seen this before then you can give it a go by…

  1. Connect to any SQL Server instance from 2014 SP1.
  2. Find a…

Read more

0 comments, 2,065 reads

Posted in Gavin Draper's SQL Server Blog on 24 November 2018