network profile
| bio | website | SankarReddy.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years, 1 month |
| seen | Apr 9 at 23:08 | |
| stats | profile views | 57 |
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.
|
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 |
|
Jul 25 |
revised |
Role db_ddladmin not working properly on SQL Server 2008 added 137 characters in body |
|
Jul 25 |
answered | Role db_ddladmin not working properly on SQL Server 2008 |
|
Jul 16 |
answered | SQL Server statements intermittently slow on SQL Server 2008 R2 |
|
Jun 17 |
answered | Indications from obscenely high Operator Costs in Query Plan? |
|
Jun 3 |
awarded | Revival |
