Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
12 reads
Blog Posts
SQL Server Professionals: NYC Summer Spectacular! Training & Events
This is a very exciting summer to be in New York City! We’re not just talking Central Park, the Theatre...
2012-06-04
1,617 reads
Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?
Is it just me, or does there seem to be a lot of discussion these days about testing backups and...
2012-06-04
1,524 reads
Tips to avoid deadlocks?
A database server should be able to service requests from a large number of concurrent users. When a database server...
2012-06-04
3,391 reads
Jacksonville IT Pro Camp
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,240 reads
SQL Server Service Broker Explained
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
209 reads
Investment for DBA Career
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....
2012-06-02
1,070 reads
Max Server Memory
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,184 reads
Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
904 reads
I’m Going on Tour
I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I...
2012-06-01 (first published: 2012-05-30)
2,271 reads
Blogs
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...
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...
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