What Sessions Do You Want for the PASS 2010 Summit?
Survey was announced in the Connector on Wednesday, reposting the link here. We need your thoughts on this!
http://www.zoomerang.com/Survey/WEB22ADZ7NCK9A
2010-03-25
674 reads
A Fan and a Friend
I went to the UK SQL Server User Group in Cambridge on Wednesday. I’m not sure it’s the Cambridge group...
2010-03-25
688 reads
Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
536 reads
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,100 reads
Goodbye Live Spaces, Hello WordPress
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
662 reads
Meeting Offsite and a Little Vacation
I’m heading to our “publishing summit” today at one of the Cambridge University buildings. I’m a part of the group...
2010-03-24
785 reads
Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,405 reads
PASS Update #27
I’m just back from the March 2010 Board meeting and it went better than usual (for any meeting). Most of...
2010-03-24
596 reads
Getting Stubborn Chief Executive Officers to Listen: Speak Their Language
After consecrating several posts on workplace bullying, and hearing our great Steve Jones rant about Toshiba’s lack of action regarding...
2010-03-24
1,967 reads
Avoiding Plagiarism
Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...
2010-03-24
1,925 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