Subscribe to this blog
Archives: February 2013
Cost Threshold for Parallelism
Parallelism, where to start? Well let’s start right at the beginning shall we with the question, what is parallelism? Simply put it is a feature of SQL Server which allows queries to utilize more threads in order to complete quicker. There are several ways to influence SQL Servers decision whether…
0 comments, 306 reads
Posted in SQL Server 365 on 26 February 2013
Fun with dates
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it is a long weekend where we camp close to the airfield and get to take in three full days (if you include Friday practice of utterly breath-taking aerobatic displays from…
0 comments, 169 reads
Posted in SQL Server 365 on 17 February 2013
T-SQL Gotcha
I came across an interesting issue a few days ago that I thought I would blog about. The issue is replacing NUL characters from values in SQL Server, more specifically using REPLACE(). Take the below TSQL which runs but will never complete;
DECLARE @var VARCHAR(MAX
0 comments, 319 reads
Posted in SQL Server 365 on 15 February 2013
Script Replication with PowerShell
I promised you some PowerShell scripts this year and this post is the first one. I can see the value PowerShell can bring, but find it equally frustrating. I don’t know the syntax very well or all the command lets and personally for 99.9% of my daily tasks I can…
0 comments, 415 reads
Posted in SQL Server 365 on 14 February 2013