The Rules of Gibbs
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
853 reads
Blog Posts
The Standing Desk Experiment
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow...
2012-05-29
1,963 reads
Always restore with NORECOVERY
Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not...
2012-05-28 (first published: 2012-05-24)
7,068 reads
Denali – Day 28: CDC for ORACLE
Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture...
2012-05-28
1,361 reads
NVARCHAR(n) Vrs NVARCHAR(max)
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around...
2012-05-28
7,957 reads
On my way to DevTeach in Vancouver
Just stepping out the door on on my way to the DevTeach / SQL Teach conference in Vancouver, BC, Canada. The...
2012-05-28
974 reads
Rolling out Windows 8 Client: First Impressions
A virus found it’s way on to my system through a trojan horse, past all the security & anti-virus software. I...
2012-05-28
1,041 reads
SQL Server – DDL vs. DML Triggers
Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.
Similarities between DDL...
2012-05-28
1,641 reads
The Importance of Regular Blogging
Between my old website, which I started back in 2007 (which has since disappeared) and my blog, which I switched...
2012-05-28
1,039 reads
Unsubscribing
One of the things I’ve been doing lately is pruning (again) the number of newsletter type emails I get. Some...
2012-05-28
835 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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...
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