I am fairly certain that it is not parallellism that is causing this. If anything I would guess it could be a bug with TRUNCATE. The TRUNCATE statement 'deletes' all...

Is it a web site, in other words is the client a web browser? Are you sure the client can show arabic characters?

I try to restrict my 'use' of nulls to those generated by outer joins. In schema design I generally never allow nulls.

And if the SET statement is used (instead of the SELECT one) the statement will fail if there are more than one row returned. For that reason Vladan's version is...

I tried to reproduce this behavior but was not able to do so. Therefore it is still interesting to get the table definitions and enough sample data to reproduce this.

Even...

Default blank values, or NULLs, to me is generally a sign of bad design choices. Allowing NULLs as the standard seems like a bad practice.

The Guru's Guide to Transact-SQL

Well, I am not quite sure which options you are looking for.

- sp_configure will show you which options are set for the server

- the 'user options' option can be used...

Please do not cross-post across boards. All boards are monitored.

Continue this discussion in the other thread.

DELETE FROM TableA

WHERE EXISTS (

 SELECT *

 FROM TableB

 WHERE StoreID = TableA.StoreID

 AND VendorNumber = TableA.VendorNumber

 AND ItemNumber = TableA.ItemNumber

 AND PLUNumber = TableA.PLUNumber)

Eh, you order and pay for it. Did you expect to be able to download the final product for free?

You will however be able to use SQL Server 2005 Express...

Like have been said, they are completely different. Duration is the time from start to finish and includes everything that takes time including cpu activity. Very often there will be...

In SSMS there is a window called Summary. This window has a button called Report that can drop down into a list of available reports. The set of reports change...

I would still consider it a confiuration issue, e.g. something that an admin sets up using Enterprise Manager or his tool of choice. And why does the logins need to...

Solutions using dynamic sql, cursors or loops are really not something that should be considered. Remi (RGR'us) have already supplied a perfect answer (although I prefer my own variant, that...