Thanks for asking.

Basically, what I want to do is create "a" big sql query script to cover some complex calculation. I knew that I can use some kind of break...

NewID() create a unique ID, but with CHECKSUM it seems cannot guarantee to be unique again.

my god,

1..How to back up a single table in a database?

simple way: select * into temptable from whatevertablename

2..How to import the data from the excel sheet into the sqlserver table?

use...

Pay rate? Contact Info?

There are so many reply already.

I think "Everyone, as long as not stupid, can become a good programmer", but if someone want to be a better then "Good" programmer,...

simply use vs 2005 professional or higher.

Ideally, as an administrator, if there is any major change in the computer, you should check all the scheduled job, backup and ......

Even there is no major changes at all, you...

Personally I agree Loner's opinion. But I don't think someone will change their mind.

But I will choose walk away, if interviewer wants to test me in such as 5...

I believe the good manager is the person who can understand what is your capibility, but not your past project experience. He listen your feedback and complient but does not really...

When you do the DBCC shrink, you cannot shrink the file size small then the database defination. You may want to use the DBCC ShrinkFile, but not ShrinkDatabase

Hi Colin,

I am not sure what you means the "Unless this is a production system...".

Base on my past experience, when the database is in the full recovery mode,...

in general, yes.  

the simple way I did was create a small vb script, schedule it. It's easy and I never failed.

As long as your looking for DNS hold the IP address information, it should not have any problem (I saw many time problems are DNS server connection lost). 

I had speed example of using cursor and select:

In my previous project "data migration". using cursor would spend more then TWO days, with select, it just 30 min. There were...