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...

OK, here are a few suggestions.

Run profiler overnight and filter so that you'll only catch this sp.

Recompile the stored procedure if you haven't already. (sp_recompile) or mark if for recompile...

What happens in you run the DTS package from DTS designer?

Does the stored proc have any params that could have different values?

Can you change the job so it calls the...

You can put an IF EXISTS around the drop constraint, just as you did for the drop table.

IF

exists

Thanks. That's great.

The windows resource kit may not be possible. My server is an IA-64 machine. I don't know if there is a resource kit for it.

The perfinfo is very...

Also note that if you truncate the transaction log, you will not be able to restore the database fully after a failure. Without an unbroken set of tran log backups,...

3 hours, 30 -40 questions (can't remember exactly) Pass mark is around 75%.

No reference materials of any kind are allowed. You don't have books online or web access and you...

One minor correction, a row size can be a limitation and since, for char and varchar, 1 character=1 byte can be measured in characters. SQL rows have a max size...

The where clause is executed before the aliases in the select are resolved. The only place (in a simple select) that you can use an alias defined in the select...

Switch traceflag 1204 on on the server and whenever SQL encounters a deadlock it will write a deadlock graph into the error log. that can help you track down the...

There's probably a simpler way, but this will work

SELECT CASE IsPage WHEN 1 THEN 'Page'

 ELSE CASE IsFolder WHEN 1 THEN 'Folder'

   ELSE CASE ISMenu WHEN 1 THEN 'Menu'

    ELSE...