Viewing 15 posts - 7,966 through 7,980 (of 19,564 total)
Jack Corbett (11/8/2011)
GilaMonster (11/8/2011)
Clustered indexes enforce physical sort order of rowsNonclustered indexes can't be built on a heap
Nonclustered indexes on a heap can't be rebuilt
Hey Jason, did you get that?...
November 8, 2011 at 8:56 am
bopeavy (11/8/2011)
SQLRNNR (11/8/2011)
bopeavy (11/8/2011)
--------------------------------------------------------------------------------
SQLRNNR (11-8-2011)
--------------------------------------------------------------------------------
Query runs just fine in SQL 2008 R2 as well.
What service pack are you on?
SP1
What Edition? It maybe related to...
November 8, 2011 at 8:27 am
bopeavy (11/8/2011)
SQLRNNR (11-8-2011)
Query runs just fine in SQL 2008 R2 as well.What service pack are you on?
SP1
November 8, 2011 at 7:55 am
Koen Verbeeck (11/8/2011)
SQLRNNR (11/7/2011)
Query runs just fine in SQL 2008 R2 as well.I ran it in SQL Server 2008R2, and I got the severe error.
The plot thickens... 🙂
Maybe it was...
November 8, 2011 at 12:40 am
SQL Kiwi (11/7/2011)
Mind you, everything's...
November 7, 2011 at 9:41 pm
Revenant (11/7/2011)
SQLRNNR (11/7/2011)
exonerationproject review
Usually good for DBA and bad for PM 😉
November 7, 2011 at 12:31 pm
Perry Whittle (11/7/2011)
Windows 2003 or Windows 2008 cluster?
Me? 2003
November 7, 2011 at 11:07 am
GilaMonster (11/7/2011)
SQLRNNR (11/7/2011)
GilaMonster (11/7/2011)
SQLRNNR (11/7/2011)
We really need to know if that table has a CI. Without it, you can't defrag the other indexes.Yes, you can.
It has always failed...
November 7, 2011 at 11:01 am
GilaMonster (11/7/2011)
SQLRNNR (11/7/2011)
We really need to know if that table has a CI. Without it, you can't defrag the other indexes.Yes, you can.
It has always failed for me....
November 7, 2011 at 10:07 am
SQLRNNR (11/7/2011)
sqlfriends (11/7/2011)
quote: By table = 4GB, you mean the clustered index is 4GB in size?
If...
November 7, 2011 at 9:49 am
Ninja's_RGR'us (11/7/2011)
SQLRNNR (11/7/2011)
Ninja's_RGR'us (10/31/2011)
sqlfriends (10/31/2011)
First, I see the script is so long, I will have to study it a little bit later before I use it .
Second, I checked...
November 7, 2011 at 9:47 am
GilaMonster (11/7/2011)
Someone with more patience than I have want to finish this? http://www.sqlservercentral.com/Forums/Topic1197753-1550-1.aspx
Chimed in.
November 7, 2011 at 9:46 am
sqlfriends (11/7/2011)
quote: By table = 4GB, you mean the clustered index is 4GB in size?
If I...
November 7, 2011 at 9:46 am
Viewing 15 posts - 7,966 through 7,980 (of 19,564 total)