#Tl;dr article (time constraints prevented me from reworking significantly)
An article on SQL-Server-pro was forwarded over to me to research by...
2015-01-08 (first published: 2015-01-05)
8,459 reads
Today, I was reminded that global temp tables scope lasts for the session, and doesn't last beyond that. The difference...
2015-01-05
753 reads
currently on version 14.60
I'm a big fan of finding tools that help automate and streamline things that should are routine...
2014-12-24
1,342 reads
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
933 reads
I was looking for an efficient way to eliminate overlapping days when provided with a historical table that provided events...
2014-10-16
775 reads
If you want to create sample random samples when dealing with date calculations to test your results, you can easily...
2014-08-12
508 reads
Common date values you may need to reference that you may not want to write from scratch each time.
Hope...
2014-08-12
1,026 reads
A step by step explanation on one way to get a consecutive period of months, which could easily be adapted...
2014-05-19
641 reads
Ran across a comment the other day that scalar functions prohibit parallelism for a query when included. I thought it...
2014-02-11
844 reads
If you run across migrating or copying a database structure for some purpose, yet need to change the database references...
2013-08-13
1,919 reads
By HamishWatson
This blog post is about a situation where you are capitalising an argument in...
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
Create TABLE #TableA ( TaskNameA nvarchar(100), GovernA bit, ToolTypeA nvarchar(10), ResourceNameA nvarchar(100) ) Create...
I am trying to the code function to determine if a particular application is...
I am trying to patch my SQL server with CU8 and GDR for SQL...
Ask SSC