The part before the "\" is the host name.  That is the part that you can alias with a CNAME record. The part after the "\" is the instance name and it is...

I think the Muppet question is a good one.  Not so weird to me.  I would imagine that the average interviewee might be a little surprised, but a little surprise...

In all my DB work, I don't think I've ever written a Right join.  At least not a keeper.

I'm in agreement with you, Rudy.  I would always recommend using DNS unless there were some very strange things happening in the network.  I might also add that in order...

TDP works just fine.  If you've got it, use it.  It is not so easy to figure out scheduling of backups, but the GUI is great for restoring.

I haven't had any problems doing this, and I'm running IIS on MSCS nodes.  Probably not a concern.

"What backwater chunk of software is this if the vendor says that it won't run on '05??" 

Probably some company executive heard the old saying "If it ain't broke, don't fix...

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

Under this key, you will find subkeys that are the "Groups".  Under the subkeys are listed the registered servers.

I suppose the usefulness would depend on your specific needs.

One method would be to use the client network to specify an alias for the target server.  Another would be to add...

Hi

I just had this sort of thing happen to me last week.  The culprit was an OR operator that was not wery well thought out.  A couple of parentheses fixed...

Hi Jim,

I think that you will need to follow the same rules that you would use for any kind of database design.  If the table(s) all represent the same thing,...

Hi JS,

Another thing you might look for is autogrowth of files.  If you have a large data or log file, and this file is set to autogrow (the default) and...

Hi Sacha,

I'd like to know how many rows you have in the table you're trying to index.

I would suggest creating a copy of the table and inserting perhaps 1 percent...

"Does that mean I have to create copies by hand of each table I need in the replication and set that 'not for replication' option on each table?"

Yes and no. ...

Hey, that's my checking account.

Are you trying to write T-SQL code that will create REGEXes for you, as opposed to getting SQL to parse...