Viewing 15 posts - 27,541 through 27,555 (of 49,552 total)
When the auto update doesn't do a good enough job and you have poorly performing queries due to incorrect cardinality estimations. Big tables typically
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
March 5, 2011 at 8:06 am
Task manager lies. It's a terrible way to check SQL memory because it will give you an incorrect value (it's not great for other processes either)
Perfmon, target server memory 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
March 5, 2011 at 1:32 am
Maintenance plan 1. CheckDB and full DB backup. Nothing else.
Then a job to do index rebuilds. See the link to scripts by someone a few posts back.
Maintenance plan 2: log...
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
March 4, 2011 at 6:34 pm
Craig Farrell (3/4/2011)
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
March 4, 2011 at 5:06 pm
Do Not Shrink Your Database!!!!
Doing so after a rebuild is a total and complete waste of time. The shrink undoes what the rebuild does. Do Not shrink regularly. If used...
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
March 4, 2011 at 4:35 pm
First things first. An mdf from one point in time and an ldf from an earlier time will NEVER work (unless there were no changes between the two times). If...
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
March 4, 2011 at 4:17 pm
Please post new questions in a new thread and include the errors.
Thanks
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
March 4, 2011 at 9:27 am
chandan_jha18 (3/4/2011)
Is it true that design matters and can make indexes look poor?
Yes! Absolutely!
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
March 4, 2011 at 9:23 am
Put single quotes around all the literals in the string. They're strings in the table, they should be strings in the queries too.
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
March 4, 2011 at 1:30 am
chandan_jha18 (3/4/2011)
I read a couple of articles which says that the 'or' clause will cause a scan no matter what!
Those articles are wrong, and it's trivial to prove that.
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
March 4, 2011 at 1:25 am
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
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
March 4, 2011 at 1:23 am
Move year from the include to the key. I didn't notice the filter on that earlier. That's for both 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
March 4, 2011 at 1:14 am
It's absolutely essential to run it. If you don't and you get corruption there's no guarantee that you'll find it while still repairable.
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
March 4, 2011 at 1:12 am
Execution plan please
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
March 4, 2011 at 1:02 am
How are you checking what it is using?
How much memory do you think it's using?
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
March 4, 2011 at 12:53 am
Viewing 15 posts - 27,541 through 27,555 (of 49,552 total)