Viewing 15 posts - 36,286 through 36,300 (of 49,552 total)
What exactly are you looking for? Advice on reducing the cpu usage?
Are you sure it's SQL using all the CPU time?
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 15, 2009 at 9:45 am
Slick84 (10/15/2009)
Okay Gail, here is my execution plan after making the above changes. Unique non-clustered index on fstrShortsku and EDPno included in index for tblRegularItems.
Excellent. This looks about as good...
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 15, 2009 at 9:41 am
Steve Vassallo (10/15/2009)
What about SQL 2008? Is this an option there?
Yes.
SQL 2008 SP1 CU2 allows locked pages on standard edition. Good reference for this topic is 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
October 15, 2009 at 9:37 am
What's the question?
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 15, 2009 at 8:19 am
Slick84 (10/15/2009)
Also, is it possible for me to "alter" my non clustered index on tblregularitems and add the 'Include' clause in there?
Drop Index
Create Index
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 15, 2009 at 8:18 am
george sibbald-364359 (10/15/2009)
one of these days Gail I will get my reply in just BEFORE you. 🙂
Type faster 😉
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 15, 2009 at 8:07 am
San-847017 (10/15/2009)
Take the database OFFLINE. Go and change the MDF & LDF files name in it's locations and the take the DB online.
Do just that and the DB will be...
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 15, 2009 at 7:52 am
dmc-608719 (10/15/2009)
What is the alternative method to use going forward? How do achieve the same results with compliant code?
ALTER DATABASE ... SET RECOVERY SIMPLE
Not that you should need to truncate...
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 15, 2009 at 7:50 am
Ok, I didn't see the earlier posting of the view. Nothing worrying there, I just wanted to check what exactly it was doing.
Slick84 (10/15/2009)
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 15, 2009 at 7:42 am
wytze.sijtsma (10/15/2009)
blandry (10/15/2009)
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 15, 2009 at 6:30 am
ta.bu.shi.da.yu (10/15/2009)
All the Microsoft links point to info about the 64-bit versions of Windows. Is this feature restricted to this platform?
No, but it tends to be most useful (and most...
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 15, 2009 at 6:16 am
Is this what you're asking about?
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
October 15, 2009 at 6:13 am
What?
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 15, 2009 at 6:13 am
Grant Fritchey (10/15/2009)
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 15, 2009 at 5:48 am
Saravanan_tvr (10/15/2009)
Please give me a soluitons for making faster backup the database...
Several options
Are you backing up to a network location? If so, backup to local disk
Check the performance stats on...
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 15, 2009 at 4:12 am
Viewing 15 posts - 36,286 through 36,300 (of 49,552 total)