Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 7,619 total)

  • RE: How to I getr around the \ issue

    Eirikur Eiriksson (12/22/2015)

    ScottPletcher (12/22/2015)

    Eirikur Eiriksson (12/22/2015)

    My bad in the post before on the conversion, sorry about that.

    😎

    My point is that incorrect typing and implicit conversions do cause problems, I've lost...

    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 22, 2015 at 11:14 am

    #1847524

  • RE: How to I getr around the \ issue

    Lynn Pettis (12/22/2015)

    ScottPletcher (12/22/2015)

    Lynn Pettis (12/22/2015)

    ScottPletcher (12/22/2015)

    Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that is always the major...

    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 22, 2015 at 11:10 am

    #1847523

  • RE: How to I getr around the \ issue

    Lynn Pettis (12/22/2015)

    ScottPletcher (12/22/2015)

    Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that is always the major concern with implicit...

    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 22, 2015 at 10:52 am

    #1847518

  • RE: How to I getr around the \ issue

    Eirikur Eiriksson (12/22/2015)

    My bad in the post before on the conversion, sorry about that.

    😎

    My point is that incorrect typing and implicit conversions do cause problems, I've lost count of how...

    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 22, 2015 at 10:49 am

    #1847516

  • RE: Problem: DELETE table_or_view FROM table_sources removes all rows

    To insure consistency in how the DELETE is done, you should always use an alias for the affected table when using DELETE [table_name] ... FROM ....

    For example:

    DELETE a

    FROM tbl_a a

    <join_type>...

    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 22, 2015 at 10:19 am

    #1847508

  • RE: Tables Design and store proc transfer For Data

    I think the structure is good overall.

    Here are some possible adjustments to consider:

    TblClientPOC

    1) Add a description / comments column

    2) I'd get rid of the identity column here -- contrary 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".

    December 22, 2015 at 10:13 am

    #1847507

  • RE: How to I getr around the \ issue

    Of course when scanning the whole table the difference may be rather minor. It's the prevention of seeks that is always the major concern with implicit column conversions. ...

    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 22, 2015 at 10:01 am

    #1847502

  • RE: How to I getr around the \ issue

    Eirikur Eiriksson (12/22/2015)

    ScottPletcher (12/21/2015)

    But if you put the N' when the column is not unicode, you'll force SQL to implicitly convert the column itself and that could be a real...

    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 22, 2015 at 9:02 am

    #1847469

  • RE: How to reduce Huge Log File size

    Yeah, everybody always "warns" about that, but who on earth would want to apply a 299GB log anyway??

    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 21, 2015 at 6:35 pm

    #1847314

  • RE: Database Design Question

    joshdbguy (12/21/2015)

    Sean Lange (12/21/2015)

    From your description of the situation I would add a few columns to a table. As described this would be a 1:1 relationship which is really kind...

    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 21, 2015 at 6:32 pm

    #1847313

  • RE: How to I getr around the \ issue

    Eirikur Eiriksson (12/21/2015)

    Talib123 (12/21/2015)

    This query has issues due to the \.

    If I use a Where = it works fine. How do I get around this small annoying issue.

    SELECT name FROM...

    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 21, 2015 at 2:52 pm

    #1847282

  • RE: Database Design Question

    First, verify that they've done a proper design to assign the columns to this table. That is, do not assume they've done that, verify that they've done it. ...

    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 21, 2015 at 2:49 pm

    #1847278

  • RE: Know read and write ratio before you tune database performance

    You also need to keep in mind that index usage stats count the number of times an operation occurs, not the quantity of rows affected. That is, "10 scans",...

    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 21, 2015 at 1:10 pm

    #1847254

  • RE: DBA Tasks - To automate or use my own eyes

    I've got more servers than that, but I'd automate it for one server. I don't see time spent visually scanning a log file as particularly productive. Besides, what happens 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".

    December 21, 2015 at 12:25 pm

    #1847237

  • RE: Efficient way to gat all unique values and their counts for a dynamic list of fields using one query statement

    I'd create indexes on all the columns you need to count that way. Then the COUNT query can use the existing indexes to give you a very quick totals.

    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 21, 2015 at 12:23 pm

    #1847236

Viewing 15 posts - 4,546 through 4,560 (of 7,619 total)