Funny you should mention an 800Gb database Grant..that is how big this database is!. It is a SharePoint 2007 Content Database. The recommendation is that they don't go over 100Gb...

Thanks everyone for responding.

I defined this function as a scalar function and so it required an argument with the return statement.

My issue was I had the return defined as...

Sorry for the dlay. So many fires to put out with such a tiny bucket. I have attached an insert statement that will put one record into the workorder table...

How'd this go? What did you end up using and are you happy with it?

I actually have that paper open on my desktop. I came across this powerpoint presentation that also contains excellent supplementary information: http://cid-2c2c54bdef4e3eb4.office.live.com/view.aspx/DiskPartitionAlignment/Disk%20Partition%20Alignment%20for%20SQL%20Server%20--%20Jimmy%20May%20--%20v.20090201.ppt

Also for some hard data resulting from tests...

So the hard part of this is simply finding a hard drive big enough to store what's on there now. It sounds like it's basically reformatting the hard drive..only scarier.

Yeah Ninja's_RGR'us that is a scary prospect. I don't use the mouse very much to avoid the wiggles and I just draw in a deep breath when I'm going to...

This morning I watched ssms.exe in the task manager. It's initial memory usage is 56 Mb and it has 285 reads and 112 writes just opening it. The memory...

Thanks for the info. The server I was referring to is sitting on a virtual drive, no SAN. it's a test server so it's not on a RAID either. ...

I didn't even know that would do the trick. That sounds alot easier and probably saves a lot of time. But proabbly still a good idea to defrag a drive...

Ugh! All day I'm at this. I did a fresh install but wasn't able to bring my 2000 dbs over to it so i uninstalled. At least this got rid...

So eventually it failed and when i shut it down and read the report it says to run:

"setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine,Replication,FullText"

Does anyone happen to know what directory this has...

Update:

I've attached a screen shot of the next 'failure'. I hit OK and the installer continued to run. you can see on the panel behind the popup what step it...

oh..ha ha ha.. I'm such a dork. I'll give that a try.

Do you think they aren't defragging them anymore? It could be cause the drives are so much bigger now that they can get away with not defragging them. It's kind...