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
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
Oh, Bother Sometimes, you only wanna work on one thing. Other times, you only wanna work on something if it’s…
2019-04-24
Date Debate Searching dates is a common enough task. There are, of course, good and bad ways to do this.…
2019-04-22
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
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
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
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
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
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
This week, I’ve been writing about how SQL Server 2019’s bringing a few new features to mitigate parameter sniffing, but they’re more complex than they appear at first glance:...
2019-04-11
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers