Hi Muthukkumaran

Edit the link, it does not work..

Tara-1044200 (2/17/2010)

---

query may be wrong for update, but my goal is to update 3 columns in table Emp_CA

select memkey into #t from dbo.Emp_CA where zen_memkey is null group by srckey

update...

This may help.. I am not 100 % sure

On the Server, when opening the SSMS, right click and choose Run as Administrator

Also check with your System Admin to include your...

Again, there is not much to say as there is a vague information of what you are trying..

Not much of info to suggest.

You mentioned the database is 1 TB, what is the size of the table (TableA) and what are the underlying Indexes.

All I would suggest would...

I am in US, so need not worry about the Visa stuff..

Any inputs on Pre / Post Summit seminars ?

Gail and Roy,

Can you give your input on the questions I have, apart from what Steve and Grant have suggested. Anything that would need planning time, money, what to look...

Any one wants to answer few interview question ?

http://www.sqlservercentral.com/Forums/Topic866931-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic866925-147-1.aspx

http://www.sqlservercentral.com/Forums/Topic866921-146-1.aspx

http://www.sqlservercentral.com/Forums/Topic866923-360-1.aspx

Can I forward the links in the interview ?

There are a dozen Interview Questions from this user in the last 30 mins.

I found these in BIDS, 1st Tab, 2nd Tab and 3rd tab, yet to find the purpose ...

Because it was asked so ... 😉

Yes ! Yes !

No ! No !

Which query?

Definitely sounds like interview questions, if you have not done what Gail suggested, search Google easier, quicker, more answers than here..

He must be busy reading Who's Who with respect to Gail Shaw, GT and Pual Randal, and whose suggestion...