It’s always parameter sniffing: Line Endings
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
934 reads
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
934 reads
Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...
2019-02-27
1,439 reads
To add onto yesterday’s post about which cardinality estimator (CE) your query will use, there’s an additional complexity. This specifically...
2019-02-26
789 reads
SQL Server 2008 is reaching end of support this year, so upgrading your SQL Server might be on your mind....
2019-02-25
367 reads
Happy Friday! We made it. Here’s something I came across while testing optimize for ad hoc for this week’s blog...
2019-03-11 (first published: 2019-02-22)
2,093 reads
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
332 reads
Yesterday’s post talked about single use plans. The statements I’m using are also called ad hoc queries. The alternative to...
2019-02-20
196 reads
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,170 reads
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
2019-02-18
142 reads
Happy Friday! Today’s post will be light on the performance side and instead, I’m going to talk about how to...
2019-02-15
781 reads
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
HI We have a small utility that is giving us a "#table is missing...
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Hi All, As part of security compliance, we are told to audit DML &...