Hi All ,

I need to...

Personally, I wouldn't do this from within SQL Server. Instead, I'd set up a PowerShell script to make all the connections. It can still save it all back to...

I agree. Normally, in an article like that, the author would pose the questions and maybe format them as bullet points because that makes them stick out... then later...

To Grant's point, if you're going to REORGANIZE at 50 and REBUILD at 80, I wouldn't even bother with index maintenance.  Not that I would recommend it for everyone but,...

A common mistake... "Lynn" is a crusty ol' dude that's...

Maybe it's time for a new version of DVD-RW about the size of the old LP records, and a drive the size of a turntable.  You could get lots...

Thanks John and Jeff for your input,

I do see the difference between using SQL Server Agent and a proxy -- I created a simple script that simply changes the...

John

That's not (just) updating statistics - it's index maintenance.  When you rebuild an index, you should plan to have at least the same amount of free space...

I used sp_spaceused to find size of index and it is 40 GB and free space on the DB is around 19 GB.

Will adding additional 40 GB or more...

That's not (just) updating statistics - it's index maintenance.  When you rebuild an index, you should plan to have at least the same amount of free space in your...

Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a...

Yeah... my bad.  I've only got 2 cups of coffee under my belt and totally misread the code.

When you ran the code, it was probably from your desktop, which probably has a copy of Office on it (at least Excel).  When the job runs, it runs as...

Never mind.  Misread something.

Getting back to your original post above, stop trying to return stuff to the operating system by shrinking TempDB.  It's not returning anything because, presumably and based on the fact...