2,081 reputation
711
bio website SankarReddy.com
location
age
visits member for 3 years, 4 months
seen Dec 10 '13 at 23:14

Sankar is a Database Engineer/DBA currently working for FunMobility, a mobile media entertainment company. He has been working with SQL Server from 2003 in a variety of roles including development DBA, Database administrator, Report writer and datawarehouse developer. Currently he works with high traffic OLTP and Tera byte datawarehouse systems. Sankar spends most of his free time at MSDN social forums answering questions.

http://SankarReddy.com


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
Sep
29
awarded  Nice Answer
Jul
25
revised Role db_ddladmin not working properly on SQL Server 2008
added 401 characters in body