Inconsistency
This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.
2013-03-15
140 reads
Editorials
The Gambler
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
2013-03-14
223 reads
Resetting DMVs
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
2013-03-13
190 reads
Self Describing Databases
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
2013-03-12
376 reads
Cloud Services. Waiting for the 'paint to dry'?
Despite recent 'outages', The canny CIO will make use of the obvious advantages of public cloud services where it risks neither security or availability. Adoption of the Cloud services and platforms is going to be most effective where the Cloud’s advantages of rapid scalability can be harnessed.
2013-03-11
86 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest. This editorial was originally published on May 20, 2008. It is being re-run as Steve is on vacation.
2013-03-11 (first published: 2008-05-20)
415 reads
2013-03-08 (first published: 2008-05-09)
194 reads
Productivity and Accountability
The recent decision by Yahoo to end telecommuting elicits some comments from Steve Jones on the topic of remote work.
2013-03-07
171 reads
Two Plugs Away
The culture and practices at Valve are interesting to Steve Jones, but the desks really caught his eye.
2013-03-06
172 reads
Data We Don't Want
There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.
2013-03-05
203 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