Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 7,619 total)

  • RE: Trigger or Not Trigger

    LutzM (9/3/2014)

    One of the issues when using triggers to audit changes is the ability to disable the trigger, apply the change and re-enable the trigger.

    Without any audit for DDL changes...

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

    September 3, 2014 at 11:55 am

    #1742951

  • RE: Trigger or Not Trigger

    Triggers can capture the originating user as well if you provide that info to the trigger. This can be passed in several ways, including CONTEXT_INFO, APP_NAME or even 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".

    September 3, 2014 at 10:42 am

    #1742905

  • RE: Index analysis

    Agreed, there's no easy way to tell if an index has extra columns. You can use the missing index stats to get a feel for missing column(s) though. ...

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

    September 3, 2014 at 10:33 am

    #1742899

  • RE: primary key discussion

    Eirikur Eiriksson (8/29/2014)

    Thank you Scott, Tom and Lynn, this was the discussion I wanted to get going in this context. The subject is far to dependent on the environment and...

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

    August 29, 2014 at 1:23 pm

    #1742015

  • RE: primary key discussion

    Lynn Pettis (8/29/2014)

    ScottPletcher (8/29/2014)

    The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly...

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

    August 29, 2014 at 1:11 pm

    #1742012

  • RE: primary key discussion

    The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly given the availability...

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

    August 29, 2014 at 11:48 am

    #1741998

  • RE: primary key discussion

    Eirikur Eiriksson (8/29/2014)

    ScottPletcher (8/29/2014)

    patrickmcginnis59 10839 (8/29/2014)

    CELKO (8/22/2014)

    What do you use for the PK on lookup tables?

    I use the encoding that is being used. The IDENTITY property (not a column!)...

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

    August 29, 2014 at 10:45 am

    #1741990

  • RE: primary key discussion

    patrickmcginnis59 10839 (8/29/2014)

    CELKO (8/22/2014)

    What do you use for the PK on lookup tables?

    I use the encoding that is being used. The IDENTITY property (not a column!) is the count...

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

    August 29, 2014 at 10:22 am

    #1741985

  • RE: Which perform better comparing only date part of datetime?

    amns (8/29/2014)

    Instead of a datetime, if I cast a string with format 'yyyy-MM-dd',

    will this cast always result in the correct date regardless the collation or other server parameters? (considering this...

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

    August 29, 2014 at 10:16 am

    #1741980

  • RE: get counts from two columns in two different tables

    j_depp_99 (8/29/2014)

    thanks much for your response. Testing it now but not sure about the variable. What does this represent? ?

    Msg 207, Level 16, State 1, Line 8

    Invalid column name...

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

    August 29, 2014 at 8:50 am

    #1741942

  • RE: get counts from two columns in two different tables

    Something like below. I don't have test data, so haven't tested it yet.

    Edit: The WHERE conditions on your original query caused the LEFT JOIN to become a de factor...

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

    August 28, 2014 at 4:57 pm

    #1741772

  • RE: Query works static, but does not dynamically

    Sorry, I have no idea; that's not my area of expertise.

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

    August 28, 2014 at 3:33 pm

    #1741755

  • RE: Query works static, but does not dynamically

    I'm guessing what is happening is that Latin1 has only ascii 0 to 255, not extended characters. So, the double-bytes are being interpreted as single bytes, one of which...

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

    August 28, 2014 at 2:44 pm

    #1741745

  • RE: name convention for archived or historical database

    I use "__Archive" (double underscore) for those tables.

    I also maintain its structure to match the original table. That is, if the main table changes, I make the same changes...

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

    August 28, 2014 at 1:49 pm

    #1741738

  • RE: Select records with different values in the same column

    I guess "UnitNumber" is the "Patient".

    SELECT UnitNumber,

    MAX(CASE WHEN DiagnosisSeqID = 1 THEN Diagnosis ELSE '' END) AS Primary_Diagnosis,

    '427.31' AS Seconday_Diagnosis_Match

    FROM test t

    GROUP...

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

    August 27, 2014 at 12:40 pm

    #1741451

Viewing 15 posts - 5,836 through 5,850 (of 7,619 total)