Let me show my ignorance, what is the difference?

If lock it means that it is visable but unable...

If one has a vote, and all votes are equal, I would say no.

I think...

The variable contains a telephone number. In this case, it could be a cell, home or work phone. The reason for the like...

Unfortunately the use of wild cards before and after a string using like will force a table scan which can be problematic.

What I have done in the past is to...

A

Bex

imho (and I may be very wrong), I got the impression the op was almost suggesting that some people post replies asking questions as a form of ego, whereas...

We too do a lot like this with full text indexing as well. Amazing speed.

There are a few jobs besides those for the replication agents that run. Some of these run every 10 minutes and perform things like reindexing, defragmentation and aging. They will...

More light reading that may be of help:

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/a9679e55-f270-43de-9f1a-207834fe522b

Have you considered the possibility of transactional replication?

Good question Hugo. Kept looking for the catch, and kept re-reading to find there is none:-P

Using openrowset will allow you to perform selects between servers that are not using linked servers. We do this amongst many servers on our network. We do this because if...

So true...

Adam

And just for the record, the stop being elitist comment was aimed in general to this thread. Some of the posts are so arogant and close-minded and interestingly enough, not...

Didn't realize that I am being elitist.

Yes, I am a Sr DBA - why? Because my company says so. What makes me one, act of a VP....

adb

Would you expect your junior DBA to know about disk partition alignment, NTFS cluster size, RAID types,

TempDB - placement and number of datafiles, NUMA, instant file initialisation, AWE, locking...