No need to do that, read comitted is the default isolation level in SQL

IF exists (select * from dbo.sysobjects

Just note that in sql dates always have assocated times. Getdate() returns date and time, not just date. There's no built in function that only returns date.

I believe using DateDiff() is going to offer the best performance and clearest results.

Clearest results possibly, but very definately not best performance. Be very careful when applying any function...

Yes, locks will be taken on the base table. You can see this my running the stored proc sp_lock or looking at the system table syslocks (located in the master database)....

That's the way to create tables in SQL 2000 and SQL 2005. MS

SQL Server doesn't implement that portion of the SQL 1999 standard. Offhand, I can't think of a...

If it's a parent table and several child tables you can create foreign keys (or modify existing ones) and set them to cascade delete. Then you delete from the parent and the...

What I would recomend, if you're using stored procdures (and if you're not, why not?) is to do the summary calc in the sp before or after inserting the detail...

The question does state the version. Look at the category

Category : SQL Server 2005 - TSQL

The pseudocode looks OK at a quick glance. Can you post the actual code? Would be easier to debug.

Why global temp tables?

Triggers would work, but they'd be very resource intensive.

Why do you need to store summary information when it can be recalculated easily? If it's for a report than it can...

Category : SQL Server 2005 - TSQL

Question - Worth 2 Point(s):

What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin....

If the foreign key between the tables is set to cascade delete them you can delete from the parent and SQL will cascade the deletes down to the child table....

22GB? I have a production system that has 48GB of memory in it, 44GB assigned to SQL Server. Runs beautifully, just takes a week to shutdown.

SELECT DATALENGTH(image_field) FROM tbl

Returns the number of bytes that the field takes up. (replace image_field with the name of the field containing the image and tbl with the name of the...