Viewing 15 posts - 7,966 through 7,980 (of 39,769 total)
As mentioned, I wouldn't recommend this technique. It looks like you're trying to write one routine to get counts from any database. Or are you looking for any table? You...
May 31, 2016 at 8:58 am
This command exposes the API for freezing IO. Snap software for SANs uses this to stop IO and get a disk mark where they can start copying data. In talking...
May 31, 2016 at 8:48 am
manie (5/31/2016)
May 31, 2016 at 8:46 am
Hope everyone had a good holiday weekend (those that had them). I had 3 days in Steamboat Springs, hiking and being mostly unwired. Then back to chores the last couple...
May 31, 2016 at 8:44 am
Agent jobs are per instance. Meaning that if you fail over, then you need to enable the jobs on the new instance and disable them on the old instance. This...
May 30, 2016 at 10:36 am
Terje Hermanseter (5/26/2016)
However, I like Kimberly Tripp's advice. Choose the clustering key separately from the PK, keep it unique, fixed, and narrow..
I'm not sure I fully understand the "choose the...
May 30, 2016 at 10:35 am
WayneS (5/30/2016)
RBarryYoung (5/27/2016)
Anyone else going to SQL Saturday in Philly next week? I don't think I recognized anyone on the speakers list...I'll be there.
Would like to, and see you...
May 30, 2016 at 10:33 am
Ray K (5/26/2016)
The other day (inspired by a couple of SQL Saturday speakers), I started my own blog.
My most recent entry tackles the very-often-asked-here-on-SSC question, "how...
May 26, 2016 at 8:37 am
Mmm, tequila. Heading to Steamboat Springs tonight for the weekend. Half gallon packed
May 25, 2016 at 1:09 pm
Ah, snaps are different. That's not a backup (usually), but a copy of the disk at a point in time. It should use the freeze to mark a stamp (somehow)...
May 25, 2016 at 10:13 am
George Vobr (5/25/2016)
Never knew of it. Thanks, Steve for sharing.
Me, either. It was a surprise to read about it and try it.
May 25, 2016 at 8:59 am
george sibbald (5/25/2016)
use at your peril I guess?Are these the commands used by hardware based backup solutions?
don't think so. Those use the VDI interface, which doesn't freeze IO, but rather...
May 25, 2016 at 8:59 am
HappyGeek (5/24/2016)
Good question on an undocumented(?) command, thanks.
Yes, undocumented
May 25, 2016 at 8:58 am
The rearrangement of information is intended to make keeping things up to date easier for MS and to prevent stale pages. I'm not sure this works great, but I understand...
May 24, 2016 at 1:18 pm
Viewing 15 posts - 7,966 through 7,980 (of 39,769 total)