Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 7,613 total)

  • RE: Convert the string value to multiple rows in sql server

    sgmunson - Thursday, October 5, 2017 7:05 AM

    declare @name varchar(10) = 'Server';

    SELECT TOP (LEN(@name)) SUBSTRING(@name, ROW_NUMBER() OVER(ORDER BY (SELECT NULL)), 1)
    FROM sys.all_objects;

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

    October 5, 2017 at 8:03 am

    #1962480

  • RE: select count of rows based on condition

    bartedgerton - Wednesday, October 4, 2017 1:33 PM

    I prefer to use COUNT because I think it is more readable.  I usually use...

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

    October 4, 2017 at 2:06 pm

    #1962353

  • RE: Update a #temptable IF @Table_Variable

    Never use ISNULL in a WHERE clause: not only is it unsargable [not relevant in this particular case], but it can also make the code harder to understand.  The code...

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

    October 4, 2017 at 1:54 pm

    #1962351

  • RE: Database design to handle Millions of records

    The single most important thing is to do a logical data model before doing a physical database model.

    Hints:
    1) Google "logical data modeling".  
    2) Fillfactor, indexes...

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

    October 3, 2017 at 2:42 pm

    #1962167

  • RE: select count of rows based on condition

    select 
    SUM(CASE WHEN TYPE ='D' THEN 1 ELSE 0 END) AS 'TotalXRows',
    SUM(CASE WHEN TYPE ='L' THEN 1 ELSE 0 END) AS 'TotalYRows',
    SUM(1)  AS 'TotalRows'
    from dbo.Table with (nolock)

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

    October 3, 2017 at 10:06 am

    #1962098

  • RE: Alter Table....Add Column

    GilaMonster - Friday, September 29, 2017 2:53 PM

    Arsh - Friday, September 29, 2017 8:35 AM

    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 29, 2017 at 3:05 pm

    #1961746

  • RE: ?? on Finding records with caharacters before and after in a string??

    I'm not entirely sure of your intended search rules either, but as best I can tell I think this should get you close:

    WHERE ColumnName + '.' LIKE '%[^0-9]1...

    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 29, 2017 at 9:00 am

    #1961676

  • RE: Code-first vs database-first, any new developments?

    Chris Wooding - Thursday, September 28, 2017 1:03 AM

    sgmunson - Tuesday, September 26, 2017 10:35 AM

    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 29, 2017 at 7:53 am

    #1961640

  • RE: Alter Table....Add Column

    There's a huge difference between with and without a default.

    If there's a default value, SQL has to modify metadata and add write that default value to every row...

    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 29, 2017 at 7:49 am

    #1961635

  • RE: Get the year and Qtr

    jcelko212 32090 - Thursday, September 28, 2017 12:40 PM

    ScottPletcher - Wednesday, September 27, 2017 2:20 PM

    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 28, 2017 at 1:15 pm

    #1961454

  • RE: Performance choice: computed persisted field in aa base table, vs. identical computation in a view...

    I still believe what should have been done, and what could still be done, is that the value should be in its own column.

    You can always add columns...

    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 28, 2017 at 7:09 am

    #1961336

  • RE: Get the year and Qtr

    Jeff Moden - Monday, September 25, 2017 11:42 AM

    Jason A. Long - Monday, September 25, 2017 10:42...

    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 27, 2017 at 2:20 pm

    #1961249

  • RE: Start of month last year

    WHERE dbo.LogFile.Created >= DATEADD(month, DATEDIFF(month, 0, @mydate) - 12, 0) AND
      dbo.LogFile.Created < DATEADD(day, DATEDIFF(day, 0, DATEADD(month, -12, cast(@mydate AS date))), 0)

    Edit: Corrected calc of ending date.

    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 27, 2017 at 8:21 am

    #1961152

  • RE: Retrieve multi-year data based on a table with Year and Week Number columns

    office 6161 - Tuesday, September 26, 2017 11:06 AM

    Q. How could I get all rows from above test data only between year=2017,...

    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 27, 2017 at 7:43 am

    #1961137

  • RE: Performance choice: computed persisted field in aa base table, vs. identical computation in a view...

    sgmunson - Tuesday, September 26, 2017 2:53 PM

    ScottPletcher - Tuesday, September 26, 2017 2:28 PM

    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 26, 2017 at 3:15 pm

    #1961063

Viewing 15 posts - 3,721 through 3,735 (of 7,613 total)