The problem with splitting TempDB is that it doesn't work very well if you're putting all the files on the same logical drive. The idea behind there being a...

Then take what I said and reverse engineer it a little. Since you're already inside, you know what the weaknesses in the system are. Start documenting them.

One of...

Xintanaka,

It sounds to me like you're trying to justify to this small company why they should hire you, correct?

In that case, don't take impersonal data and usethat as a justification....

And thanks to everyone for the congratulatory posts. I'm just soooo thrilled about this.

Matt, How did you know the plot of my tale???? Not only an upgrade gone wrong, but the entire Board of Directors standing over a poor DBA's desk demanding...

And to enable xp_cmdshell (if you haven't already), go to SQL Server Surface Area Configuration -> Features. This is where you can enable it. It'll be listed under...

Don't forget, if you're doing a lot of deleting (data from tables), these transactions do get logged. That could also be adding to the size of your Transaction Log....

Don't forget that you don't have to do all your sorting & grouping in SQL Server itself. You can do some of it with the Groups in SSRS. ...

Ahh, who needs access to data anyway! Right? @=)

I love the title of the book you co-authored. "How to Cheat at Securing SQL Server"... How much...

I would advise testing with both an int PK and a change of the nchar(6) to char(6). Run Profiler during the tests so you can see what it's doing....

Thanks for checking that out, William. I appreciate the confirmation.

So, pretty much any reversion from 2k5 to 2000 has to have the following traits:

1) No use of 2k5 objects...

Remember that any datatype starting with the letter "n" is a Unicode-compatible datatype and requires extra overhead for processing. Because Unicode characters have so much more space in them...

And remember, you don't have to install Reporting Services for SQL Server to function.

SSRS is a separate install that you are required to choose (or not) during the...

First response: HA!!!!

Second response: Oh no! AD jokes on a SQL forum. Run away! Run away!

@=)

Anything that doesn't kill you is something else you can add to your resume. @=)

Good luck with your move.