I may be missing something, but this seems odd to me. You monitor approximately 1,000 websites, and have been doing so for about 3 years, with the normal traffic...

I don't bother with them. They currently have no function, and they don't make the proc more clear to me.

One of the developers at the place I work uses...

I guess I don't see why it has to be uppercase in the SQL Agent Job Owner field. I've typed them in lower-case in that field without difficulty.

I think...

Sorry for the latency. Really busy for a few days.

In my test, I didn't actually transmit any data with XML. I just used an XML data type to...

If you want to include nulls, but make sure they don't exist in the target table, you'll have to do two tests.

Do your "Where Not In" test, then also add:

or...

"Where Not In" returns all values that aren't contained in the set. Since null is an unknown value, it could be equal to anything, so Where Not In won't...

I don't believe that defragmenting a nonclustered index on a heap table works.

And, of course, I ask for your benchmark, and we post at the same time. 🙂

Carl, I just performed the following test. Please tell me what you're doing differently in this benchmark than what I'm doing:

create table dbo.Calendar (

Date datetime primary key,

constraint CK_Date check

(datepart(hour,...

If you run that code as-is, you shouldn't need the cursor.

If it's meant to be an exact copy of the source database, you might consider backup and restore. It's faster and more effective than the wizard.

You'll either need to output it as two data sets or as XML. Since I suggested XML above, and you're still asking, I'll assume that's not a viable solution...

The difference is because Joins are done before Wheres. The Join clause eliminates certain rows that the Where clause would allow, or the Join clause includes certain rows that...

rbarryyoung (8/15/2008)

---

This raises an interesting question: how quickly can we generate an acceptably random pseudo-random sequence in SQL Server, without resorting the obvious built-in functions (rand, NewID, Checksum, the...

Probably is worth asking for. Probably won't get, but can't hurt to ask.