I've had problems before in 2k5 where using the GUI to attach the DB wasn't working properly and while the database showed as attached, the sys.databases table didn't know it...

Make sure to notify your end users about the restart of services BEFORE you do it. They may lose data if you don't. (Data not commited to the...

I'm fairly new to the db design world myself, but here goes my opinions...

My first thoughts are purely datatype related.

Rating is 1-5. Why is it an int? If...

And Divide By Zero errors can kill your query if you don't use Try..Catch or some other test for income being zero, so make sure to take that into account...

Just an FYI to the original poster, init does NOT overwrite backups that have not expired or the set name in the t-sql doesn't match the name on the backup...

The business logic of only attaching copies of the .mdf and .ldf is that if these files get corrupted or set suspect when you're trying to attach them to 2k5,...

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...