Forum Replies Created

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

  • RE: SSAS Overview

    stephen.salowitz (7/9/2014)

    Do you know of any great (online preferably) resources that I can use to learn more about SSAS?

    Two key books:

    I don't know what version you are considering but...

    "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 9, 2014 at 3:27 pm

    #1728224

  • RE: SSAS Overview

    stephen.salowitz (7/9/2014)

    Thanks for the info, it was what I was looking for.

    No prob. Glad to help!

    "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 9, 2014 at 2:02 pm

    #1728210

  • RE: Compress table timelines

    Eirikur Eiriksson (7/8/2014)

    No need to complicate things, the only thing needed here is correct window specification for the row_number function.

    😎 ...This brings the cost of execution for this 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

    July 9, 2014 at 9:33 am

    #1728123

  • RE: Not sure how to write this query without cursors and/or dynamic sql

    Are we supposed to do your work? Or do you have something done already?

    +1

    Hey, thanks for the smart-*** remark. I'm looking for alternatives to using a cursor here. If...

    "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 6:22 pm

    #1727924

  • 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

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