You can still use the trigger to record the update, just don't send the email.

Are you sure that your LUNs aren't sharing physical drives? I'd definitely have the SAN people dig into the configuration and while you are doing a restore, check and see...

I'm not sure what you are asking here? Are you looking to spread the load of querying?

OK, bad question. I'll award points back for Profiler and throw this one away.

If you click "Active Topics" at the top, it shows the topics with new posts since your last login. That's easier than scanning a board from the main forum page.

The...

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