Forum Replies Created

Viewing 15 posts - 7,051 through 7,065 (of 7,613 total)

  • RE: Exercises in t-SQL

    CELKO (12/1/2012)

    I use this query as extra credit for my students when I teach a SQL class. ... This is much trickier than it sounds at first....

    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 3, 2012 at 8:33 am

    #1564909

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    ... and got some pretty mediocre answers from (supposedly) experienced and skilled T-SQLers.

    I am not be surprised when good skilled T-SQLers come up with stupid answers on paper...

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

    November 30, 2012 at 4:50 pm

    #1564606

  • RE: Exercises in t-SQL

    capnhector (11/30/2012)

    ScottPletcher (11/30/2012)

    Eugene Elutin (11/30/2012)

    ScottPletcher (11/30/2012)

    ...

    In the interests of being thorough, I added a Message to my proposed solution back to them:

    SELECT

    ...as above...,

    ...

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

    November 30, 2012 at 4:45 pm

    #1564605

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    ScottPletcher (11/30/2012)

    ...

    In the interests of being thorough, I added a Message to my proposed solution back to them:

    SELECT

    ...as above...,

    CASE WHEN...

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

    November 30, 2012 at 4:13 pm

    #1564599

  • RE: How to use values keyword as parameter of a function

    Jeff Moden (11/29/2012)

    capnhector (11/29/2012)

    EDIT: This is also for me to play with a couple of things and get more experience with them. so it may not be fast...

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

    November 30, 2012 at 1:53 pm

    #1564570

  • RE: Help On Execution Plan Status

    Grant Fritchey (11/30/2012)

    And the indexes have to be selective enough to be useful for a seek or you'll get scans. Same things apply to non-clustered indexes too.

    For lots more detail...

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

    November 30, 2012 at 12:28 pm

    #1564526

  • RE: Bulk Insert Row Terminator Woes

    rwm972 (11/30/2012)

    Hi All,

    I'm trying to bulk insert a pipe-delimited file with <CR><LF> as a row terminator. The problem is some fields may contain <CR><LF>. So, I've asked the client to...

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

    November 30, 2012 at 12:27 pm

    #1564525

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    ... and got some pretty mediocre answers from (supposedly) experienced and skilled T-SQLers.

    I am not be surprised when good skilled T-SQLers come up with stupid answers on paper...

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

    November 30, 2012 at 10:54 am

    #1564498

  • RE: Exercises in t-SQL

    Jeff Moden (11/30/2012)

    ScottPletcher (11/30/2012)

    Jeff Moden (11/29/2012)

    That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single query". It's...

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

    November 30, 2012 at 10:49 am

    #1564495

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    what do you mean by "mid-score"? Do you mean average or second largest score (from three possible ones)?

    The middle one. You're listing all the actual scores each...

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

    November 30, 2012 at 8:49 am

    #1564432

  • RE: Exercises in t-SQL

    (Deleted, duplicate)

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

    November 30, 2012 at 8:47 am

    #1564428

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    mid_score --may be NULL if only one test taken

    low_score --may be NULL if only one or two tests taken

    Looks a bit illogical to me...

    I can see why...

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

    November 30, 2012 at 8:45 am

    #1564424

  • RE: FKs and indexes

    PiMané (11/30/2012)

    ScottPletcher (11/29/2012)

    PiMané (11/29/2012)

    ScottPletcher (11/29/2012)

    When you create the nonclustered index on c2, explicitly specify c1 as a key after that.

    Then define the FK on (c2, c1) and you should be...

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

    November 30, 2012 at 8:37 am

    #1564417

  • RE: Exercises in t-SQL

    Jeff Moden (11/29/2012)

    That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single query". It's sometimes amazing what...

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

    November 30, 2012 at 8:28 am

    #1564411

  • RE: FKs and indexes

    PiMané (11/29/2012)

    ScottPletcher (11/29/2012)

    When you create the nonclustered index on c2, explicitly specify c1 as a key after that.

    Then define the FK on (c2, c1) and you should be covered.

    if the...

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

    November 29, 2012 at 4:20 pm

    #1564089

Viewing 15 posts - 7,051 through 7,065 (of 7,613 total)