Forum Replies Created

Viewing 15 posts - 6,706 through 6,720 (of 7,597 total)

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    ScottPletcher (2/28/2013)

    Zero chance. I'd never disable autogrow on tempdb: you could slam your entire instance to a halt -- or worse, perhaps cause it to crash.

    If you've...

    February 28, 2013 at 11:04 am

    #1592123

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    ScottPletcher (2/28/2013)

    Zero chance. I'd never disable autogrow on tempdb: you could slam your entire instance to a halt -- or worse, perhaps cause it to crash.

    If you've...

    February 28, 2013 at 11:02 am

    #1592122

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    ScottPletcher (2/28/2013)

    If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources...

    February 28, 2013 at 10:52 am

    #1592113

  • RE: Adding an extra file to TEMPDB

    GilaMonster (2/28/2013)

    ScottPletcher (2/28/2013)

    If the temp files are growing, I don't want to allocate them smaller and force them to grow every time SQL starts: that's a waste of resources vs...

    February 28, 2013 at 10:51 am

    #1592112

  • RE: Adding an extra file to TEMPDB

    GilaMonster (2/28/2013)

    You don't need to correct the situation where one of more of the files has expanded because on restart of SQL the files will be back to their defined...

    February 28, 2013 at 10:44 am

    #1592102

  • RE: Adding an extra file to TEMPDB

    So you don't use a startup proc to verify tempdb data files are all the same size and sync them if they are not?

    How, then, do you become aware of...

    February 28, 2013 at 10:30 am

    #1592096

  • RE: get the first and last day of any Year/Month

    Jeff Moden (2/26/2013)

    Just to emphasize the performance differences between using a string conversion or not for date conversions, let's do a little test... a race, really.

    Here's the test data. ...

    February 28, 2013 at 10:27 am

    #1592094

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/27/2013)

    ScottPletcher (2/27/2013)

    If a tempdb data file is 1.5G when SQL goes down, won't it be 1.5G when SQL comes back up? Isn't it automatically reset to its...

    February 27, 2013 at 3:09 pm

    #1591766

  • RE: Adding an extra file to TEMPDB

    Maybe it's just an issue I had.

    The last time I altered the SIZE of tempdb data files in SQL, when SQL restarted tempdb files were still larger than that.

    If the...

    February 27, 2013 at 2:58 pm

    #1591757

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/27/2013)

    ScottPletcher (2/27/2013)

    Then, set up a start up proc to shrink both tempdb files

    NEVER manually shrink tempdb files. It can corrupt the tempdb files. Avoid shrinking files of any...

    February 27, 2013 at 2:54 pm

    #1591755

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/27/2013)

    ScottPletcher (2/27/2013)

    Then, set up a start up proc to shrink both tempdb files

    NEVER manually shrink tempdb files. It can corrupt the tempdb files. Avoid shrinking files of any...

    February 27, 2013 at 2:54 pm

    #1591752

  • RE: Adding an extra file to TEMPDB

    GilaMonster (2/27/2013)

    ScottPletcher (2/27/2013)

    Then, set up a start up proc to shrink both tempdb files ... I'd say to 1G each, so you have some cushion. You really don't ever...

    February 27, 2013 at 2:53 pm

    #1591751

  • RE: Log File full / Database Down

    Hmm, now that the db is in recovering status, you may not be able to (temporarily) add another log file on a different drive to allow the db to keep...

    February 27, 2013 at 2:43 pm

    #1591743

  • RE: UDF Help

    TheSQLGuru (2/27/2013)

    . . .it about as joyous as an aggregated view calling an aggregated view.

    You can do THAT TOO in SQL Server?!? Jeez, what a suck-@ss product! :w00t:

    No,...

    February 27, 2013 at 2:31 pm

    #1591734

  • RE: Is a doomed transaction inevitable if deadlock occurs in a trigger (SQL Server 2008 R2)?

    If XACT_STATE() returns -1 [uncommitable transaction], you can't do anything else except rollback the current transaction. That is a logical restriction within SQL Server itself.

    In that case, you would...

    February 27, 2013 at 1:35 pm

    #1591718

Viewing 15 posts - 6,706 through 6,720 (of 7,597 total)