Viewing 15 posts - 38,791 through 38,805 (of 49,552 total)
WayneS (5/30/2009)
The thing that bugs me, that I don't really understand, is:In any of these conditions, the best plan is to do an indexed seek.
Yes, but if it does 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
May 30, 2009 at 8:32 am
You could always take the DBs offline as you finish the backups. That way no one would be able to make any transactions. It may make the downtime more, but...
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
May 30, 2009 at 8:29 am
The data pages are backed up as the backup process reads them, so pages early in the file may be as they were at the beginning of the backup, pages...
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
May 30, 2009 at 2:12 am
Update statistics just updates the column stats on the table.
Rebuild index rebuild the specified index, removes fragmentation and then updates the stats for that 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
May 30, 2009 at 1:54 am
Ah, so it is still available.
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
May 29, 2009 at 2:33 pm
The procs that you're calling (CreateTrace, AddEvent, AddFilter, StartTrace) aren't system stored procs. They code for them should be in that article, if not, the author should have posted them
Check...
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
May 29, 2009 at 2:31 pm
Ken Simmons (5/29/2009)
IIf you upgrade a database from SQL Server 2000, the PAGE_VERIFY value will be NONE or TORN_PAGE_DETECTION. If it is TORN_PAGE_DETECTION, you should change it to CHECKSUM.
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
May 29, 2009 at 2:25 pm
More shameless plug: http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/
Grant, is your book still available for download anywhere?
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
May 29, 2009 at 2:25 pm
Have you updated all statistics since the upgrade?
If that doesn't help, please post the query, the table definition, all the index definitions and the execuion plan (saved as a .sqlplan...
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
May 29, 2009 at 2:10 pm
Kit G (5/29/2009)
So the statistics either on or off won't affect what rows get returned for a query, like it isn't going to miss any rows because statistics weren't updated
No,...
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
May 29, 2009 at 2:07 pm
Kit G (5/29/2009)
GilaMonster (5/29/2009)
Gut feel is that those bad stats are going to bite him but he probably...
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
May 29, 2009 at 1:35 pm
ichbinraj (5/29/2009)
Hi did you check the execution plan ?
Yes, I did
if i change any thing on cluster index .. means removing cluster index from sid and item _custom1 .. 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
May 29, 2009 at 1:03 pm
Jack Corbett (5/29/2009)
GilaMonster (5/29/2009)
Jack Corbett (5/29/2009)
Hey you folks who are going to write the book on indexing. How about helping this guy out?Why? You're doing a fine job yourself.
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
May 29, 2009 at 12:59 pm
ichbinraj (5/29/2009)
As per your suggestion . I have to create non cluster index on SID and ITEM_custom1 ... right ?
Yup. It should help.
About the auto_update state?
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
May 29, 2009 at 12:31 pm
And the table structure?
The attachment button is right beneath the text box where you type your post. In the section titled "Post Options"
I can tell you right now that 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
May 29, 2009 at 11:57 am
Viewing 15 posts - 38,791 through 38,805 (of 49,552 total)