I believe that once you have passed the data through some transforms that SSIS no longer considers the input to the MERGE JOIN as sorted, the transform just before the...

Bru is correct. We can't really help unless you post your code.

Can one of you index gurus take a look at this one about interpreting sys.dm_db_index_physical_stats? I think I might know the answer, but I'm not sure and I don't...

I don't think I'd do it personally, but I don't see a problem with it. Basically the original designer wanted to be able to reference the most recent or...

A simple, T-SQL only process would be something like this (not tested so you may have to make some changes):

CREATE TABLE EmployeeQueue

(

EmpId...

A job could call a stored procedure (my preferred method) or it could just be T-SQL.

You'd have to write a windows service, probably use .NET, that reads unprocessed rows in...

No problem. Until fairly recently I didn't even know you had to consider it.

The N signifies unicode and keeps a conversion from happening. sp_executesql expects nvarchar (Unicode) parameters so when assigning values to them you should use N'string'

Yes, whenever you are returning data from more than 1 table you need to JOIN the tables.

First of all the query you have posted is a cross join which creates a Cartesian product. You need to specify the column(s) you are joining the 2 tables....

Homebrew01,

How long do you need that for? The backup history is never cleaned up unless you do it. Here's one person's reason why, http://feedproxy.google.com/~r/BrentOzar-SqlServerDba/~3/NPNxT9sz2uE/

I'd look into Merge Replication. I'd also look at Service Broker. Either will be better than cross-server triggers.

Okay, I have a couple of comments about your situation.

1. Don't do it this way. You do not want a trigger to have to do anything outside the...

Here's what I use to cleanup MSDB backup and mail history:

DECLARE @oldest_date DATETIME

SELECT

@oldest_date = DATEADD(MONTH, -6, MAX(Backup_finish_date))

FROM

msdb.dbo.backupset;

EXEC msdb.dbo.sp_delete_backuphistory @oldest_date =...

I don't know how the CRM Link to Web Page option works because I don't run the CRM product, but if you are specifying the link to the report you...