Reputation
2,121
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
8 12
Newest
 Yearling
Impact
~189k people reached

Apr
1
awarded  Yearling
Sep
24
awarded  Autobiographer
Jul
28
awarded  Enlightened
Jul
28
awarded  Nice Answer
Apr
1
awarded  Yearling
Jan
16
awarded  Enlightened
Jan
16
awarded  Nice Answer
Apr
1
awarded  Yearling
Nov
6
awarded  Nice Answer
Sep
10
comment Retrieve XML of large plan from plan cache
As an alternative, How abt save the results to a file and view from there?
Jul
11
comment Mitigate negative effects of shrinking
@RemusRusanu Ha, I see how I misread Shrinking with physical disk defrag. Thanks for making me read clearly.
Jul
10
comment Mitigate negative effects of shrinking
@RemusRusanu Sorry abt the delayed response. sqlskills.com/BLOGS/PAUL/post/… sqlskills.com/BLOGS/PAUL/post/…
Jun
8
awarded  Caucus
May
18
comment How to boost performance of virgin queries in MS SQL Server?
When you are running sp_updatestats, what is the sample ratio you chose. Default ratio is very sample and depends on the size of the index. If your queries query mostly(only) the new data and even if you do sp_updatestats, SQL Server can't make god decisions on the execution plans.
May
18
comment How to boost performance of virgin queries in MS SQL Server?
#1 and #2 don't happen the way you are thinking. msdn.microsoft.com/en-us/library/ms191475(v=sql.105).aspx msdn.microsoft.com/en-us/library/aa337560(v=sql.105).aspx
May
18
comment How to boost performance of virgin queries in MS SQL Server?
Are your statistics up to date? Read-Only databases can't create statistics if they are missing or out of date. Is your data skewed or has unique values for the key. There are lot of factors that can cause this behavior.
May
18
comment Mitigate negative effects of shrinking
I think you need to do 1, 3 and 2. Because if you do 3 after 2 then your indexes will be fragmented.
May
18
answered How to boost performance of virgin queries in MS SQL Server?
Apr
1
awarded  Yearling
Sep
29
awarded  Necromancer