We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see.
It should only take a few minutes, and three randomly-selected people will win a $100 Amazon gift card for their efforts.
2013-08-08 (first published: 2013-07-25)
4,695 reads
2013-07-02
1,764 reads
The sixth article in our series that looks at the results of the sp_Blitz™ script run against the SQLServerCentral servers.
2013-06-27
4,688 reads
We're looking for scripts that you use in your daily job to find, fix, and solve issues in your environment.
2013-05-30
1,794 reads
The fifth installment of the sp_Blitz script being run on the SQLServerCentral database server.
2013-05-29
7,007 reads
The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.
2013-03-21
6,969 reads
The second article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.
2013-01-15
5,628 reads
A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.
2013-01-10
10,077 reads
2012-12-25
927 reads
2012-11-22
1,476 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
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