The query that you wrote should return every record in Table1 with every record in Table2 that doesn’t match the value in PID and SSN column. Even if there...

If your column is a numeric column, then it should behave this way. If you need to store the leading zeros, then maybe you should work with strings instead...

I agree with Grant. Inserting million records one by one doesn’t sound at the correct way. If you don’t want to use SSIS, you can check out Bulk...

I’m sorry but this is not really a valid reason to reboot server. Also it is not guaranteed that the TempDB...

Are you sure that you should shrink the tempdb? If the databases reached its current size during normal work, then there is no need to shrink it because it grow...

Convert has a third parameter that is optional and is called style. It is mostly used with dates. For example check out the next script:

declare @dt char(10)

select @dt...

Just read my first post again. If you have any question about it, I’ll be glad to answer them.

Adi

I agree that with the assumptions that the table exists, it has at least 2 records and the code is ran on SQL Server 2005 or later, then the only...

Saravanan T (3/3/2010)

My question is can i update the same table like below in another session....without commiting or rollbacking the session 1.

...

Could be few reasons. If your table has no index that it can use to locate the record, then it needs to do a table scan. In that...

I wouldn’t say that using XML parameter should hurt performance. As in many other things, I would say that it depends. If XML parameter would be something that...

I’m sorry but I don’t understand the question. Can you clarify it? What do you mean when you say that you have corrupted relations between the tables? ...

I agree with the posters that claim that the question had more then 1 answer that could be correct. I guessed the answer because I assumed that the table...

If you use a numeric data numeric data type (by numeric, I mean any data type that can only store numbers such as int, decimal, money etc’) then the server...

First I have to admit that I didn’t check the code, so there are maybe other issues that I didn’t notice. As for your question, you can use nested...