Forum Replies Created

Viewing 15 posts - 61 through 75 (of 78 total)

  • RE: MAXDOP

    Nakul Vachhrajani (11/19/2010)

    What edition of SQL Server are you using? Straight out of Books On Line - "Parallel index operations are available only in SQL Server Enterprise, Developer, and Evaluation...

    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 -

    November 19, 2010 at 5:26 am

    #1252964

  • RE: Add Styles to Your Reporting Services Reports

    Good article... waiting for the rest 🙂

    Brian

    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 -

    October 8, 2010 at 12:59 am

    #1234037

  • RE: Request to provide credentials on opening Report Manager

    Raunak Jhawar (9/28/2010)

    brian118 (9/28/2010)

    Raunak Jhawar (9/28/2010)

    Are trying to access the local or remote instance of SSRS?

    The login prompt is displayed when accessing SSRS both locally and remotely.

    Thanks

    Brian,

    I am leaving for...

    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 -

    September 29, 2010 at 1:29 am

    #1228789

  • RE: Request to provide credentials on opening Report Manager

    Raunak Jhawar (9/28/2010)

    Are trying to access the local or remote instance of SSRS?

    The login prompt is displayed when accessing SSRS both locally and remotely.

    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 -

    September 28, 2010 at 8:06 am

    #1228379

  • RE: Ways to minimize sort operations

    Nils Gustav Stråbø (9/15/2010)

    Brian, I'm have to apologize to you because for some reason my eyes and brain didn't see that you kept the ORDER BY clause. For some reason...

    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 -

    September 15, 2010 at 7:36 am

    #1221319

  • RE: Ways to minimize sort operations

    Jason Lees-299789 (9/15/2010)

    Like Nils, I dont quite understand the reason for the article, in 95% of cases the sort operation is the least of your worries in a plan, especially...

    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 -

    September 15, 2010 at 7:30 am

    #1221317

  • RE: Ways to minimize sort operations

    Nils Gustav Stråbø (9/15/2010)

    I'm a little confused here. What is the intention of the article? To avoid unnecessary Sort operators in the execution plan or to eliminate ORDER BY and...

    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 -

    September 15, 2010 at 7:22 am

    #1221313

  • RE: Tips to optimize your SQL statements

    cameron.wells (7/29/2010)

    Thanks for the great check list, but i also want to take some of your other advice that this doesn't substitute reading books and white papers on SQL Performance....

    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 30, 2010 at 12:33 am

    #1200142

  • RE: Tips to optimize your SQL statements

    Thanks to all for your feedback!

    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 30, 2010 at 12:26 am

    #1200141

  • RE: Executing Stored Procedures (DML statements) from SSRS

    Thanks to both!

    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 27, 2010 at 9:06 am

    #1198766

  • RE: Sub query expressions vs. Joins.

    gary.strange-1058508 (7/22/2010)

    Some of the comments posted seem to be following the lines of "what if this, what if that, this isn't quite right".

    I would agree that the article may leave...

    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 23, 2010 at 1:06 am

    #1197361

  • RE: Sub query expressions vs. Joins.

    glen.Gorman (7/22/2010)

    I was thinking something is missing from this article, and whats missing is the reasoning why joins are generally better than sub queries. The reasoning give you more...

    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 23, 2010 at 12:43 am

    #1197355

  • RE: Sub query expressions vs. Joins.

    Johannes Krackowizer (7/22/2010)

    There is a big flaw in the article, you take two different statements with the same result but only by accident. The subselect ist quite the same as...

    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 23, 2010 at 12:33 am

    #1197354

  • RE: Sub query expressions vs. Joins.

    jainraj_2000 (7/22/2010)

    The Script is not working in SQL SERVER 2005 the populate tables procedure is having an insert into managers with multiple values.

    In order to run it correctly it...

    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 23, 2010 at 12:29 am

    #1197351

  • RE: Sub query expressions vs. Joins.

    paul-876346 (7/22/2010)

    Thank you - I also wonder how the sub-query or join would compare to Cross (or Outer) Apply - as in the following query?

    Thanks for your feedback! Next time...

    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 23, 2010 at 12:28 am

    #1197350

Viewing 15 posts - 61 through 75 (of 78 total)