Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 7,619 total)

  • Reply To: Wanting to learn

    Get the best SQL administration book for whichever version of SQL you are on.  The "Inside SQL Server"/Internals books with Kalen Delaney are excellent.

    For learning T-SQL, get books by Itzik...

    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 15, 2020 at 5:46 pm

    #3788628

  • Reply To: Compression Table vs Index and how to eliminate fragmentation

    To clarify, you can compress non-clus indexes, and should often do so, but you must compress each one separately.

    Also, 80% is a very low number overall, are you sure you...

    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 15, 2020 at 5:38 pm

    #3788627

  • Reply To: How do I utilise fewer cores?

    Be sure also to make sure the "cost threshold for parallelism" is not too low.  Hint: the default is too low, if you haven't changed it,  you should.

    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 15, 2020 at 5:32 pm

    #3788620

  • Reply To: Joining a table based on date range - Case Statement?

    5. Avoid using reserved words as column names (PERIOD)

    PERIOD is not a reserved word in SQL Server. (Nor is it reserved in ODBC, also not on the list of future...

    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 14, 2020 at 9:03 pm

    #3788431

  • Reply To: Complex Join

    Sorry, I had some difficulty figuring out specifically what you meant.

    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 14, 2020 at 7:00 pm

    #3788401

  • Reply To: How to prioritize the phone nos values in three columns.

    SELECT CustID, COALESCE(CASE WHEN ValidLand = 0 THEN NULL ELSE LandPhone END,

    CASE WHEN ValidMobile = 0 THEN NULL ELSE MobilePhone END,

    CASE WHEN ValidOffice = 0 THEN NULL ELSE OfficePhone END)...

    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 12, 2020 at 2:37 am

    #3788045

  • Reply To: How to prioritize the phone nos values in three columns.

    SELECT CustID, COALESCE(LandPhone, MobilePhone, OfficePhone) AS Phone

    FROM PHONENOS

    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 11, 2020 at 3:37 am

    #3787773

  • Reply To: First Monday of the Month

    Such insanely bloated calendar tables have actually become much closer to the norm.

    It's terrible.  Create a nonwork days table with only the dates in it (you could also add 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 11, 2020 at 2:20 am

    #3787770

  • Reply To: Complex Join

    Jeff Moden wrote:

    ScottPletcher wrote:

    And, if forced to work on that SQL statement, I'd still remove the use of ISNULL, no matter what the comments stated.

    So like I asked before... what would...

    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 11, 2020 at 2:15 am

    #3787769

  • Reply To: Complex Join

    Jeff Moden wrote:

    ScottPletcher wrote:

    Jeff Moden wrote:

    While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" 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".

    September 10, 2020 at 9:37 pm

    #3787752

  • Reply To: Complex Join

    Jeff Moden wrote:

    While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is always 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 10, 2020 at 8:03 pm

    #3787718

  • Reply To: Complex Join

    Jeff Moden wrote:

    ScottPletcher wrote:

    Jeff Moden wrote:

    Sergiy wrote:

    Still there is a shorter version:

    select * 
    from leftTable  T1
    join rightTable T2 
       on (
         ...

    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 10, 2020 at 4:17 pm

    #3787608

  • Reply To: Formatting dates returned in query

    SELECT CONVERT(varchar(10), I.InvoiceDate, 110) AS InvoiceDate

    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 9, 2020 at 8:03 pm

    #3787410

  • Reply To: Complex Join

    Jeff Moden wrote:

    Sergiy wrote:

    Still there is a shorter version:

    select * 
    from leftTable  T1
    join rightTable T2 
       on (
          T1.C1 =...

    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 9, 2020 at 7:42 pm

    #3787407

  • Reply To: Complex Join

    You never want to use ISNULL() in a WHERE or JOIN clause.  The code may be slightly longer the other way, but it could potentially run much faster.

    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 9, 2020 at 7:25 pm

    #3787403

Viewing 15 posts - 2,296 through 2,310 (of 7,619 total)