active newest hottest most voted
All questions
0
votes
0
answers
4
views

This query takes 3+ minutes to execute. How can I optimize this to perform better?

23 hours ago SA Dave 0
0
votes
0
answers
37
views

The SP is timing out after addition of 2 new filters of state and City

2 days ago SQLDB 37
0
votes
0
answers
7
views

Execution plan mystery

2 days ago NEERAJ PRASAD SHARMA 50
0
votes
0
answers
7
views

This needs to use less CPU

4 days ago SQLJeet 1
0
votes
0
answers
10
views

. Can this query performance be improved further? Will statistics or other indexes get better estimated row counts and hence better performance?

4 days ago ajc 0
0
votes
1
answers
19
views

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

6 days ago Juliano 16
0
votes
0
answers
10
views

Any ideas what can be done to improve performance here

6 days ago Ravi 1
0
votes
1
answers
43
views

Three Hour Insert

Jan 30 at 03:29 AM SQLkiwi ♦ 5.5k
0
votes
0
answers
125
views

Required Inputs on the Execution Plan

Jan 29 at 06:29 PM Sharath 1
0
votes
1
answers
18
views

Crazy large estimates from multiple joins on a CLRTVF

Jan 26 at 04:38 PM Dan Holmes 708
0
votes
1
answers
14
views

How to get better estimation?

Jan 25 at 05:59 AM Kai 1
0
votes
1
answers
16
views

COALESCE vs ISNULL and nested ISNULLs

Jan 23 at 11:48 AM SQLkiwi ♦ 5.5k
-1
votes
0
answers
12
views

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

Jan 22 at 09:11 PM DBNewbie_2007 0
1
votes
1
answers
36
views

Would a columnstore index improve this insert

Jan 20 at 09:07 AM RichardBrianSmith 65
0
votes
1
answers
14
views

Want to create "work" timeframe for view and baseline

Jan 18 at 02:39 PM JamesB 16

1 2 3 4 5 ... 34 next page »

posts per page 15 30 50