Forum Replies Created

Viewing 15 posts - 7,891 through 7,905 (of 39,877 total)

  • RE: Default tempdb in SQL Server 2106

    I'm trying. Sometimes inspiration is hard.

  • RE: Are the posted questions getting worse?

    It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair...

  • RE: Are the posted questions getting worse?

    So, out Fri and Sat to help my kid work on his Eagle Scout project (finally). We went from this Fri:

    to this by Sat afternoon:

    Proud of his efforts, including managing...

  • RE: Are the posted questions getting worse?

    jasona.work (7/11/2016)


    Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would...

  • RE: Sequence generation

    You could use row_number to build a list that increments from the last item.

    I'm not sure where you need this, or when, so it's hard to do code, but if...

  • RE: Unable to Move DB to Another Computer

    Did you ensure a valid path was listed for the files? The backup file looks for the original path for the files.

    If you went to restore over an existing database,...

  • RE: TDE - Encryption on a large database

    OK, so when I read that, I think I must have either had encryption go quicker than expected, or missed a block somewhere.

    I'd read that as no backups during encryption,...

  • RE: TDE - Encryption on a large database

    brickpack (7/7/2016)


    I read somewhere that I'll need to disable Backups and database maintenance during the encryption process. Is this true?

    This is very concerning, since my testing took ~4 days to...

  • RE: Are the posted questions getting worse?

    Fourth was quiet. Cut grass, a little volleyball with the family, cooked dinner, watched a few fireworks from the side of the road.

  • RE: Email or Username

    ZZartin (6/29/2016)


    Jeff Moden (6/28/2016)


    Meh... just have them use their SSN. :-):-D:-P;-):hehe::sick:

    When Wells Fargo first started doing online banking their default user name was in fact SSN, for years, originally I...

  • RE: The Bad Data Shutdown

    David.Poole (7/6/2016)


    If we are planning to do a continuous delivery system for vehicle software then we need to have some heavy weight software engineering that expects unexpected signal failure.

    Yep. +100

  • RE: Migrating Encrypted Data

    Thanks for the update. Those are definitely two critical things.

    If you don't mind, can you mark your update as the correct answer for future readers?

  • RE: Single database attached to two instance - how to take backups from each instance

    GilaMonster (7/5/2016)


    Steve Jones - SSC Editor (7/5/2016)


    So if you have a 2008 RTM instance and a 2008 SP3 instance, you can restore RTM backups to the SP3 instance, but not...

  • RE: Unstructured data sources into a structured DW

    Jeff Moden (7/6/2016)


    Steve Jones - SSC Editor (7/6/2016)


    If it's low volume, do what's easiest. It won't matter enough.

    Heh... unless the low volume data also happens to be the most critical.

    Well,...

  • RE: Unstructured data sources into a structured DW

    My thoughts: If it's a set structure that needs to be queried often, the deserialize it into relational and store it properly. SQL Server works better with traditional row/col storage...

Viewing 15 posts - 7,891 through 7,905 (of 39,877 total)