Have you looked at SQL Server Notification Services ?

Under SQL Server 2008, Notification Services is now part of Reporting Services and there is also a new feature named "Change Data...

Just as a follow-up, here are the resource usages when performing a SELECT instead of an UPDATE

[font="System"]

ResourceScanlogical readsCPU MSElapsed MS

Triangle Join:100001 455,648 23,103 ...

Jeff is quite correct on the performance affect of a triangular join so I decided to compare using the RANK window function available under SQL Server 2005 and 2008.

For...

Just a reminder that the freetext parameter needs to be defined as national varchar, so use

SELECT TOP 100 *

FROM dbo.People

WHERE freetext(Full_Name, N'sanders koernic john')

As an alternative, have you looked at...

"The Log, TempDB, and Data files all need to be in RAID5 configuration for optimum performance"

You need to find a real expert.

Here is an approach to confirm if a SAN...

Try this:

UPDATE#temp

setIDColumn

= (Select count(*)

from #temp as CustPrior

whereCustPrior.CustNumber = #temp.CustNumber

and (CustPrior.Createdate < #temp.Createdate

or ( CustPrior.Createdate = #temp.Createdate

andCustPrior.IDColumn<= #temp.IDColumn

)))

Looks like a POSIX time that is adjusted for a time zone of negative 6 hours (India?) - POSIX or UNIX time is the number of seconds since January 1st...

When the selected columns include one with a Text or Image datatype, DISTINCT and GROUP BY are not supported.

There is a system function named fn_virtualfilestats that will provided the statistics since SQL Server started.

I run this function every hour versus about 200 SQL Servers.

Table InstanceFileIORaw stages...

Are you aware the "TIME" is a reserved word and that there is a "TIME" datatype in SQL Server 2008 ? Please consider renaming the column. The same...

"some contacts have the ROLE of "MAIN" and "PREX", but I don't want those to come out - I only want those contacts with the ROLE of "MAIN" only to...

"Guess why they name division "floating point operation"?"

Got that and sorry I was not clear, but intend to ask "what is the precision and scale of the results?" Finally...

SYSCOMMENTS is no longer a table but is a view included for backward compatability. Module source is now in a varchar(max) column and can be obtained using at least...

Thanks Sergiy, as per all of your posts, a simple and elegent solution.

However, SQL Server has the resulting data type different that specified in BOL as "the result of ROUND...

Ran as test with 19,972 ORs and no problem were encountered. Believe that the only restriction will be the size of a single SQL statement that can be sent...