Executing scripts on multiple servers the easy way
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...
2014-07-03
2,392 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for...
2014-07-03
6 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality...
2014-07-03
1,737 reads
Reflections on the 2014 PASS Summit Selection Process
Oh we are a bunch of high school kids at heart. Maybe high school never ends (and there’s a nightmare,...
2014-07-03
1,122 reads
SQL Server 2014 New Features
SQL Server 2014
Below is a listing of the SQL Server 2014 new features and where you can find more information...
2014-07-02
1,948 reads
The Selection Process
According to this post from Amy Lewis (PASS Board of Directors) there were 943 abstracts submitted for the 2014 PASS...
2014-07-02
576 reads
The Case Of the Downward Pointing Arrow-Question of the Day
The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at...
2014-07-02
443 reads
Above Reproach
It’s been a busy few weeks in the world of PASS, lots of good conversations that I’ve followed with interest,...
2014-07-02
873 reads
Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !
The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since...
2014-07-02
9 reads
Speaking at ONETUG on July 10, 2014
I’ll be presenting SQL Server Performance for Developers to the members of the Orlando .Net User Group (ONETUG) on July...
2014-07-02
484 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