Priorities and Productivity
Managing a complex workload is a skill many of us need to acquire and maintain. Today Steve has a few ideas on how to do that.
2019-10-09
214 reads
Editorials
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
195 reads
T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
425 reads
Which Service in Azure Should You Use for SQL?
I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
2019-10-05
499 reads
Documenting with Tests
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
284 reads
2019-10-03
241 reads
Searching for Answers Inside
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
2019-10-02
156 reads
It's Natural to Avoid Problems
Culture change is hard, and it's one of the most difficult things to implement when trying to get your team to work in a DevOps fashion.
2019-10-01
242 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
216 reads
Celebrate Success
Today Grant reminds us to not only think about the things we can do better, but remember the good things that we accomplish.
2019-09-28
216 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