I would bet that shrinking a database would move the pages around....causing fragmentation.  Just a guess.

Why shrink if you know you are going to need the space soon?   If it...

Do you have clustered indexes?

Steve...I think they have a standard of 2048.  I think it kind of takes off of the Oracle Extent concept (and OS block size).   I used to have my SQL...

Good call Bill...

fyi.. SQL Server reports space usage from the sysindexes table.  Sometimes SQL Server isn't always able to keep up with the changes and the reporting numbers are out...

Been there with this one.  I have a question before I start to ramble...How many tables and indexes are you dealing with?

I don't believe in shrinking the database.  Your just setting yourself up again to grow the datafiles.   Why would you want to keep growing and shrinking a datafile?

Something else to...

I don't think the unique index has a lot to do with it...unless, you are updating and deleting through a view, or an updateable cursor.   Are you using updateable views...

I didn't, but someone else did some time ago.   On a couple of servers I just added the account back (builtin\admin) and it worked again.  On other servers it's hosed.  ...

Have to add my two cents...

DECLARE @DBName nvarchar(60)

DECLARE @SQLString nvarchar (2000)

DECLARE c_db CURSOR FOR

    SELECT name

    FROM master.dbo.sysdatabases

    WHERE status&512 = 0

CREATE...

May not be the format your looking for

DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES.

look at the average row size.

You have an evil query creating the growth in tempdb.  At least this is my gut feeling on it. 

Find the query or process that takes a long time to...

The script is awesome!!!

Couple of good responses in here.  Thanks!!Mssql_rules explained what I was getting at with the 'leveraging'  better than I did.  

My example was hypothetical.  This was more about curiousity than...

good points everyone.   Try looking at your proxy account.  Also check to see who you are running the xp_cmdshell command under. 

I guess the point is....  What account is being...

Must admit this one made me curious.  Did a little testing in the pubs database.  Try something like this.

SELECT SUM(DATALENGTH(title_id))  +

       SUM(DATALENGTH(title))     +

       SUM(DATALENGTH(type))      +

       SUM(DATALENGTH(pub_id))    +

       SUM(DATALENGTH(price))

FROM...