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

You need to do something like:

DECLARE @path NVARCHAR(MAX),

@filename NVARCHAR(MAX);

SET @path = N'C:\Taillog_backup\'

Set @filename =...