Any argument that dates before 1900 are unlikely can't really be taken seriously can it? Pure foolishness.

Please put all of the US Presidential elections and their results into a...

Ha. I hope you don't...

We use peer to peer replication, then point our front end servers (web servers) to different SQL boxes. It's not trivial, but it isn't that difficult either.

Peer to Peer...

NEVER NEVER NEVER create FKs with cascading deletes.

This violates the very purpose of having a foreign key. To this day I am amazed that the possibility still exists.

Are servers in same domain?

Just want to add...for very large tables, wild-card searches (particularly leading wild card) will perform far better with full text indexing.

edit: whoops, didn't see u already said that :hehe:

you really need to use a variable. perhaps you can implement some logic to determine if it is today's or yesterday's report.

why do you say you can't use a variable?

by the way, i'd think question #2 will sort the men from the boys better than #3. the answers to this one will show who knows what they're doing more

We phone screen all DBA candidates for technical competence before any interview is granted. This weeds out most of 'em. For example, you'd be surprised how many people applying for...

make it a stored procedure, grant them execute permission on it

you can't

-- oops double clicked --

Convert(int, a.order_no) = Convert(int, b.order_no)

This may not perform very well but it will work. Should reassess the data types in these tables.

GilaMonster (1/3/2008)

---

Or if you feel like been less verbose (and slightly more cryptic)

IF DB_ID(''?'') > 4

All user dbs have DatabaseIDs greater than 4

Then in your sp_reindexing proc, use the objectproperty...

also, verify that what you're calling an apostrophe is character 39 (') and not 96 (`)