Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 7,619 total)

  • RE: SYNTAX Help please...

    Jeff Moden (12/20/2013)

    ScottPletcher (12/20/2013)

    Jeff Moden (12/20/2013)

    ScottPletcher (12/19/2013)

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent...

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

    December 20, 2013 at 2:40 pm

    #1675317

  • RE: SYNTAX Help please...

    Jeff Moden (12/20/2013)

    ScottPletcher (12/19/2013)

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use...

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

    December 20, 2013 at 12:48 pm

    #1675291

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    Snargables (12/19/2013)

    I had to create an index that added all the columns in the include of the index. This was because i created a function that has to return 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".

    December 19, 2013 at 2:44 pm

    #1675014

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    wolfkillj (12/19/2013)

    ScottPletcher (12/19/2013)

    Jeff Moden (12/18/2013)

    ScottPletcher (12/18/2013)

    If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than...

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

    December 19, 2013 at 2:03 pm

    #1674994

  • RE: need help on design of database for student registration system

    Sigerson (12/19/2013)

    Grant Fritchey (12/18/2013)

    I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while...

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

    December 19, 2013 at 8:10 am

    #1674834

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    Jeff Moden (12/18/2013)

    ScottPletcher (12/18/2013)

    If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having 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".

    December 19, 2013 at 8:04 am

    #1674830

  • RE: SYNTAX Help please...

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use it in IF...

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

    December 19, 2013 at 7:58 am

    #1674823

  • RE: SYNTAX Help please...

    I'm truly curious now:

    Can anyone tell me:

    Where "IS NULL" can't be used in place of ISNULL()?

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

    December 18, 2013 at 5:43 pm

    #1674678

  • RE: SYNTAX Help please...

    Evil Kraig F (12/18/2013)

    Scott,

    I'm not sure how that's more or less obscure, but it's certainly easier for me to read. I work with a lot of 'iffy' data 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".

    December 18, 2013 at 5:42 pm

    #1674677

  • RE: SYNTAX Help please...

    Lynn Pettis (12/18/2013)

    ScottPletcher (12/18/2013)

    Lynn Pettis (12/18/2013)

    Lynn Pettis (12/18/2013)

    Luis Cazares (12/18/2013)

    ScottPletcher (12/18/2013)

    Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly...

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

    December 18, 2013 at 5:31 pm

    #1674675

  • RE: SYNTAX Help please...

    Lynn Pettis (12/18/2013)

    Lynn Pettis (12/18/2013)

    Luis Cazares (12/18/2013)

    ScottPletcher (12/18/2013)

    Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being tested...

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

    December 18, 2013 at 5:24 pm

    #1674671

  • RE: SYNTAX Help please...

    Lynn Pettis (12/18/2013)

    Luis Cazares (12/18/2013)

    ScottPletcher (12/18/2013)

    Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being tested is clearer.

    IF...

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

    December 18, 2013 at 5:18 pm

    #1674669

  • RE: SYNTAX Help please...

    Luis Cazares (12/18/2013)

    ScottPletcher (12/18/2013)

    Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being tested is clearer.

    IF (@category 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".

    December 18, 2013 at 5:12 pm

    #1674668

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having a dopey, useless cluster...

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

    December 18, 2013 at 4:40 pm

    #1674665

  • RE: need help on design of database for student registration system

    Yes, definitely do a logical design first. Don't even think about artificial keys yet.

    You need to identify "entity" and "attribute". Roughly:

    Entity = things about which you store unique...

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

    December 18, 2013 at 4:13 pm

    #1674659

Viewing 15 posts - 6,286 through 6,300 (of 7,619 total)