T-SQL Queries Archives - Page 14 of 17

Another argument for stored procedures

Aaron Bertrand (@AaronBertrand) talks about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.

Aaron Bertrand ◆ May 17, 2013

15

Schema Switch-A-Roo : Part 2

Aaron Bertrand (@AaronBertrand) goes into a little more detail about what happens to metadata when you use schema transfers behind the scenes.

Aaron Bertrand ◆ April 30, 2013

5

How filtered indexes could be a more powerful feature

Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items!

Aaron Bertrand ◆ April 24, 2013

4

The Case of the Cardinality Estimate Red Herring

SQLskills' Joe Sack (@josephsack) walks us through an interesting scenario where we might blame a query performance issue on parameter sniffing or bad statistics, when it actually turns out that a check constraint is the best solution to keep the optimizer honest.

Joe Sack ◆ April 19, 2013

5

How expensive are column-side Implicit Conversions?

Jonathan Kehayias (@SQLPoolBoy) demonstrates column-side implicit conversions and the impact they can have on a workload. He concludes that you can only throw hardware at this problem for so long; a design or code change will be necessary to solve the performance issue long-term.

Jonathan Kehayias ◆ April 15, 2013

7

Sample Size and the Duration of UPDATE STATISTICS: Does It Matter?

Erin Stellato (@erinstellato) of SQLskills.com tells us about statistics, sample size and the impact different choices can have on duration and subsequent queries.

Erin Stellato ◆ April 10, 2013

8

Optimizer Limitations with Filtered Indexes

Paul White (@SQL_Kiwi) makes some great points about limitations in SQL Server's optimizer, and things you need to watch out for, when it comes to filtered indexes.

Paul White ◆ April 4, 2013

18

The Problem with Window Functions and Views

Paul White dissects a few execution plans and explains why SQL Server can sometimes have problems optimizing views that incorporate window functions.

Paul White ◆ March 20, 2013

9

Obfuscate sensitive data in your execution plans

Getting help with execution plans outside of your company can be a challenge, since you may not be willing to share information such as server names, database names, object names, schema, column names, index structure, and so on. Read on to see how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.

Aaron Bertrand ◆ March 1, 2013

2

The Halloween Problem – Part 2

In the first part of this series, we saw how the Halloween Problem applies to UPDATE queries. In this post, we will see how the same underlying issue can affect INSERT and DELETE statements.

Paul White ◆ February 15, 2013

4

The Halloween Problem – Part 1

Much has been written over the years about understanding and optimizing SELECT queries, but rather less about data modification. This series of posts looks at an issue that is specific to INSERT, UPDATE, DELETE and MERGE queries – the Halloween Problem.

Paul White ◆ February 13, 2013

9