Forum Replies Created

Viewing 15 posts - 1 through 15 (of 78 total)

  • Reply To: SSMS Standard Reports

    Thanks

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    April 30, 2019 at 3:16 pm

    #3562044

  • RE: Report Builder 1.0

    Thanks to all for your responses. I wanted to work with V1.0 to make use of the data models. The data models can hide joins and I can add computed...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 18, 2016 at 12:48 am

    #1879746

  • RE: Column Store vs Row Store Indexes

    lahteenj (5/15/2015)

    Hi,

    I can't find the scripts that you mentioned in the article?

    Regards

    Jari

    I uploaded them again! Once the moderator will refresh the article, they should be there. Sorry for this

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 15, 2015 at 3:28 am

    #1798123

  • RE: Column Store vs Row Store Indexes

    Thanks to all for your comments.

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 15, 2015 at 1:34 am

    #1798098

  • RE: Column Store vs Row Store Indexes

    Phil Parkin (5/14/2015)

    An interesting read, thank you very much. Hope you don't mind me mentioning a few minor typos:

    'FacTransaction_ColumnStore' – needs an extra 't'

    'Compression ration' – ratio

    'foorprint' – footprint

    'datawarhouse' –...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 14, 2015 at 3:05 am

    #1797765

  • RE: Tips to Optimize Your SQL Statements - Part 2

    Jeff Moden (5/8/2015)

    I have to remind everyone that changing a database to the SIMPLE Recovery Model is one of the very worst things you can do if Point-In-Time Backups are...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 9, 2015 at 11:37 am

    #1796814

  • RE: Tips to Optimize Your SQL Statements - Part 2

    george.p (5/8/2015)

    Why would setting the recovery mode to simple make bulk inserts faster?

    See if this helps - https://technet.microsoft.com/en-us/library/ms190421(v=sql.105).aspx

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 8, 2015 at 4:44 am

    #1796503

  • RE: Tips to Optimize Your SQL Statements - Part 2

    Iwas Bornready (5/7/2015)

    Some of it made sense but some I'm going to have to do some research on. Thanks for the opportunity to learn something today.

    Thanks for your comment. If...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 7, 2015 at 1:43 pm

    #1796391

  • RE: Tips to Optimize Your SQL Statements - Part 2

    rchantler (5/7/2015)

    "You can change the Optimize for Ad hoc Workloads to True.This setting will not have a direct performance impact on SELECTS, however it will improve the efficiency of the...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 7, 2015 at 1:41 pm

    #1796390

  • RE: Tips to Optimize Your SQL Statements - Part 2

    Thanks for the links. I should have included them in the article.

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    May 7, 2015 at 1:39 pm

    #1796389

  • RE: Local Variables and BETWEEN clause

    GilaMonster (8/4/2014)

    There's nothing about local variables which prevent index usage.

    That 30% is the worst possible case for a guess by the optimiser, not the norm. If it can manage a...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    August 4, 2014 at 6:51 am

    #1734827

  • RE: SSIS Analysis Services Processing Task.

    Nevyn (7/25/2014)

    Right, but does it still do that when you pass in the credentials instead of using integrated security?

    Hi

    In the Connection manager of SSIS, I have the option to Use...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    July 29, 2014 at 1:54 am

    #1733107

  • RE: SSIS Analysis Services Processing Task.

    Nevyn (7/24/2014)

    Hmm, a bit different than the situation I encountered then.

    Does it work if you specify username (including domain) and password in the connection?

    Yes I can connect successfully when I...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    July 24, 2014 at 9:57 pm

    #1732241

  • RE: SSIS Analysis Services Processing Task.

    Nevyn (7/24/2014)

    I am guessing that you are using Windows Authentication? Are you logged into the production server you are trying to run the package from, or are you connecting...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    July 24, 2014 at 8:25 am

    #1732106

  • RE: SSIS Analysis Services Processing Task.

    Nevyn (7/24/2014)

    I am guessing that you are using Windows Authentication?

    Yes I am. Do please note that the 'Test Connection' of the Connection Manager is successful. The only difference from my...

    Regards
    Brian Ellul
    ----------------------------------------------------------------------------------
    Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
    - Albert Einstein -

    July 24, 2014 at 7:59 am

    #1732100

Viewing 15 posts - 1 through 15 (of 78 total)