Eight Words
I remember a lot of things about that day. It was July in Texas, which is to say, it was...
2012-05-03 (first published: 2012-05-02)
2,562 reads
Blog Posts
OFFSET and FETCH Query Options in SQL Server 2012
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...
2012-05-03
114 reads
OFFSET and FETCH Query Options in SQL Server 2012
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly...
2012-05-03
540 reads
On the road less traveled: a DBA Roadmap review
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,374 reads
Patience
Update: This is confirmed by Snopes.
A NYC Taxi driver wrote:
I arrived at the address and honked the horn. After waiting...
2012-05-03
2,913 reads
Slowing Changing Dimension (SCD) demystified – Part 1
SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are...
2012-05-03
707 reads
SQL Rally–1 week out
It’s hard to believe that after all the hard work, planning, and prep, that SQL Rally Dallas is just a...
2012-05-03
918 reads
Win a Free SQLRally Admission!
As those of you in our local North Texas SQL Server User Group are aware, we have given away one...
2012-05-03
821 reads
Building an Intel Ivy Bridge Desktop System, Part 2
A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm...
2012-05-02
1,881 reads
Choosing the Right Microsoft Reporting Technology Part 6: Making the Decision
We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”. Which tool(s) is the best...
2012-05-02
2,032 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