Viewing 15 posts - 886 through 900 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 26, 2009 at 7:06 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 26, 2009 at 4:25 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 26, 2009 at 2:38 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 26, 2009 at 11:25 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 25, 2009 at 9:17 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 24, 2009 at 9:33 pm
samsql (1/23/2009)
the sp which was running was taking 1 hr rite now it is taking 7 hrs to complete...
Sam - Now would be a time to work through the execution...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 24, 2009 at 12:47 pm
GSquared (1/23/2009)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2009 at 12:32 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 23, 2009 at 9:19 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2009 at 2:07 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2009 at 11:43 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2009 at 9:58 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 22, 2009 at 9:01 am
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!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 7:30 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 21, 2009 at 5:50 pm
Viewing 15 posts - 886 through 900 (of 1,790 total)