Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 7,619 total)

  • Reply To: Discussion on Normalization and Database Design Concepts

    I strongly object to starting with table structures.  Data normalization is a logical process, tables don't exist yet.  It's all about the data itself.  One should be referencing entities 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".

    February 8, 2021 at 5:26 pm

    #3842555

  • Reply To: Query optimization

    They have a query that runs 2400+ times a day using that column to DELETE from the table -- I stick with my recommendation, cluster the table first by that...

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

    February 8, 2021 at 5:20 pm

    #3842554

  • Reply To: SQL Instant File initialization

    Always use IFI unless you have disk data that you really can't have anyone else see via some type of hack.

    Data pages do not need to be zeroed out before...

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

    February 5, 2021 at 9:04 pm

    #3841694

  • Reply To: How to extract text after a given string to look for.

    I think it can be simplified a bit, while also allowing for another value to be found in the future (maybe 'null'?):

    SELECT
        LongString,
     ...

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

    February 5, 2021 at 9:02 pm

    #3841693

  • Reply To: Adding new column to GROUP BY vs adding MIN or MAX of that column

    Most likely that's still best.

    Btw, do you know for certain that a given product only occurs once on each order?

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

    February 5, 2021 at 4:18 pm

    #3841569

  • Reply To: DATEPART(week ...) displaying wrong week number

    Actually, in ISO week, week# is controlled by Thursday being in the week.  (Seriously, you can look it up.)

    So, since this year happens to start on a Friday, ISO week...

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

    February 5, 2021 at 4:08 pm

    #3841566

  • Reply To: Trying to create key

    I think SQL Server loosened up on that.  I believe you just need a unique index to create a FK against.

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

    February 4, 2021 at 8:06 pm

    #3841144

  • Reply To: DATEPART(week ...) displaying wrong week number

    It seems like you're doing a straightforward counting of 7 days as a week, regardless of the staring day of the week (SQL doesn't do that), then try this calc...

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

    February 4, 2021 at 7:19 pm

    #3841122

  • Reply To: Are the SQL Server "Error Logs" (residing under SQL Server Agent) backed up?

    Nope, not unless you do it yourself in some way.

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

    February 4, 2021 at 7:05 pm

    #3841118

  • Reply To: Select "New Customer"

    Hmm, yeah, I would think that would give you a lot of old customers, since there's no "recent sale date" requirement.  Maybe you need something more along these lines...?

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

    February 4, 2021 at 6:59 pm

    #3841115

  • Reply To: Counting the number of unique days between ranges of dates

    Jeff Moden wrote:

    SwePeso wrote:

    Assuming "dates" could only be a number between 1 and 31...

    DECLARE @UnitMembership TABLE
            (
        ...

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

    February 3, 2021 at 5:58 pm

    #3840625

  • Reply To: Counting the number of unique days between ranges of dates

    As Jeff Moden as pointed out, for performance reasons, it's likely to best to create a physical tally table (if you don't already have one) to use for this query:

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

    February 3, 2021 at 3:47 pm

    #3840572

  • Reply To: Counting the number of unique days between ranges of dates

    Jeff Moden wrote:

    ScottPletcher wrote:

    I would think this would be the most straightforward way, although it may not be the most efficient way.  But it might work just fine for you 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".

    February 3, 2021 at 3:09 pm

    #3840564

  • Reply To: Composite primary key tagged to identity

    Actually the use of "parent" and "child" predates databases, for example with directories.  Parent directory and child directory were very commonly used terms.

    As to tables, not every referenced table 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".

    February 2, 2021 at 10:07 pm

    #3840293

  • Reply To: Counting the number of unique days between ranges of dates

    I would think this would be the most straightforward way, although it may not be the most efficient way.  But it might work just fine for you if your 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".

    February 2, 2021 at 3:56 pm

    #3840185

    • Viewing 15 posts - 1,921 through 1,935 (of 7,619 total)