Disaster After Disaster
A disaster can easily lead to another disaster. Can you respond to multiple problems? Have you even considered the cascade effects of a large disaster?
2012-12-12
226 reads
Editorials
Test Your Restores
Part of an effective response to a disaster situation is practice and testing of your skills and procedures. Steve Jones reminds us this is important today.
2012-12-11
153 reads
Grace Under Pressure
When a disaster strikes, how will you respond? Will you not only successfully recover, but will you do so with professionalism and grace under pressure? Steve Jones tells you how you can.
2012-12-10
140 reads
What Counts for a DBA: Being Replaceable
Louis Davidson describes why all DBAs should strive to be replaceable, and what that really means.
2012-12-10
334 reads
Keynotes
This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing. This editorial was originally published on Jan 11, 2008. It is being re-run as Steve is traveling.
2012-12-07 (first published: 2008-01-11)
82 reads
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes. This editorial was originally published on Apr 3, 2008. It is being re-run as Steve is out of town.
2012-12-06 (first published: 2008-04-03)
494 reads
Type A, B, or C
Do personality types matter and did you know there are more than just A or B types? This editorial was originally published on Feb 26, 2008. It is being re-run as Steve is traveling.
2012-12-05 (first published: 2008-02-26)
290 reads
The Default DBA
Defaults are important since so many people just accept them. Steve Jones thinks that SQL Server needs to add more defaults to the setup program that might help DBAs better manage their systems.
2012-12-04
236 reads
Feedback is Encouraged
Microsoft is asking for feedback, more and more from customers. Steve Jones sees that as a good thing.
2012-12-03
65 reads
Grow Your Skills
The idea of moving to the cloud is scary, but it will happen for many of us. If not at this job, perhaps at the next. Learning more about the cloud is something Steve Jones thinks you should consider.
2012-12-03
442 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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...
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