Answers.SQLPerformance.com - Archive

Required Inputs on the Execution Plan

Sharath 2016-01-29

Read More

OUTER APPLY to external table costs 49% of the entire execution plan

Juliano 2016-01-29 1

Read More

Why does the same query produce dramatically different plans with identical table data with different name used?

DBNewbie_2007 2016-01-22

Read More

COALESCE vs ISNULL and nested ISNULLs

Dan Holmes 2016-01-22 3 1

Read More

How to get better estimation?

Kai 2016-01-22 1 1

Read More

Crazy large estimates from multiple joins on a CLRTVF

Dan Holmes 2016-01-21 2 2

Read More

Three Hour Insert

RichardBrianSmith 2016-01-20 7 1

Read More

Would indexes on any of the Temp tables help this query ?

Pearljammer1 2016-01-15 2 1

Read More

Why does the lookup operation have no columns listed in the output list?

dgate 2016-01-14 2

Read More

Would a columnstore index improve this insert

RichardBrianSmith 2016-01-14 4 1

Read More

Want to create "work" timeframe for view and baseline

Erickson Winter 2016-01-13 1 1

Read More

Am I missing anything obvious while tuning this query ?

sqlzees 2016-01-12 4

Read More

on the nested loop (28.8%) i notice there is a no join predicate warning. How do I find which join and where the missing predicate is ?

Pearljammer1 2016-01-07 1

Read More

Lazy Spool causes the slow query

Kai 2016-01-06 2 1

Read More