Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 49,571 total)

  • RE: Truly cleaning sensitive LOB data

    SeanNerd (10/20/2016)

    Any ideas?

    Good luck. 🙂

    Incredibly difficult (and not limited to LOB columns, same thing can happen with normal tables). And, what about the old backups from before the mistake was...

    October 20, 2016 at 5:13 pm

    #1907825

  • RE: HELP! I've got to give a talk to our local .NET geek meet on SQL server

    aaron.reese (10/20/2016)

    I think I will concentrate on data types and what indexes are and what they do for performance. If people want to pick my brains afterwards about the...

    October 20, 2016 at 5:00 pm

    #1907822

  • RE: Causing a timeout error

    ram302 (10/20/2016)

    What if I create a transaction on the table and leave it uncommitted, will this cause a timeout in the script when trying to connect?

    No. That'll just leave...

    October 20, 2016 at 8:05 am

    #1907669

  • RE: Help with script

    Table definitions please, at the very least, sample data would be very useful too.

    October 20, 2016 at 7:48 am

    #1907655

  • RE: SQL Jobs auto start after downtime ends

    Please don't post multiple threads for the same question. From the other thread:

    GilaMonster (10/20/2016)

    Create a second schedule for each of those jobs that runs on the 1st Monday of the...

    October 20, 2016 at 4:27 am

    #1907605

  • RE: Licensing question

    If SSAS is on one server and SQL on another, both servers need to be licensed, you can't use the same license for the two servers. If you split the...

    October 20, 2016 at 4:09 am

    #1907594

  • RE: Missed SQL Server Jobs run after downtimes

    Create a second schedule for each of those jobs that runs on the 1st Monday of the month at something like 4:15 (give time for SQL and SQL Agent to...

    October 20, 2016 at 4:00 am

    #1907591

  • RE: DBCC CheckDB

    suchita0805 (10/15/2016)

    Having no backup of the database ..

    JasonClark (10/19/2016)

    So before going to restore your database you must verify the back health using restore verifyonly.

    Um.... Can't exactly verify something that...

    October 19, 2016 at 3:57 am

    #1907356

  • RE: DBCC CheckDB

    Can you post the full output of CheckDB?

    All I can tell you from what you posted is that you're going to lose data fixing this (and without a backup, checkdb...

    October 19, 2016 at 3:56 am

    #1907355

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/18/2016)

    Need a crystal ball or a contractor.

    Send the crystal ball over here when you're done please.

    October 18, 2016 at 3:31 pm

    #1907283

  • RE: DBCC Checkdb cannot exclusively lock database

    SQL Guy 1 (10/18/2016)

    Thanks Gail, now I can easily run checkdb against this snapshot (regardless whether other connections connected to it or not), and I expect it to run...

    October 18, 2016 at 3:26 pm

    #1907282

  • RE: DBCC Checkdb cannot exclusively lock database

    Weird...

    Can you try to run CheckDB on that snapshot that you manually created?

    October 18, 2016 at 12:13 pm

    #1907239

  • RE: DBCC Checkdb cannot exclusively lock database

    SQL Guy 1 (10/18/2016)

    Yes, I can easily create a snapshot on that database on a test server (haven't tried on production), even if other sessions connected to it.

    That's not...

    October 18, 2016 at 11:41 am

    #1907229

  • RE: Please Assist

    What language is that?

    Where do you get the numbers that need to be replaced and the numbers that replace them?

    October 18, 2016 at 4:33 am

    #1907084

  • RE: Please Assist

    What is that from? spj is not a T-SQL function, so not SQL Server.

    October 18, 2016 at 4:11 am

    #1907078

Viewing 15 posts - 2,206 through 2,220 (of 49,571 total)