I don't have any pork chops for the arsenal. So, they work. T-Shirts are good as always. Of course for us cold weather folks some cool SSC beanies would be...

You are correct that if you didn't have SAN redundancy and you were to lose the SAN mirroring would not help. So, my belief would be that the document was...

Yes. If you are going to get granular and define only certain tables then you would need to use transactional replication. The are quite a few considerations and you should...

The easiest method to make this consistent would be to utilize replication. If this can be an update that occurs once per day then look at snapshot. If it requires...

Hard to say exactly what you would need but it sounds like you could consider either BULK INSERT or SSIS to get the data from file to the database. Then...

You can use a couple of methods including detach / copy / attach or backup / restore. Both are very effective.

As for the automatic update process, what are you...

Sam - Now would be a time to work through the execution...

GSquared (1/23/2009)

---

I must be missing something on DavidB's solution, because I copy-and-pasted it into Management Studio, and killed it when it hit the 1-minute mark, at which point it had...

Jeff Moden (5/28/2007)

---

Heh... looking at it the wrong way...

Original budget/deadline was wrong because you didn't bid right... Client necessarily changes scale... wants to know why idiots wrote code that wasn't...

Check out sp_adddistributor. This will allow you to do that. You will have to go to the new distributor first and establish the publishing server as a valid publisher. Once...

Every once in a while I get a good one. 😛

Not sure what you were seeing in the Execution Plan but I was seeing the Key Lookup of the...

The run time difference is due to the fact that is has to load so many data pages in order to get the information that you are seeking. My guess...

Something like the following on both the _LIVE and the _ARCHIVE table should help.

USE [IDX]

GO

CREATE NONCLUSTERED INDEX NI_TRANSAC_LIVE

ON [dbo].[TRANSAC_LIVE] ([PROC_ZZ],[SER_DT], [GROUP_ZZ],[PATIENT],[INVOICE])

INCLUDE ([POST_PD])

GO

As always, look at the execution plan to...

Odd, as I just opened the plan that you attached. I see Key Lookups on your Archive and your Live tables.

I'll poke a bit more in the AM. Thanks!

Doing away with the two key lookups will probably save you quite a bit. I will take a look to see if I can provide some additional information tomorrow on...