Method 2.

I've been given Method1 and it's a pain.

First, I'll agree that RAID 10 is better performance, though I've seen some tests showing multiple RAID 1 arrays perform better. But that's nitpicking. If you can, get a few...

What is "best"? It's subjective. There are quite a few tools that can do it. Red Gate has SQL Compare, dbGhost has a tool, a few more.

I used a process where we batched the runs, grouping objects in an ordering scheme (tables before indexes, etc). We used to automate the deployment to QA and production on...

To be clear, I don't mind you linking somewhere in your sig, if you're posting something that is relevant to the topic. In here, I thought you started an interesting...

Have you looked at the ISDATE() and ISNUMERIC functions in BOL?

IF the data doesn't change, then one thing you can do is create a new filegroup/files and put that data in there. You can move existing tables by moving their...

A few seconds shouldn't matter. I've seen this typically when I've changed a service account on a server. You can search for the SETSPN utility and try to reset the...

Sorry about that. I ordered them with the SQL forums as 1, 2, 3, but apparently they're in "reverse order". I'll correct them today.

Not sure about that. The forum code is a little convoluted and we purchased it. I'll inquire, but the best way to do this is open the reply in...

There's a bug in here and it's caught me. I tend to scan the "Active Topics" and then pop interesting ones in a new window. If you select one, answer,...

Security admin doesn't work? What rights do they need to add? You might need to add db_securityadmin in certain databases as well to manage users.

Not that I know of. I'd add more local space, you need it and don't want to run out. I used to script a job that would just send everything...

It's a domain token issue. Check the times on those workstations v the server, sometimes if they're out of synch you get this.

You can, but I'd avoid sending an email from the trigger. Someone changes it, then realizes it's a mistake, changes it back, etc. you get lots of emails. Plus it's...