Forum Replies Created

Viewing 15 posts - 16,666 through 16,680 (of 26,489 total)

  • RE: Does re-indexing a table change the identity seed value on a row

    I don't visit AskSSC very often. Hard to tell what questions need answering or not.

    March 8, 2010 at 10:07 pm

    #1130437

  • RE: How Are Your Backups ?

    GT-897544 (3/8/2010)

    As a DBA if you don't have backups then it's time to usp_updateresume :hehe: We have SCOM alert and SQL alerts for monitoring jobs.

    EnjoY!

    Of course, what good is a...

    March 8, 2010 at 10:05 pm

    #1130436

  • RE: Are the posted questions getting worse?

    Paul White (3/8/2010)

    Anyone else noticed the frenzy of poor advice recently? Moderately aggravating.

    Yes, I have. I just hope I haven't been a party to some of it myself....

    March 8, 2010 at 10:02 pm

    #1130435

  • RE: Mirroring problem

    Okay, you have mirroring setup, but are you running periodic transaction log backups on the principle server?

    If not, that will explain why your log file on the principal server has...

    March 8, 2010 at 10:00 pm

    #1130433

  • RE: Too Tipsy To Work

    CirquedeSQLeil (3/8/2010)

    Lynn Pettis (3/8/2010)

    I got a call from an employer from which I was fired. They paid me $100 per hour, including travel time (3 hours), to come up...

    March 8, 2010 at 9:55 pm

    #1130429

  • RE: Does re-indexing a table change the identity seed value on a row

    The Wall (3/8/2010)

    Does re-indexing of a table change the IDENTITY Seed value on a row? I believe that the value stays the same unless the IDENTITY is re-incremented.

    No, reindexing...

    March 8, 2010 at 9:52 pm

    #1130426

  • RE: Are the posted questions getting worse?

    WayneS (3/8/2010)

    Lynn Pettis (3/8/2010)

    IT'S OFFICIAL!! Kirisa is now on Varsity! Coach told her today that she earned the position and is now one of his permanent defenders!!

    WAY TO...

    March 8, 2010 at 9:50 pm

    #1130424

  • RE: Too Tipsy To Work

    Matt Miller (#4) (3/8/2010)

    Michael Valentine Jones (3/8/2010)

    Matt Miller (#4) (3/8/2010)

    ..I've actually received calls from previous employers demanding I drive into work WHILE the state has a state of emergency in...

    March 8, 2010 at 9:12 pm

    #1130409

  • RE: Are the posted questions getting worse?

    IT'S OFFICIAL!! Kirisa is now on Varsity! Coach told her today that she earned the position and is now one of his permanent defenders!!

    WAY TO GO KIRISA!!!

    March 8, 2010 at 6:31 pm

    #1130369

  • RE: SQL Server x64 - Pagefile size is maxing out.

    How about experience. When we were setting up our 64-bit blade servers for SQL Server 2008 EE, I forgot to set the maximum memory on one of the servers....

    March 8, 2010 at 3:06 pm

    #1130315

  • RE: Too Tipsy To Work

    bpportman (3/8/2010)

    Since I am on call 24 * 7 * 365 with really know one to cover me, I guess my drinking days are over or I can just tell...

    March 8, 2010 at 3:01 pm

    #1130311

  • RE: Poor Performance in function AFTER Updating Stats

    Here is a rewrite of one of the functions you posted. Use it in the FROM clause using CROSS APPLY. I'd show you, but I didn't see a...

    March 8, 2010 at 2:47 pm

    #1130303

  • RE: Are the posted questions getting worse?

    Should have posted this Saturday.

    My daughter, Kirisa, made the JV squad during tryouts. This weekend (Friday and Saturday) she played 3 games at the Mesa Ridge Tournament with the...

    March 8, 2010 at 2:30 pm

    #1130293

  • RE: Inserting zero in Identity Column

    ramadesai108 (3/4/2010)

    Just 1 record with zero. If i insert data manully using query analyzer, then the second record is inserted with the identity of 2.

    Here is another user who is...

    March 8, 2010 at 12:55 pm

    #1130223

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/8/2010)

    I just realized the true term for what the Thread should be called.

    MCP (Master Control Program).

    Okay, that took me back to my Burroughs days as a computer operator... 😉

    March 8, 2010 at 10:51 am

    #1130161

Viewing 15 posts - 16,666 through 16,680 (of 26,489 total)