Viewing 15 posts - 346 through 360 (of 1,790 total)
Can you use sys.dm_io_virtual_file_stats instead?
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...
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...
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...
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.
February 16, 2011 at 10:52 am
Jeff Moden (2/16/2011)
WayneS (2/15/2011)
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.
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...
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.
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...
February 15, 2011 at 2:10 pm
Brandie Tarvin (2/15/2011)
David Benoit (2/15/2011)
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...
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...
February 15, 2011 at 9:06 am
Paula-196779 (2/15/2011)
February 15, 2011 at 7:53 am
Viewing 15 posts - 346 through 360 (of 1,790 total)