Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 39,769 total)

  • RE: Must declare the scalar variable "@value4".

    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...

  • RE: Freeze IO

    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...

  • RE: Great Developers

    manie (5/31/2016)


    Please allow me to make one thing clear. My post was not to rant about the unfairness of the job market although I believe it might have sounded like...

  • RE: Are the posted questions getting worse?

    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...

  • RE: How to do an Active/Active server setup in sql server 2012.

    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...

  • RE: The Clustered Index is not the Primary Key

    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...

  • RE: Are the posted questions getting worse?

    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...

  • RE: Are the posted questions getting worse?

    Ray K (5/26/2016)


    Hey Threadizens . . .

    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...

  • RE: Adding files to database

    Take it, and thanks, David.

  • RE: Are the posted questions getting worse?

    Mmm, tequila. Heading to Steamboat Springs tonight for the weekend. Half gallon packed

  • RE: Freeze IO

    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)...

  • RE: Freeze IO

    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.

  • RE: Freeze IO

    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...

  • RE: Freeze IO

    HappyGeek (5/24/2016)


    Good question on an undocumented(?) command, thanks.

    Yes, undocumented

  • RE: Grant > Deny?

    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...

Viewing 15 posts - 7,966 through 7,980 (of 39,769 total)