Forum Replies Created

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

  • RE: Adding an extra file to TEMPDB

    GilaMonster (2/28/2013)

    stehoban (2/27/2013)

    Regarding point number 3 above. How to i reduce the size from 1.5gb to 800mb or 1gb ? Would this be by using the ALTER database command with...

    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 4, 2013 at 9:28 am

    #1593067

  • RE: Select full month number (with 0)

    Jeff Moden (3/3/2013)

    In this case, the silent truncation is actually a desirable thing. I just think it odd that Scott would favor this particular method because someone not-in-the-know would...

    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 4, 2013 at 8:19 am

    #1593027

  • RE: how does sql read tempdb multiple .ldf files

    BuntyBoy (3/1/2013)

    SQL Server uses datafile in parallel and log file in sequential order..

    Just as a best practice, for naming convention always try to use .ndf for second, third, etc 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".

    March 1, 2013 at 3:31 pm

    #1592609

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

    Jeff Moden (3/1/2013)

    ScottPletcher (3/1/2013)

    C'mon, be real, that code is clear enough that a decent developer will understand what it means. Anyone who's developed for SQL for any period 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".

    March 1, 2013 at 2:58 pm

    #1592596

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

    Lynn Pettis (3/1/2013)

    ScottPletcher (3/1/2013)

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

    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:30 pm

    #1592589

  • 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:23 pm

    #1592586

  • 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

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