A Identity Bug
Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
drop table aa
create table...
2010-04-29
2,227 reads
Blog Posts
News
If you follow me on Twitter or are my friend on Facebook, you might already know the news. I am joining...
2010-04-29
2,019 reads
PASS Update #29
By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS...
2010-04-29
1,462 reads
SQLSaturday #41 - Atlanta Session Recap
Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...
2010-04-29
1,449 reads
When was SQL Server last restarted?
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,181 reads
A DMV a Day – Day 28
The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...
2010-04-28
1,265 reads
Backup Compression in SQL Server 2008 – The Complete Presentation
From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.
Turn it...
2010-04-28
2,369 reads
How to Tell When SQL Server Started?
As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...
2010-04-28
1,859 reads
Social Networking and SQLSaturday
I think we do a pretty good job of delivering technical content, but not such a great job at getting...
2010-04-28
1,468 reads
SQL Server Connection Strings
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,590 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