Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 7,613 total)

  • RE: Including additional columns in a unique clustered index

    GilaMonster (3/4/2013)

    ScottPletcher (3/4/2013)

    GilaMonster (3/4/2013)

    dembones79 (3/4/2013)

    Should the region and district columns be included in the unique clustered index of the view?

    Bear in mind that a clustered index implicitly includes all...

    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 4:26 pm

    #1593213

  • RE: Adding an extra file to TEMPDB

    GilaMonster (3/4/2013)

    ScottPletcher (3/4/2013)

    The ALTER command to try to change an existing file to a smaller size gives you an error on SQL 2005.

    That's when you're trying to reduce the initial...

    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 4:04 pm

    #1593208

  • RE: Including additional columns in a unique clustered index

    GilaMonster (3/4/2013)

    dembones79 (3/4/2013)

    Should the region and district columns be included in the unique clustered index of the view?

    Bear in mind that a clustered index implicitly includes all the columns...

    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 4:00 pm

    #1593206

  • RE: Including additional columns in a unique clustered index

    Ok.

    At any rate, typically you'll want to cluster the table on the most common queries that can't be easily satisified by a nonclustered index you need anyway.

    For example, if (nearly)...

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

    #1593187

  • RE: SQL 2008 enterprise to standard degradation

    You're going to exactly the same version as originally, right?

    I think it's easiest to just restore all the dbs (other than model) after the switch.

    There are so many things 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".

    March 4, 2013 at 12:52 pm

    #1593143

  • RE: Including additional columns in a unique clustered index

    Hmm. In a normalized design, I wouldn't expect the region to be in the unit table, only the district.

    Instead, I'd expect the distinct list of districts w/i a region...

    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 12:42 pm

    #1593141

  • RE: Just accepted a Sr. DBA job. Time for a gut check?

    1. The scale: there will be many servers to manage, much more than I've had to work with in the past.

    2. The size of the instances: While the company is...

    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 12:36 pm

    #1593137

  • RE: Adding an extra file to TEMPDB

    GilaMonster (3/4/2013)

    ScottPletcher (3/4/2013)

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

    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 10:19 am

    #1593099

  • RE: Adding an extra file to TEMPDB

    Robert Davis (3/4/2013)

    ScottPletcher (2/28/2013)

    Yes, that's the problem. You're scattering (small) I/Os all over the drive, causing lots of drive head movement, which is brutal on performance.

    Allocating "one drive" is...

    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 10:12 am

    #1593092

  • 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

Viewing 15 posts - 6,691 through 6,705 (of 7,613 total)