Thank you for your analysis.  I found the information in Inside SQL Server 2000 yesterday but your analysis added to my knowledge.

 I am going to make a couple or recommendation...

The stupid face was not intended.  Disk::Sector:age should have been Disk-Sector-Page where the - is a double colon.  The ColonP is interpreted as a stupid...

Yes.  Make a SQL Server Job. enter the procedure into a Job Step and schedule the job to run every day at whatever time you choose.

Thanks!

After reading this it is obvious that a BIT datatype actually uses 2 bits, one for the data and one for the Null Column BitMap.  Someone who is using bits...

Thanks.

Makes sence.

What I'm working on is creating my own bit map in a tiny, small, int... column.  I do this with bit-wise operations.  Once the bits are set I can...

Try using the osql or isql command with the -o (that's a lower case o.)  This allows you to execute SQL and place the output in the file specified by the...

This code will cycle through all databases on a specific server and return all Databses, FileGroups and FileNames with the space used.  It's just an exercise to show you how...

Sometimes it's more important to get the job done that to find the snazziest way to do it.  Brute force works... most of the time... and in a lot of...

Try this.

1)  Union the two tables together (If they have exactly the same formats... see NOTE: below)

SELECT * INTO ##Compare FROM Task UNION SELECT * FROM Tracker..Task

2)  See if there...

Just a quick note.  You said, "to create a sort of data dictionary."

There's not question about it, the system tables ARE the data dictionary.  There may be views and tools...

Here's a quick blurb about Particitioned Views.  It's one way to span a table, actually multiple tables each containing part of the whole logical table, across filegroups.

Lookup the following in...

DBCC SHOWCONTIG

Displays fragmentation information for the data and indexes of the specified table.

Syntax

DBCC SHOWCONTIG

    [    ( { table_name | table_id | view_name | view_id }

            [ , index_name | index_id...