Viewing 15 posts - 32,716 through 32,730 (of 49,552 total)
The clustered index is the table, it's not a separate structure from the table.
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 27, 2010 at 2:26 am
What exactly are you looking for here? A general analysis of the 15MB trace file?
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 27, 2010 at 2:23 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic928775-149-1.aspx
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 27, 2010 at 2:18 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic928320-391-1.aspx
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 26, 2010 at 11:44 pm
Ken Lee-263418 (5/26/2010)
ONLY the first field values are stored in the binary tree of ANY index.
Sorry, but that is not true. I don't, from your explanation, know what was wrong...
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 26, 2010 at 11:42 pm
reuben.anderson (5/26/2010)
... I'm afraid I don't understand what sorting a page chain "logically" means.
Each page in the index (and this goes for all indexes, not just clustered indexes) has,...
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 26, 2010 at 12:27 pm
Gianluca Sartori (5/26/2010)
GilaMonster (5/26/2010)
Gianluca Sartori (5/26/2010)
Steve Jones - Editor (5/26/2010)
no, there have been some doozy's this week. Though our PhD friend doesn't help the impression.Who? You mean this individual?
Ow, losing...
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 26, 2010 at 10:35 am
Gianluca Sartori (5/26/2010)
Steve Jones - Editor (5/26/2010)
no, there have been some doozy's this week. Though our PhD friend doesn't help the impression.Who? You mean this individual?
Ow, losing your patience with...
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 26, 2010 at 10:24 am
Start with this, and all the stuff it links to.
http://msdn.microsoft.com/en-us/library/ms189852.aspx
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 26, 2010 at 10:07 am
Chris Morris-439714 (5/26/2010)
David Webb's is darned good too:David Webb-200187 (5/25/2010)
"I don't know why your update didn't work. Perhaps your data has trouble accepting change."
That was almost a coffee-over-monitor moment....
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 26, 2010 at 10:01 am
Is it me, or is this week particularly bad in the 'bad questions' dept?
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 26, 2010 at 9:47 am
elutin (5/26/2010)
BUT.These problems dissapeared long ago.
They dissappeared in SQL Server 7 to be specific. 6.5 had that problem, 7 did not. 5 versions ago.
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 26, 2010 at 9:46 am
Tomasz Jureczko (5/26/2010)
replace Values with select, remove brackets "()"You don't nedd use from in this query.
Replacing values with select will still result in a syntax error, as the where clause...
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 26, 2010 at 7:57 am
don.schaeffer (5/26/2010)
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 26, 2010 at 7:56 am
Don't understand. More details please, with table definition would be 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
May 26, 2010 at 7:16 am
Viewing 15 posts - 32,716 through 32,730 (of 49,552 total)