SSD Lifetimes
This week Steve Jones looks at the expected lifetimes of SSDs and finds one that might be a nice upgrade for your system.
2012-11-19
261 reads
Editorials
The Cost of Storage
As DBAs we constantly need more storage, but do we know what the impact or cost of this storage is to our employers? Answer this week's poll.
2012-11-16
146 reads
Failure Lessons
Steve Jones would like to see more disclosure about what works and doesn't work when deploying new systems and software.
2012-11-15
135 reads
The Future of DBAs
What's the future for DBAs with cloud services and computing? Steve Jones talks about what might be coming soon.
2012-11-14
359 reads
Too Much Data
Are you managing too much data? Lots of data professionals feel that way, but fortunately "Big Data" is in the news and bringing more visibility to the challenges we face on a daily basis.
2012-11-13
186 reads
Monitoring is Essential
One of the keys to better availability, scalability, and performance on your systems is understanding what is happening in the instances. That requires monitoring, which Steve Jones sees as essential.
2012-11-12
289 reads
The Data We Give Away
We're all used to storing and protecting data, but how often to we consider the data we're generating every day?
2012-11-12
77 reads
What Do You Want from SQL in the City?
After the SQL in the City tour wrapped up this week in Seattle, Steve Jones looks back and asks a question. What type of training would be best for you.
2012-11-09
144 reads
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2012-11-08
214 reads
Savvy Managers
Data quality is everyone's business and it takes some work. Steve Jones talks about some hints for you and your manager to make things better in your data systems.
2012-11-07 (first published: 2007-11-27)
172 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