I only wish the text of the post would be included in the notification mail...

I wasn't aware of this kb article, you've mentioned. I'll add this to my link library. Thanks!

What problem?

No, neither will be done automatically. SQL Server has a housekeeping thread that checks for such records, but I think they are not automatically release to the OS. Only when...

N denotes a unicode string, Unicode you can read up in BOL. As a start note the difference (only in DATALENGTH) in the script below.

SELECT

 RIGHT(N'123', 2)

 , RIGHT('123',2)

 , LEN('123')

 , LEN(N'123')

 , DATALENGTH('123')

 ,...

Another point to add:

You are *not* creating temporary tables in tempdb. Those tables begin with a #. You are creating permanent tables in the current database.

You might also want to...

The zonbies in management are even worse

Is it really a physical delete or isn't the record marked as ghost record?

Yes, I'm sure Clive is

Clive, good luck with that new job btw!

See if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Do this in the presentational layer of your app.

SQL Server's build-in IDENTITY property does only work on numeric column with a scale of 0....

Yes, TRUNCATE is minimally logged and as such described in BOL.

Further constraints for TRUNCATE. I think you need to be db_owner, ddl_admin or owner of that table in order...

See if this helps: http://www.sommarskog.se/arrays-in-sql.html

Correct, I was only joking on the name JSP. It can be a great confusion whether you mean this JSP or that JSP.

But I need in this date format mm/dd/yyyy...

Then do what Farrell has suggested. But I guess most folks here, including me, consider this a mere presentational issue which you...