Viewing 15 posts - 43,906 through 43,920 (of 49,552 total)
There's a major disadvantage to doing that. If you use a query hint you are forcing the optimiser to pick a plan using that index, even if another index would...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 2:28 pm
rajeev.suryanarayan (10/9/2008)
Gail, I have already done that. I have attached the Trace graph in my first post itself (as zip file).
No, that comes from profiler. I looked through and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 1:29 pm
rajeev.suryanarayan (10/9/2008)
Thanks guys..really appreciate you helping me out here but could you dig deeper into your expertise and forsee something 🙂 Pleasssee...
See my post above, enable the traceflag and get...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 1:00 pm
SQL will cache the exec plan of all queries that it runs. How long the plan stays in cache depends on how often it gets used, how much memory pressure...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 11:29 am
You can enable traceflag 1222 and SQL will write the deadlock graph into the error log. That will help you locate the cause of the deadlock.
The only way to get...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 11:21 am
I'd suggest a sliding percentage based on the table size. From experience, 20% is too high a threshold on larger (+1000000 row) tables
Just bare in mind that not all columns...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 11:13 am
Can you please post the table structure (as a create table statement) and some sample data (as insert statements).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 11:00 am
DBADave (10/9/2008)
We have auto_update_statistics and auto_create_statistics turned off as a vendor requirement. We have to update them manually.
I love vendors like that. They make my job (performance...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:45 am
Manie Verster (10/8/2008)
Hi Gail,This is wonderful. I am glad you started this and I will definitely try my best to be there.
Great! I look forward to meeting you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:34 am
williamaffandi (10/9/2008)
Can SQL 2005 actually do this ? And do...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:32 am
Then you are going to have to delete the entry in sys.objects manually for that pk, and then deal (again manually) with any child records of that (references in sys.indexes...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:28 am
J (10/9/2008)
Would you pleae humor my curiosity and give a short description of what kind of an application generates a terabyte of data ?
A bank's trading system for one. One...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:20 am
Jan Van der Eecken (10/9/2008)
Good Luck, Gail! I wish there was a User Group in Cape Town as well.
There may well be in the future. Right now it's JHB, because...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:18 am
samsql (10/9/2008)
Plz gail provide me some thing so that i can reduce the log size....
I'm trying to! That's why I'm asking so many questions to try and get to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 10:17 am
What does the following return?
select name, type_desc from sys.objects where object_id in (624252677, 640252734)
What other changes have you made to the system tables?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 9, 2008 at 5:16 am
Viewing 15 posts - 43,906 through 43,920 (of 49,552 total)