Thank you. This is what I needed. A cross join with an except.

I just modified for the username rather then the id and it returns exactly what I was looking...

Not a new trip this year, but an important one I'm looking forward to.
My  brother and I are taking our father back to South Dakota and to the Black...

Tom - Thanks for the idea. I will have to think this over and try going down the path of using count columns in the Service table and Triggers.

I definitely...

I've only had 1 interview with any "odd" questions, although I think they had a bit more relevancy in determining character than some of the posts I've read.

I was asked...

First of all, this is quite a coincidence. I just happened to be getting ready to do exactly the same thing. I have to repeatedly drop the FKs, truncate tables,...

I actually have had this exact situation. There really was nothing I could do, other than surf the web trying to self train. But I couldn't hardly take online course...

12 server instances

6600+ databases

Various production, test, BI, reporting servers/DBs.

Prod DBs range from 2MB to 15GB

BI/reporting DBs from very small to 500GB

2 "DBAs"; I'm the only official DBA, my boss does...

This seems like a good time to point something out I've thought about.

It is quite disappointing that SQL ServerCentral continues to leave Mr. Celko's comments on this board as...

Yes, that will create a temp table on each server with 1 row.

If this is a one off type run and there are not an unusually high number of servers;...

Try the SQL Server Migration Assistant for Oracle.

http://www.microsoft.com/download/en/details.aspx?id=23945

Works well for me.

The measure of a man's real character is what he would do if he knew he never would be found out. ~Thomas Babington Macaulay

Ahhh....of course...following you now.

Now I have to figure out how to create this. The code is already dynamically created to get to this point as it has to run for...

Lowel - thank you for your reply.

I'm not quite following your idea on the possible cause.

It may also be that I have not been very clear as to the issue.

The...

majorbloodnock (5/19/2011)

...except that that's the important bit. The incentives in the short term are fairly small, but the compounding really starts to kick...

Am I better off than a year ago? Interesting question for me. I make less money, but I am happier.

In 2008/2009 had perm job doing SQL dev and old VB6...