There are no records in the system with an al.audit_event_id = '1234' that have a first name like "Love"????

Since the deletes are based upon this variable, and...

One method

CREATE TABLE #Test

(

UniqID int,

Status varchar(6)

)

INSERT INTO #Test(UniqID, Status)

VALUES(1, 'ABC'),

(1, 'DEF'),

(1, 'GHI'),

(1, 'XXX'),

(1, 'ZZZ'),

(2, 'ABC')

Select T1.UniqID, T1.STATUS

From #Test T1

WHERE T1.STATUS IN ('ABC',...

This function was posted someplace that i can't remember. Don't tell Moden is uses a loop though!

CREATE FUNCTION [dbo].[udf_StripHTML]

(@HTMLText VARCHAR(MAX))

RETURNS VARCHAR(MAX)

AS

BEGIN

...

Can you post some sample data and your queries?

The simple example is if the subquery returns more than one row for the joining condition.

If you use a join, the results contain extra rows.

EXISTS will not create...

There are couple things I see that don't make sense to me.

1. The "semester_id" in the Student table. This is a lookup to the Semester table.

If...

I've been at the new job for 2 months now. The past week or so I have been trying to make sense of the "noise" being sent from the...

Ed Wagner (10/16/2015)

---

Brandie Tarvin (10/16/2015)

---

Ed Wagner (10/16/2015)

---

jasona.work (10/16/2015)

---

I also noticed on mine, that there's another default on the updates options...

Where your machine will "share" updates with other machines INCLUDING ON...

dave 67553 (10/15/2015)

---

I am developing a plan for SQL Server 2012 EE to properly downsize and type (nchar to char types) some needlessly Unicode nvarchar(max) fields and would like to...

SELECT value,

cast(@@servername as varchar(255)) as Servername,

cast(SERVERPROPERTY('Collation')as varchar(255)) as Collation,

cast (SERVERPROPERTY('BuildClrVersion') as varchar(255)) BuildClrVersion

FROM sys.configurations

WHERE name = 'backup compression default' ;

The steps would be to create a central management server, and register all of your servers.

This article explains it:

https://msdn.microsoft.com/en-us/library/bb934126.aspx?f=255&MSPPError=-2147217396

This one will give you additional details:

https://msdn.microsoft.com/en-us/library/bb895144.aspx

They are selling lots of features that, according to the sale pitch, will make life easier for me.

Are you leveraging any of the features that are advertised (snapshots!) that...

So, which one did you end up going with, and why?

I am in the middle of this same process.

Setting up a central management server should work. The query can then be run against all of the registered servers