A Billion Transactions
A billion transactions is a lot of activity on your database, however Steve Jones thinks more and more of us might see this on a regular basis. Microsoft's facilities group shows this to be the case.
2013-04-22
241 reads
Editorials
Excuses Execrating Excel
A bad workman always blames his tools. So does the entire western media, it seems, as poor old Excel gets it in the neck for some appalling calculation errors in economic papers.
2013-04-22
239 reads
Upgrading to 2012
Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.
2013-04-19
434 reads
Asking for Interview Questions
When someone asks for interview questions on the web, it seems many people are upset. But should they be? Steve Jones points out there are different sides to this.
2013-04-18
411 reads
The Patch Wild, Wild West
Microsoft might be changing their patching process for applications. This has Steve Jones worried they may move towards an Apple/iOS like model, which would not be good for server systems.
2013-04-17
185 reads
Don't Be a Ghost
If you want to further your career, you can't be a ghost. Steve Jones talks about the ways in which so many people might end up hurting their careers by trying to keep their lives too private.
2013-04-16
310 reads
Bad Data Costs Lives
Either data is right or it is wrong. There is no in-between. Phil Factor examines a recent scandal that hit the health care system in the UK to highlight why it's so important that we, as data professionals, ensure responsible use of data and respect for data quality.
2013-04-15
213 reads
Modeling the Earth
Microsoft Research has a variety of interesting projects underway, including one to try and model the Earth. Many of these involve lots of data in some way, and would be interesting projects to work on, according to Steve Jones.
2013-04-15
123 reads
The DBA Office
The environment in which we work can have an affect on the way in which we work. Steve Jones asks today if you have a preference for your environment.
2013-04-12
231 reads
Don't Accept Defaults
All software has default values, some of which might not suit your environment. This is especially true with regards to security settings.
2013-04-11
107 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