Hybrid Databases
We are getting more and more types of data that we have to manage and store in our databases. Steve Jones notes that SQL Server can handle almost all your needs.
2013-09-30
219 reads
Editorials
Dating Your Employer
Looking for a new job? Want to pick the best one? Your employer probably feels the same way. Andy Warren talks about how your interview is more like dating than you think.
2013-09-27
376 reads
2013-09-26
291 reads
2013-09-25
199 reads
The Human Cost of Managing Data
There's a cost to managing data that isn't always considered: the human cost. Additional stress, work, and load can result in less than efficient management, even when you contain hard costs.
2013-09-24
152 reads
Citizen Scientists
The increasing power and shrinking size of computing devices means that more and more people can gather and analyze data. Steve Jones talks about some opportunities.
2013-09-23
112 reads
Can SQL Server do ‘Big’?
Can SQL Server scale? Phil Factor has a few thoughts on the capacities that SQL Server can scale to.
2013-09-20
311 reads
Opportunities Abound
We have so many ways in which we can grow our SQL Server careers. Steve Jones shares a few today.
2013-09-19
258 reads
Job Worries over Automation
Are you worried about your job in the future? Steve Jones thinks you shouldn't be.
2013-09-18
197 reads
Sensors and Data
In the future we'll have a more programmable world, but it will be driven more by data than software.
2013-09-17
115 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