Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 22,219 total)

  • RE: Need to improve Performance issue

    saptek9 - Tuesday, March 27, 2018 9:51 AM

    Thank you. What about creating view instead table variables?

    A view is nothing but a...

    "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

    March 28, 2018 at 4:27 am

    #1984750

  • RE: Storing and Retrieving historical data

    There are all sorts of mechanisms around something like this. Using the baseball example, I'd look to the database design to deal with this. You have a team. You have...

    "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

    March 27, 2018 at 6:23 am

    #1984638

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, March 14, 2018 7:30 AM

    Heh... good grief.  Check this out, folks...
    http://bgr.com/2018/03/12/slingshot-malware-routers-infected-pcs/

    The follow up article containing the nitty-gritty...

    "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

    March 14, 2018 at 9:02 am

    #1983181

  • RE: Query performance issue due to Index Spool - Lazy Spool

    To fully answer what issues may be going on, getting the full plan is going to be the best bet.

    To give you some general information, an index spool...

    "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

    March 2, 2018 at 9:42 am

    #1981783

  • RE: Tracking changes on Views.

    ben.brugman - Monday, February 26, 2018 7:45 AM

    Grant Fritchey - Monday, February 26, 2018 7:33 AM

    "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

    February 26, 2018 at 8:34 am

    #1981104

  • RE: Tracking changes on Views.

    Best way to do this is to put your database code into source control. You can track it and version it that way. Further, once you start treating your database...

    "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

    February 26, 2018 at 7:33 am

    #1981088

  • RE: Can we execute sp_updatestats in heavy transaction time

    SQL ADMIN 79 - Saturday, February 24, 2018 6:54 AM

    Gianluca Sartori / Grant Fritchey,
    There is a daily sp_update stats (on db which...

    "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

    February 26, 2018 at 2:48 am

    #1981064

  • RE: Restore database from 2014 to 2008.

    Ivan R. - Friday, February 23, 2018 12:10 AM

    omgomgomg Grant F. replied to me. you won't realize how much you are...

    "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

    February 25, 2018 at 1:39 am

    #1981046

  • RE: Building Culture

    maroon-78 - Tuesday, February 20, 2018 11:53 AM

    It's Scary how your culture affects your day-to-day interactions with your co-workers.

    Ba dum bum.

    "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

    February 20, 2018 at 12:32 pm

    #1980522

  • RE: Building Culture

    xsevensinzx - Monday, February 19, 2018 8:59 PM

    On my team, I am certainly trying to build a culture centered around being open,...

    "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

    February 20, 2018 at 6:25 am

    #1980439

  • RE: Triggers or best option

    If you have to write out the audits in this fashion, triggers are the way to go. However, be very cautious using triggers. They can be extremely expensive operations since...

    "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

    February 20, 2018 at 6:22 am

    #1980435

    • Viewing 15 posts - 3,286 through 3,300 (of 22,219 total)