Why Plan Cache Scripts Can Be Misleading
A Long Way From Home Most scripts (even ones I’ve worked on!) that look at the plan cache, have had…
2019-04-26
Database Performance
Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
The post Yes, pulling just the data...
2019-04-24
When READPAST Doesn’t Read Past
Oh, Bother Sometimes, you only wanna work on one thing. Other times, you only wanna work on something if it’s…
2019-04-24
Slightly Less Not SARGable
Date Debate Searching dates is a common enough task. There are, of course, good and bad ways to do this.…
2019-04-22
Which Database is Causing the Problem?
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first? Here are a few ways you can pick...
2019-04-17
Index scans aren’t always bad, and index seeks aren’t always great.
Somewhere along the way in your career, you were told that: Index seeks are quick, lightweight operations Table scans are ugly, slow operations And ever since, you’ve kept an...
2019-04-16
Have Your Batch Updates Become Unmanageable?
Look, I’m telling you this as a friend. Seriously, it’s time to let go of your batch updates. It’s not a...
2019-04-16
When Inline UDFs are Slower
Brent Ozar has been digging deep into new functionality in SQL Server 2019: In the Froid white paper, Microsoft talked about how they were working on fixing the function...
2019-04-15
Intelligent Query Processing FAQ
Joe Sack answers a number of questions about intelligent query processing in SQL Server: You have batch mode adaptive joins, but no row mode adaptive joins. Why?Adaptive joins are...
2019-04-15
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?
First appeared on Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
2019-04-14
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers