I've sometimes seen problems caused by COALESCE because it has that quirk of choosing the data type of all its parameters with the highest precedence.  Either should be used sparingly...

Note: this article was first published in 2003.

Back in the SQL Server 2000 days, the GUI tools for SQL Server were...

I think there may be some confusion between Extended Events, and Event Notification.  Extended Events are what the script you provided would create, and can write to targets such as...

Glad you got it figured out.  I know hunting through the Active Directory structures can be painful sometimes. 🙂

The performance mainly depends on the indexes available for the table and how up to date statistics are.

If there is not an index that has person_id as the first column,...

Have you looked at the execution plan for this?   Depending on...

Please note this is a 14 year old thread.  The original function shown should now be written as a inline table valued function, not the way this is.  Also, just...

I notice you say this is a SQL Server 2008 R2 cluster.  I want to get clarification on what you are saying.  Are you saying when Node2 is the active...

I have a developer attempting to install and use SSIS locally with his SQL 2017 instance...Now, when he runs SSMS to connect to Integration services he gets the "class...

I've found working with Excel as a source for SSIS works a little better when you specify Data Access Mode = "SQL command" and when the first row has column...

1. Do you have an execution plan as a .sqlplan file or .pesession file that you can share with us?
2. What are the indexes on the tables:

   ADHOC.ATS_ESH

   ADHOC.ATS_ESL

   TSI.ZATS_BROKER_FEED

3. I notice you...

• This reply was modified 5 years, 11 months ago by Chris Harshman.

The Update Failed message reminds me of when I was a database developer some time ago working with Oracle, and the DBA's there programmed some automated job that would e-mail...

I heavily use the "Rules and Alerts" in Outlook to help manage my work e-mails to automatically put incoming messages into different folders, which I read at different times.  In...

Sorry I missed that point, you can find them and script them out in the Object Explorer Detail view in SSMS.  I believe the info is in the msdb.dbo tables:

sysproxies,...

I almost forgot, check if you have any SQL Agent jobs on the instance.  You can script those from the Object Explorer Detail window in SSMS.