Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 2,458 total)

  • RE: Compress table timelines

    I cleaned up your sample data and came up with a not so optimal solution . This can be greatly improved by removing the need for the DISTINCT clause. Using...

    "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

    July 8, 2014 at 3:55 pm

    #1727909

  • RE: SSAS Overview

    To add Nevyn...

    SSAS is one of the three core products that are considered part of what is commonly referred to as the "Microsoft BI Stack". You mentioned SSIS and SSRS;...

    "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

    July 8, 2014 at 2:55 pm

    #1727895

  • RE: This Query is Filling up TEMPDB

    JeepHound (7/8/2014)

    I am very new to SQL server Querying. I see the following Query causing my tempdb's to fill up dramatically in our production environment. Can someone please...

    "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

    July 8, 2014 at 10:59 am

    #1727829

  • RE: Need to add Balance of previous Row to Current Row

    Jeff Moden (7/2/2014)

    Alan.B (7/2/2014)

    Sean Lange (7/2/2014)

    If you use the quirky update please make sure you read the article carefully. There are a number of extremely important requirements that must be...

    "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

    July 3, 2014 at 8:15 am

    #1726838

  • RE: Need to add Balance of previous Row to Current Row

    Sean Lange (7/2/2014)

    If you use the quirky update please make sure you read the article carefully. There are a number of extremely important requirements that must be met for this...

    "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

    July 2, 2014 at 1:54 pm

    #1726629

  • RE: Need to add Balance of previous Row to Current Row

    I think you are looking for this:

    -- (1) create sample data

    DECLARE @values TABLE

    (FISCALYEAR int not null,

    ACCTPERIOD int not null,

    TrialBalanceDebit decimal(16,5) not null,

    POSTINGTYPE varchar(20) not null

    );

    INSERT @values VALUES

    (2014, 201401,...

    "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

    July 2, 2014 at 12:53 pm

    #1726618

  • RE: Who TOOK the backup?

    New Born DBA (7/1/2014)

    Alan.B (7/1/2014)

    You can get this information from msdb.dbo.backupset

    SELECT name,

    description,

    user_name,

    database_creation_date,

    backup_start_date,

    backup_finish_date,

    backup_size,

    database_name,

    server_name,

    machine_name

    FROM msdb.dbo.backupset

    Thanks. It gave me all the details.

    I also right clicked on the backup set -->properties and then...

    "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

    July 1, 2014 at 11:10 am

    #1726293

  • RE: Who TOOK the backup?

    You can get this information from msdb.dbo.backupset

    SELECT name,

    description,

    user_name,

    database_creation_date,

    backup_start_date,

    backup_finish_date,

    backup_size,

    database_name,

    server_name,

    machine_name

    FROM msdb.dbo.backupset

    "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

    July 1, 2014 at 10:14 am

    #1726258

  • RE: Never Stop Learning

    Most people watch a lot more television than six hours per week. What do I do with that time instead? I read books and blogs. I "tinker" with SSIS 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

    June 26, 2014 at 2:13 pm

    #1725270

  • RE: do you have a StripNonNumeric ITVF function?

    That makes sense. No point evaluating all the 10,000 rows when they won't meet the condition anyway. I suspect if we changed my original (with the STUFF) it would perform...

    "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

    June 25, 2014 at 2:17 pm

    #1724821

  • RE: do you have a StripNonNumeric ITVF function?

    Sean Lange (6/25/2014)

    Alan.B (6/25/2014)

    Gents

    First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do a...

    "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

    June 25, 2014 at 1:45 pm

    #1724790

  • RE: do you have a StripNonNumeric ITVF function?

    Gents

    First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do a performance test 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

    June 25, 2014 at 11:23 am

    #1724735

  • RE: returning only portion of string

    Eugene Elutin (6/20/2014)

    Alan.B (6/19/2014)

    Eugene Elutin (6/19/2014)

    SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)

    Yep,...

    "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

    June 20, 2014 at 9:12 am

    #1723629

  • RE: returning only portion of string

    Eugene Elutin (6/19/2014)

    SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)

    Yep, as long 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

    June 19, 2014 at 12:14 pm

    #1723392

  • RE: returning only portion of string

    Eugene Elutin (6/19/2014)

    May I ask please, if there is any reason to use SUBSTRING instead of PARSENAME other than love of typing and having more of pink in the code,...

    "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

    June 19, 2014 at 10:12 am

    #1723340

Viewing 15 posts - 1,921 through 1,935 (of 2,458 total)