Querying Information from the Plan Cache, Simplified
One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...
2012-07-02
1,502 reads
Blog Posts
RSS pubDate format in SQL Server
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
392 reads
Speaker Selection for SQLSaturday Orlando-Group #3
So far we’ve selected 8 speakers for SQLSaturday #151 in Orlando this year (see Group #1 and Group #2), today...
2012-07-02
759 reads
Three reasons for normalization
In this article we cover three reasons for normalization (from our point of view). We created the article and included...
2012-07-02
291 reads
Want a Sean-made Precon? You got it!
Sean’s giving a precon at SQL Satrurday 163 this October! Oh yeah, and so are Tim Mitchell and David Stein....
2012-07-02
767 reads
Why Isn’t Everyone Accountable? A Work Conundrum
A pattern I’ve seen over and over again at many different jobs is that some people are not held accountable...
2012-07-02
773 reads
Database Interview questions
I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.
2012-07-01
974 reads
Determine space used for each table in a SQL Server database
I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...
2012-07-01
4,438 reads
Lost in Translation – Deprecated System Tables – Introduction
When SQL Server 2005 launched, it included a slew of dynamic management objects (DMOs) that were meant to replace the...
2012-07-01
1,113 reads
Lost in Translation – Deprecated System Tables – sysaltfiles
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-01
1,637 reads
Blogs
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...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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