Sad Sack – Hardware Failures all over
I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:
iPod iTouch...
2010-04-20
646 reads
Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
617 reads
SQL Server Agent
Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU...
2010-04-20
382 reads
Review: Ninite
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
631 reads
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,096 reads
How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
313 reads
Missing European PASS (Updated)
As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US...
2010-04-19
463 reads
Missing European PASS
As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US...
2010-04-19
871 reads
SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)
Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this...
2010-04-19
1,088 reads
Powershell Script for Verifying Space
First let me say, I know my Powershell skills are sub-par. I’m working on it. Slowly but surely. That said,...
2010-04-19
1,209 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers