Viewing 15 posts - 346 through 360 (of 1,790 total)
Can you use sys.dm_io_virtual_file_stats instead?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 9:20 pm
Being that information is stored as commands and transactions at the distribution database I don't know that you will find the answer there. It definitely seems like your best option...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 12:50 pm
IF you have a window that you could drop the subscriptions, remove the article from the publication, save the publication, re-add the article, save publication and then create the subscription...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 11:49 am
So, ultimately you are ok with an out of sync condition existing for these tables? If so, what is the possibility of dropping the subscription, adding the rows on the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 11:07 am
My present picture is mainly due to my location, Buffalo, NY. Seemed fitting at the time. Might be changing it soon though. Looking for the right one.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 10:52 am
What does the table look like?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 8:10 am
Jeff Moden (2/16/2011)
WayneS (2/15/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 7:53 am
Have you run the estimation procedure, sp_estimate_data_compression_savings, to see what it reports back. As G_Squared stated some tables / data will not compress too well.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 7:33 am
In my opinion, if this is an interview question then you need to get this on your own, else you would really be misrepresenting yourself. Honestly let them know what...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 6:45 am
...and now I'm wondering if you were to trace your activity that you perform with the GUI if you would see that step being executed.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 2:12 pm
sqldba_icon (2/15/2011)
Is there a MSFT article which points to this? Thanks
I had looked for a few minutes after Brandie posted this and didn't find anything but I'm sure there is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 2:10 pm
Brandie Tarvin (2/15/2011)
David Benoit (2/15/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 12:17 pm
Of course, according to BOL it is supposed to update the cache with every change but it may not be happening here. I haven't heard of the job cache having...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 12:12 pm
You might want to check out the metadata behind the job in sysjobs and sysjobschedules and see what happens when you toggle them using the GUI vs the script. Definitely...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 9:06 am
Paula-196779 (2/15/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2011 at 7:53 am
Viewing 15 posts - 346 through 360 (of 1,790 total)