Spring Training 2010
Life was busier than I would have liked this year, but made it to one game, Braves vs Tigers, for...
2010-04-08
283 reads
Blog Posts
SQL University Starting Back Up
Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...
2010-04-08
746 reads
What Do I Need to Do After Moving a Database to SQL 2005/2008?
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
404 reads
2010 Goals – First Quarter Review
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
Community...
2010-04-07
482 reads
A DMV a Day – Day 7
I have three different DMVs for Day 7. The first one is sys.dm_db_missing_index_group_stats, which is described by BOL as:
Returns summary...
2010-04-07
1,231 reads
How Do I Identify Invalid or Unneeded Logins?
Introduction
I was looking at one of my servers and was caught off-guard by how many individual users had been granted...
2010-04-07
528 reads
How Silly
Have you ever done anything that made you feel like a dunderhead? Maybe a little bone-headed, thick, numb-skullish?
Here is my...
2010-04-07
569 reads
New MSSQLTips Article: Nesting Database Roles in SQL Server
I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...
2010-04-07
1,682 reads
SQLSaturday Orlando 2010 - The Planning Begins
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
429 reads
Test Driving a LinkedIn Poll
Had this on my list for a while, thinking maybe it’s a way to leverage the investment in my (your)...
2010-04-07
259 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