arnipetursson, great find. I confirmed sp_setnetname worked and I consider it much cleaner as behind the scene this line does the magic:

EXEC %%LinkedServer ( Name = @server ) . SetDatasource...

Interesting, thanks for the lead, I appreciate it!

Yesterday I found I could "trigger" a refresh of the linked server by running sp_serveroption, setting an existing option to itself for the...

Ah, awesome, thanks for sharing this!

Using the link Lynn mentioned you'll likely need to start SQL Server in single user mode (-m). If you find that you can't connect to the instance after doing this...

@Deadlock priority, I don't think this is a factor here... deadlocks aren't occurring at all but thank you for a response!

@Blocking, I should've been more specific. The blocking does not...

Jeff Moden (10/19/2013)

---

AmarettoSlim (10/19/2013)

---

Can I ask why you don't want a loop? Recursion via a common table expression (CTE) can be your friend in this case.

DECLARE @fromYear DATETIME, @toYear DATETIME

SELECT...

You mentioned this is primarily a read heavy box, correct? If that's the case then going to RAID 5 might be the move to make if cost is a concern...

Can I ask why you don't want a loop? Recursion via a common table expression (CTE) can be your friend in this case.

DECLARE @fromYear DATETIME, @toYear DATETIME

SELECT @fromYear='1913-01-01', @toYear='1998-01-01'

WITH...

Per the 2008 SQL Licensing Overview:

The Business Intelligence components for SQL Server 2008 include Analysis Services, Reporting Services, and Integration Services. To use any of these components, the server on...

I'd recommend using SSIS as its purpose is for developing ETL processes. If you want to stay within I would use a pass through approach via open query vs a...

To loop back for those who might stumble on this. We found a decent accumulation of the THREADPOOL wait and ended up resolving the connection timeouts by tweaking the MAXDOP...

I found the answer to my own question. For others wondering, connect to the subscriber and run the following:

USE <subscriber_db>

GO

SELECT publisher,publication, distribution_agent,transaction_timestamp

FROM dbo.MSreplication_subscriptions

The transaction_timestamp value contains the Log Sequence Number...

I just dug up the plan and sure enough you're correct HowardW!

This is the plan:

INSERT <---Clustered Index Insert <--- Sort <--- Compute Scalar <--- Compute Scalar <--- TOP <--- Clustered...

Ah cool, thanks for the explanation, I appreciate the response!

There is a clustered index on a single field for the destination table (and it's different than the clustered index of...

Resurrecting this thread with a question I have...

Can someone explain why SQL Server doesn't support object level recovery in a native manner?

How do 3rd party vendors make this possible?

I'm just...