Data Loss
A new study shows potential corruption issues with solid state drives when power is cut under a load. That can have implications for data professionals as more databases incorporate SSD storage.
2013-03-04
158 reads
Editorials
Why SQL Server?
This Friday Steve Jones asks you how you got started working with SQL Server in your career? Let us know how you got started and why you stuck with it.
2013-03-01
278 reads
More Evolution, More Complexity
As SQL Server advances and evolves, Steve Jones thinks it gets more complex, not necessarily easier to administer.
2013-02-28
126 reads
The Microsoft Sideshow
Microsoft hasn't performed well on the stock market across the last decade, but the company has changed. There are cries that the business has been mismanaged and today Steve Jones has a few comments.
2013-02-27
175 reads
Look Beyond the First Result
As computer systems become more complex and dynamic, it's possible that the results we see might not be what we expect. Steve Jones talks about a situation with Orbitz.
2013-02-26
137 reads
Deploying Databases to the Azure Cloud: an extended plea
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
195 reads
The Dark Side
Steve Jones talks a little about Oracle after speaking at an event devoted to that technology.
2013-02-25
213 reads
Early Software
This week Steve Jones reminisces about the first software he used. He asks you what inspired you to start working with computers.
2013-02-22
120 reads
Fix the Little Things
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed. Today's editorial was originally published on Nov 11, 2008. It is being re-run as Steve is out of town.
2013-02-21
154 reads
Life is Like a Manure Spreader
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about. Today's editorial was originally published on Nov 3, 2008. It is being re-run as Steve is out of town.
2013-02-20 (first published: 2008-11-03)
222 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