Speaking Twice This Week
This week I will have the opportunity to speak at two different events. The first is on Monday, April 12th,...
2010-04-11
455 reads
Blog Posts
5 Random Thoughts on the SQL Server MCM Program
5 Random Thoughts on the SQL Server MCM Program
I've had some random thoughts running through my head since I finished...
2010-04-10
3,525 reads
A DMV a Day – Day 10
Just in case you’ve just joined me, I decided on April 1 to post a different DMV query every day...
2010-04-10
1,830 reads
2010-04-10
596 reads
A DMV a Day – Day 9
The DMV for Day 9 is sys.dm_os_schedulers, which is described by BOL as:
Returns one row per scheduler in SQL Server...
2010-04-09
964 reads
Cloud Computing - Will Data Breaches Cost More?
That's the main point from the following article:
Video: Data breaches to cost more in the cloud
The cost was calculated per...
2010-04-09
1,043 reads
How do I ... Write a Backup Strategy?
How do I Write a Backup Strategy?
DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit...
2010-04-09
970 reads
Learn How Vendors Price Their Software
As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me,...
2010-04-09
1,364 reads
Prius Update – Three Years In
I’ve had the Prius for 3 years as of Mar 31, 2010, and it’s been a great car for us....
2010-04-09
387 reads
Reporting Services 2008 R2 KPI Ready
As I begin to explore more and more of the new feature that will be available in SQL Server 2008...
2010-04-09
1,844 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
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
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