Viewing 15 posts - 17,446 through 17,460 (of 49,552 total)
Then
http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025
And lots and lots of practise.
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
July 24, 2012 at 5:12 am
Look up UNPIVOT in Books Online
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
July 24, 2012 at 3:19 am
Your query is returning too high a % of rows for the seek and key lookup to be cost effective then.
300 rows is too small to test and draw any...
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
July 24, 2012 at 3:11 am
Possibly, but it would have been a lot harder. Profiler doesn't ahve anything that tells you how much log space is/was used by a session. That's the benefit of the...
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
July 23, 2012 at 3:39 pm
savethytrees (7/23/2012)
Hi,If I see several lookups on a clustered index, is there a way to find which non clustered index is missing some columns?
Not from the...
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
July 23, 2012 at 2:56 pm
Vikrant S Patil (7/23/2012)
From MSDN:A copy-only log backup preserves the existing log archive point and, therefore does not affect the sequencing of regular log backups.
That is specifically talking...
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
July 23, 2012 at 1:58 pm
http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/
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
July 23, 2012 at 1:04 pm
Stamey (7/23/2012)
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
July 23, 2012 at 1:01 pm
8GB reserved out of 32GB sounds a little excessive (but only you can confirm that by monitoring). At higher memory amounts (64, 128) 8GB reserved for the OS is not...
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
July 23, 2012 at 11:54 am
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
July 23, 2012 at 11:30 am
BaldingLoopMan (7/23/2012)
I noticed however it coming in as dynamic sql and therefore the optimized exec plan is not using it's cached execution plan.
Dynamic SQL caches and uses cached...
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
July 23, 2012 at 11:30 am
Because as a parameter SQL can't guarantee the value will remain the same and hence can't generate a plan that uses the filtered index because the plan using the filtered...
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
July 23, 2012 at 11:22 am
Developer may not be used for production. Express can. Other than that, check the features and restrictions of the editions and see what your app requires.
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
July 23, 2012 at 9:17 am
Check the edition limitations of Express, see if your DB requires anything that Express doesn't have.
We can't tell what the app needs
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
July 23, 2012 at 9:06 am
No way to tell from that, there's no useful info in there.
If checkDB failed, there will be details in the SQL error 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
July 23, 2012 at 9:04 am
Viewing 15 posts - 17,446 through 17,460 (of 49,552 total)