Forum Replies Created

Viewing 15 posts - 6,721 through 6,735 (of 7,619 total)

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

    Eugene Elutin (2/28/2013)

    davidsatz (2/28/2013)

    So I am not hearing anyone disagree with my conclusion that there is no way to accomplish this...:ermm:

    I'm not exactly sure what you are looking to do,...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 2:57 pm

    #1592197

  • RE: Adding an extra file to TEMPDB

    Int'l Paper also was buying lots of companies for awhile, some of them other paper companies.

    During a merger, there are legal restrictions on what can and can't be viewed, in...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 12:48 pm

    #1592169

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    Exactly. If the drive space is there, why not allocate it? I'm not going to use it for anything else.

    The reason for allocating multiple files is to avoid...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 12:42 pm

    #1592167

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    ScottPletcher (2/28/2013)

    I have additional space to grow, you prevent it.

    So if a task unexpectedly needs, say, 50MB more of tempdb space to complete, you abend it -- perhaps...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 11:41 am

    #1592145

  • RE: Adding an extra file to TEMPDB

    GilaMonster (2/28/2013)

    ScottPletcher (2/28/2013)

    GilaMonster (2/28/2013)

    ScottPletcher (2/28/2013)

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 11:37 am

    #1592142

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    ScottPletcher (2/28/2013)

    So if tempdb now does need to grow for whatever reason, and it causes a SQL issue because it can't, you've guaranteed that there's no easy way...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 11:30 am

    #1592140

  • RE: Adding an extra file to TEMPDB

    GilaMonster (2/28/2013)

    ScottPletcher (2/28/2013)

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 28, 2013 at 11:21 am

    #1592132

  • 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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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. ...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    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...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    February 27, 2013 at 3:09 pm

    #1591766

Viewing 15 posts - 6,721 through 6,735 (of 7,619 total)