The answer is clearly both Yes and No. From BOL (2005)

All mathematical functions, except for RAND, are deterministic functions. This means they return the same results each time they...

Hmm, thanks, I missed that comment in BOL. It seems funny that DBCC Showcontig can complete in so little time (literally 1/100) compared to a select from the dm....

Currently I have about 6300 pages in teh Clustered Index (I changed it from a HEAP).

The Blobs have 1.1Mpages and the non-clustered index is 2100 pages.

Scan density is 99+% and...

Hi Grant,

The DBCC is returning 3 rows for the table, the heap, the Blobs, and one non-clusterer.

The DM returns the same 2 indexes but it is 4 or 5 rows...

You mention a TimeStamp column and a non-clustered index. Do you have a primary key defined? Do you have a clustered index defined?

Here is link that provides some...

I agree with BitBucket. The results described at what you would expect in "normal" operations (assuming the typo is corrected)

Thanks,

The user is SysAdmin role with no explicit denials.

The problem turned out to be an SSMS bug. The work station had SQL 205 RTM. I installed Service Pack...

Hi Warren,

Checking for "Orphaned Records" can be a bear depending on how your schema (including referential integrity) is set up.

Basically, you need to test each foreign key in the child...

I don't think that is what you will see. It should look just like multiple instances on a single, non-clustered server. Basically you should see the three named...

Technically SP3 is not out. There is a CTP (beta) available for download but the page does not hint when SP3 will be released. Anybody Know?

I don't know of a Stored Procedure but DBCC CheckTable should do most of what you want. Ckeck it out in BOL

The T-Log is not that much of an issue as long as you remember a couple of key points.

The process you are implementing does not have to finish quickly in...

In my environment I can not just export rows. For each "Item" exported, I would have to build an extended set of rows from a number of tables/databases. ...

IMHO every physical table should have a clustered index. It is the absence of a clustered index that makes a table a heap. If there is no suitable...

Well, one of the keyiissues is "and we may need to run reports against it on rare occassions". In my situation that means the data all has to remain...