That makes sense and just be sure that the subscriber isn't looking for a certain IP on the distributor if it pulls data.

Let us know if you have issues. We'd...

You could do something like:

create table #tables (table_name varchar(80), completed datetime)

insert #tables

SELECT TABLE_NAME, null

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

while exists (select table_name from #tables where completed is null)

begin

...

As mentioned before, the ordering of records is not guaranteed without an ORDER BY clause. If you want to display things in some order, be sure that you add a...

No idea, but I'll have to check. I hadn't put Cumulative Update 5 on my box yet.

This is one of the very annoying things about SQL Server. There are times, especially with the Service Packs, that it wants to put some stuff on C for the...

Don't stop reviewing! That breaks down the system. Instead I'd recommend setting up a hotmail or free account and a fake name and review them under another alias. At least...

I've seen some consultants recommend 28-29GB if this is only a SQL Server box. You need to run some metrics and be sure that it won't cause issues. 64-bit should...

It depends on how you set things up. Some people have used IPs instead of the server name. IF it's by servername, it should be ok, SQL should start...

What about returning the four columns and running 4 queries looking for exact matches on one column each, then unioning them. You could list the results in some order and...

There's no way to know this. You could guess, but even the optimizer doesn't know how long. It can guess, but it's just that.

I agree with Jeff. I'd do it like you're doing it.

While I agree with Jeff that you might want to trust the DBA, I know that some of my sysadmins were much better at tuning Windows than me and...

While I don't like SELECT * in code, I'm not sure it's less efficient. I'd like to know why. I always learned that it resolved the column list at compile...

Optimum is hard to determine. It's somewhat a philosophical debate on how you want to handle things.

Personally I don't like linked servers. Possible security holes could be used for other...

I was thinking that the compression could aid the solar hot water in providing radiant heat. The cold air could be used for cooling in the summer.

I still agree the...