Forum Replies Created

Viewing 15 posts - 16,501 through 16,515 (of 26,484 total)

  • RE: Stop, Don't Panic

    sjsubscribe (3/16/2010)

    Steve Jones - Editor (3/16/2010)

    I've actually had to tell a VP to "go away" when I was managing. It was bad enough that I would go in to check...

    March 16, 2010 at 12:39 pm

    #1134729

  • RE: Unzip .gz compressed XML file using SSIS

    Yes, you would use the EXECUTE PROCESS Task to run gzip to uncompress the file.

    March 16, 2010 at 12:36 pm

    #1134726

  • RE: Hourly backups + Weekly full = Overlap = problems???

    jpSQLDude (3/16/2010)

    Lynn Pettis (3/16/2010)

    Don't delete that t-log backup file created at 1:05. It is fine. If you should need to restore that database to 1:03, you will need...

    March 16, 2010 at 12:34 pm

    #1134725

  • RE: Today's Random Word!

    Paul White (3/16/2010)

    Lynn Pettis (3/16/2010)

    As often as I write cursors, it probably would have taken just as long.

    I see. I write a fair number of cursors, usually for drip-feeding...

    March 16, 2010 at 12:20 pm

    #1134715

  • RE: Full backup Scenario

    Mark D Powell (3/16/2010)

    Lynn, after a restore of a database in full backup mode the database reflects both the contents of the database and the transactions recovered from the log...

    March 16, 2010 at 12:19 pm

    #1134714

  • RE: Today's Random Word!

    Paul White (3/16/2010)

    Lynn Pettis (3/16/2010)

    The only problem was the time it took to rewrite dynamic sql. Getting all the single quotes (') right is a RPITB, but once done,...

    March 16, 2010 at 12:02 pm

    #1134697

  • RE: Hourly backups + Weekly full = Overlap = problems???

    jpSQLDude (3/16/2010)

    I haven't forgotten this thread, and I am STILL working on this (I will know everything there is to know about SQL backups very soon!)

    One other really funky thing...

    March 16, 2010 at 11:42 am

    #1134682

  • RE: Today's Random Word!

    Paul White (3/16/2010)

    Lynn Pettis (3/16/2010)

    Turned out I ended up rewriting my own routine to use ALTER USER instead of sp_change_user_login (thanks Paul).

    LOL. You should have edited your previous post...

    March 16, 2010 at 11:22 am

    #1134664

  • RE: Full backup Scenario

    Mark D Powell (3/16/2010)

    I will disagree with the official answer because the question did not ask if the transaction was included in the backup file but rather asked if the...

    March 16, 2010 at 11:14 am

    #1134658

  • RE: Transaction log of a database

    Would you mind explaining further what you are looking for? Your question is a little vague.

    March 16, 2010 at 11:02 am

    #1134645

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/16/2010)

    Steve Jones - Editor (3/16/2010)

    I have had some authors that we have gone through 5 or 6 drafts to get a barely understandable article.

    And I've apologized for that...

    March 16, 2010 at 10:39 am

    #1134625

  • RE: SQL DBA- Areas of Knowledge

    Grant Fritchey (3/16/2010)

    I agree, the best skill you can begin to develop immediately is the ability to do a search. Remember, you're not the first person down this path. Actually,...

    March 16, 2010 at 9:52 am

    #1134582

  • RE: Today's Random Word!

    CirquedeSQLeil (3/15/2010)

    Jeff Moden (3/15/2010)

    Lynn Pettis (3/14/2010)

    snowshoes

    One Post. 😉

    yeah, he's holding out on us now. He retreated to the tent knowing he was at 9999.

    I wanted the 10,000th post to...

    March 16, 2010 at 9:50 am

    #1134579

  • RE: Are the posted questions getting worse?

    I am trying to finish up 2 articles for Grant and the Standard. Somehow life and work keep getting in the way.

    March 16, 2010 at 9:46 am

    #1134576

  • RE: Orpaned logins

    Okay, took awhile but I finally have it written using ALTER USER.

    declare @ DatabaseName sysname = 'H90TST'; -- Added a space between @ and variable name to post code

    declare...

    March 16, 2010 at 9:38 am

    #1134567

Viewing 15 posts - 16,501 through 16,515 (of 26,484 total)