Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 22,227 total)

  • RE: Very strange execution plan estimated rows was really large

    DBA328 - Tuesday, December 11, 2018 2:23 AM

    Just curios about following execution plan, one nested loop with two input (one estimated rows:3381...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 12, 2018 at 1:50 am

    #2016070

  • RE: Looking to downgrade our SQL Server editions from Enterprise to Standard Edition

    That's a lot of down time. Doing a side-by-side install  would allow you to set up mirroring to migrate between the servers minimizing downtime. Further, that method means that you...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 11, 2018 at 1:57 am

    #2015969

  • RE: blocking for same query on user DB

    sqlguy80 - Wednesday, December 5, 2018 7:42 PM

    Hi Grant ,
    Changing Cost threshold of parallelism from default 5 to 50, fixed this...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 6, 2018 at 4:41 am

    #2015643

  • RE: Clustered Index Scan vs Seek

    Sridhar-137443 - Tuesday, December 4, 2018 9:22 PM

    Hi Grant,It is a simple query. Let’s say I have table A with columns Id,...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 5, 2018 at 11:49 am

    #2015593

  • RE: Clustered Index Scan vs Seek

    Not seeing the query or the structure, my answer is going to be vague.

    In general, yes. Situationally, a seek is better than a scan. However, it really depends...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 4, 2018 at 4:08 am

    #2015421

  • RE: Is it possible to restore database with smaller size than source?

    There isn't a way to do this with backup and restore. The entire idea of the backup is that it is a full copy in every possible regard of the...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 4, 2018 at 4:06 am

    #2015420

  • RE: Lack of clustered index generally a good idea?

    If something is difficult, the best possible solution to that difficulty is to just not do it... said no one who accomplished things.

    Yes, choosing the right clustering keys...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

    December 4, 2018 at 3:56 am

    #2015418

    • Viewing 15 posts - 2,836 through 2,850 (of 22,227 total)