Forum Replies Created

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

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

    Jeff Moden (3/1/2013)

    ScottPletcher (3/1/2013)

    Jeff Moden (3/1/2013)

    Eugene Elutin (2/28/2013)

    This cut down number of CPU cycles when performing multiplication as it takes less number of bit-moves for multiplying smaller numbers - I...

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

    March 1, 2013 at 2:20 pm

    #1592584

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

    Jeff Moden (3/1/2013)

    ScottPletcher (3/1/2013)

    Code reuse is another tricky subject. It generally gets talked about far more often than it is genuinely done. A few developers are bad enough,...

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

    March 1, 2013 at 2:18 pm

    #1592581

  • RE: Select full month number (with 0)

    Sean Lange (3/1/2013)

    ScottPletcher (3/1/2013)

    Or simply:

    SELECT CONVERT(char(2), myDate, 1)

    I don't think will quite work Scott. The OP said they are using month(MyDate) which will return an int. Casting a single digit...

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

    March 1, 2013 at 2:15 pm

    #1592580

  • RE: Kill alter Index rebuild Jobs

    First, make sure you're checking index fragmentation and only rebuilding indexes that actually need it.

    Also, if you have tempdb properly tuned, look into using "SORT_IN_TEMPDB = ON" option when rebuilding...

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

    March 1, 2013 at 1:53 pm

    #1592569

  • RE: Select full month number (with 0)

    Or simply:

    SELECT CONVERT(char(2), myDate, 1)

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

    March 1, 2013 at 1:09 pm

    #1592546

  • RE: SQL Agent skipping job execution

    Just trying to find something that fits the symptoms...

    Is it possible that a db was deleted (offlined???) during your processing?! Perhaps a process that deletes and then restores 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".

    March 1, 2013 at 11:35 am

    #1592509

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

    Lynn Pettis (3/1/2013)

    ben.brugman (3/1/2013)

    Jeff Moden (2/26/2013)

    Just be aware that string conversions of dates will be a bit slower than integer conversions. It'll take a million rows to notice 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".

    March 1, 2013 at 10:42 am

    #1592487

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

    Jeff Moden (3/1/2013)

    Eugene Elutin (2/28/2013)

    This cut down number of CPU cycles when performing multiplication as it takes less number of bit-moves for multiplying smaller numbers - I should accept that...

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

    March 1, 2013 at 10:40 am

    #1592485

  • RE: Help getting all the weeks between two random dates for each row

    Please see if this gives you a useful result:

    SELECT

    siwh.ItemNumber, siwh.StoreNumber, w.Weeks

    FROM #StoreItemWeeksHave siwh

    INNER JOIN #Weeks w ON

    w.Weeks BETWEEN siwh.WeekStart AND siwh.WeekFinish

    ORDER BY

    ...

    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 3:53 pm

    #1592211

  • 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

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