Get SQL Command Compile time
1. SET STATISTICS TIME ON
It not only tell you the compile time of sql command, but also show you the...
2013-09-19
10,193 reads
Blog Posts
Hit Fast Forward: Converting and deploying DTS packages
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
520 reads
How to Split a string by delimited char in SQL Server..............
However I posted this one in one of my post.
Querying Microsoft SQL Server : Functions in SQL Server: Functions in SQL...
2013-09-19
628,621 reads
Introduction to Integrity: Data Purity Errors
The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL...
2013-09-19
1,111 reads
Power BI for Office 365 preview released
I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was...
2013-09-19
1,076 reads
PowerShell – Script to Monitor a Service on a Group of servers – HTML Formatted Email Output
This post explains how to monitor a given service on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets...
2013-09-19 (first published: 2013-09-17)
3,248 reads
Practical PowerShell: Merge SQLSaturday Speaker SpeedPASSes Into One PDF
To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of...
2013-09-19
1,399 reads
SQL Lighthouse
Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of...
2013-09-19
820 reads
SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)
Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...
2013-09-19
695 reads
What to do next certification wise
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
706 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers