Forum Replies Created

Viewing 15 posts - 391 through 405 (of 2,462 total)

  • RE: Performance issues when BLOB-shredding....

    mickegohle (11/1/2016)

    Hi all,

    I have tried to get an insert query to execute faster.

    I have a table with an xml-column in it. This xml is quite big and there are...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    November 1, 2016 at 9:28 am

    #1909907

  • RE: SQL Server equivalent for MySQL's Substring_index

    Here's kind of a hybrid of both of Luis' solutions:

    let's say you have a maximum number of delimiters, for my example we'll say a max of 6 (but you...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 31, 2016 at 2:28 pm

    #1909748

  • RE: Talking baseball

    djj (10/24/2016)

    Alan.B (10/22/2016)

    Alan.B (10/14/2016)

    Ray K (10/14/2016)

    Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 31, 2016 at 8:28 am

    #1909645

  • RE: Talking baseball

    Alan.B (10/14/2016)

    Ray K (10/14/2016)

    Tried to stay up last night to watch Dodgers vs. Nationals Game 5. I made it to the 8th inning before I finally gave up and...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 22, 2016 at 8:56 pm

    #1908197

  • RE: ColumnStore Index

    mishka-723908 (10/21/2016)

    Thank you for your response

    We are not sure yet whether to create it as clustered or not. This is something we will need to test with.

    The deletes will...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 22, 2016 at 10:35 am

    #1908173

  • RE: ColumnStore Index

    mishka-723908 (10/21/2016)

    We have a DataWarehouse with Large Fact Tables . The Some of the tables have about 30 to 60 Columns and we also have some denormalized tables that are...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 9:32 pm

    #1908146

  • RE: How to get Matrix format query in T-SQL

    DECLARE @yourTable TABLE(Name varchar(100), Salary money, dt date);

    INSERT @yourTable VALUES

    ('SAM-1',$67,'20161021'),

    ('SAM-2',$34,'20161021'),

    ('SAM-1',$39,'20161020'),

    ('SAM-2',$45,'20161020');

    SELECT

    Name,

    [21-10-2016] = SUM(CASE dt WHEN '20161021' THEN Salary END),

    [20-10-2016] = SUM(CASE dt WHEN...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 9:01 pm

    #1908144

  • RE: Deleted

    chocthree (10/21/2016)

    When the term 'Power BI' is mentioned I think of a visualisation tool. A tool that can hook into various sources (flat files, websites, etc..) and then produce colourful...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 3:44 pm

    #1908128

  • RE: Deleted

    Eric M Russell (10/21/2016)

    Ed Wagner (10/21/2016)

    Phil Parkin (10/21/2016)

    chocthree (10/21/2016)

    All, I thank you for each of your responses. Much appreciated.

    Ok, here is the deal. I'm a little long in the tooth...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 1:31 pm

    #1908097

  • RE: New 'accidental' DBA-Need some guidance

    let me emphasize the recovery. You should practice restoring from a backup to a non-production database. This makes sure your backups are viable so you can restore a database...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 1:22 pm

    #1908091

  • RE: Deleted

    I have never heard that SQL is dying. You are the first I have heard say that. While there is RDBMS I would imagine SQL being around. I can't see...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 1:14 pm

    #1908085

  • RE: Indexed View used without being referenced

    I learned about this not too long ago and think it's a good thing. Grant Fritchey touches on this in his excellent book, SQL Server Execution Plans (page 162):

    Since the...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 21, 2016 at 10:31 am

    #1908020

  • RE: Windows Server 2016

    I have not ran SQL 2016 on Windows Server 2016 but Microsoft is pretty good about warning you during the install if the version is supported on the OS. I...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 20, 2016 at 2:24 pm

    #1907788

  • RE: MDX to Convert Revenue To Positive

    I'm thinking you could use ABS or IIF (ABS being the easiest and most efficient)

    ABS:ABS(([Measures].[FMSA Monthly Activity].CurrentMember))

    IIF:IIF

    (

    [Measures].[FMSA Monthly Activity].CurrentMember >= 0,

    [Measures].[FMSA Monthly Activity].CurrentMember,

    [Measures].[FMSA Monthly...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 20, 2016 at 1:45 pm

    #1907774

  • RE: Ideas to accomplish desired results in my query

    camiloecheverry11 (10/20/2016)

    I need a query where I can get the results from column qty hand, qty allocated and qty backordered.

    Without any DDL, sample data or anything about your data...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    October 20, 2016 at 1:24 pm

    #1907760

Viewing 15 posts - 391 through 405 (of 2,462 total)