Viewing 15 posts - 35,446 through 35,460 (of 49,552 total)
Why don't you just use this one? Easier than writing and debugging your own.
http://sqlfool.com/2009/06/index-defrag-script-v30/
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
December 7, 2009 at 12:07 pm
Index rebuilds always update stats with full scan, because the entire index is being read for the purposes of the rebuild.
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
December 7, 2009 at 11:41 am
Above 24 pages you may see a change in the fragmentation. The 1000 pages is more or less, somewhere around where there's a measurable performance impact from defragmenting.
If you want...
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
December 7, 2009 at 11:40 am
CirquedeSQLeil (12/7/2009)
Antiquated
I take exception to that. 😉 :hehe:
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
December 7, 2009 at 11:26 am
Birthday
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
December 7, 2009 at 11:25 am
No.
ALTER VIEW <ViewName> AS
<Select Statement>
How would add column work? You're saying nothing about which table that column comes from. A view's just a saved select statement, it's got 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
December 7, 2009 at 11:23 am
Schadenfreude-Mei (12/4/2009)
If you send Gail Shaw (Gilamonster) a message she will know, shes helped me out on this before.
However I have a policy whereby I do not answer questions sent...
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
December 7, 2009 at 11:21 am
jason.stephens (12/7/2009)
I couldn't find any specific documenation published by microsoft on a good cut-off.
A rough rule-of-thumb, given by a former program manager of the storage engine is around 1000 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
December 7, 2009 at 10:47 am
A quick look in Books Online under the topic 'sysprocesses' (http://msdn.microsoft.com/en-us/library/ms179881%28SQL.90%29.aspx) shows the following
Books Online
This SQL Server 2000 system table is included as a view for backward compatibility. We recommend...
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
December 7, 2009 at 10:26 am
Depends on the type and severity of the corruption. Either's possible.
If the database has checksum page protection and the backup was done with the checksum option, then many forms of...
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
December 7, 2009 at 10:22 am
robert.jackson-943581 (12/7/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
December 7, 2009 at 10:16 am
JC-3113 (12/7/2009)
so if i wanted to pull info from either of these two tables which schema should i be using then; dbo or sys ?
For sysprocesses either works, because it...
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
December 7, 2009 at 9:42 am
robert.jackson-943581 (12/7/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
December 7, 2009 at 9:39 am
Steve Jones - Editor (12/7/2009)
OK, I couldn't resist: http://www.sqlservercentral.com/Forums/Topic829828-338-1.aspx
Beautiful.
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
December 7, 2009 at 9:34 am
Grant Fritchey (12/7/2009)
CirquedeSQLeil (12/7/2009)
Extremely Urgent my Exam is only 1hr today.
Here's my IM address, just send me the questions and I'll plug in the answers... they'll all be 100% correct...
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
December 7, 2009 at 9:33 am
Viewing 15 posts - 35,446 through 35,460 (of 49,552 total)