Halo 4 and Hadoop
A case study shows how the combination of Azure and Hadoop helped the Halo 4 team grow their successful franchise.
2013-03-28
246 reads
Editorials
What Do You Want to Know About I/O?
Steve Jones is looking forward to learning more about I/O. There is a panel of experts, taking questions at SQL Intersection in a few weeks.
2013-03-27
240 reads
A Good Security Response
Evernote recently had a security incident and forced all users to reset their passwords. Many people thought this was a good response to a security incident. Would your company act in a similar manner?
2013-03-26
122 reads
Car Data
Today's automobiles might collect more data than you think. All that might data gives us opportunities to find new and interesting ways to use this data with software.
2013-03-25
167 reads
What Counts for a DBA: Laziness
Louis Davidson is willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined.
2013-03-25
293 reads
Toggle Switches
SQL Server has grown and expanded to provide administrators and developers with a great deal of information on how it processes queries. However Steve Jones asks if you want more information and options for tuning.
2013-03-22
116 reads
Zettabytes and Beyond
The growth of data, and the sheer scale of data we store and manage is stunning. Steve Jones looks at the rates of growth these days.
2013-03-21
175 reads
Stop, Smell, Smile
On this quiet Friday, Steve Jones skips a poll and talks about life. This editorial was originally published on Jun 6, 2008. It is being republished as Steve is on vacation.
2013-03-20 (first published: 2008-06-06)
261 reads
Serious Storage
Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.
2013-03-19
219 reads
The Backup Process
Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.
2013-03-18
206 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