By far the best tool for this is LogParser. From MS, but unsupported - you can get it here http://www.logparser.com. Originally designed for IIS logfiles but it can do most...

This answer is incorrect - you CAN put database files on RAW partitions. Have a look at http://msdn2.microsoft.com/en-us/library/ms176061.aspx or http://blogs.technet.com/mjmurphy/archive/2005/11/21/414854.aspx for more info.

Regards,

Jacob

You *CAN* actually expand volumes on Basic disks, with the following caveats:

- can't do it to the System or Boot volume

- can only expand if the unallocated space is contiguous

-...

I think your issue isn't going to be solved by changing your proc into a UDF... looking at your calling code you don't appear to be actually executing your SQL....

mrpolecat's suggestion doesn't actually do the DELETE or INSERTs. If you want the one proc to do those and also return the newly inserted records from MOVEMENT then do something...

Yes you can - look up the "COPY_ONLY" option under BACKUP in BOL for details. Can't do it via the GUI, but that's no big deal.

Why bother with that though...

Whoops - Jeff beat me to it. Ignore...

Regards,

Jacob

What about selecting a literal:

IF EXISTS (SELECT 1 FROM dbo.MyTable WHERE MyCol = SomeValue)

...

I can't see any difference in the execution plan for that compared to SELECT * but it looks...