Forum Replies Created

Viewing 15 posts - 691 through 705 (of 5,841 total)

  • RE: trigger for table

    sqlfriends (10/21/2016)

    Thank you, the insert will be only used for our data conversion and migration from old application database to new application database, it will be removed later after data...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 21, 2016 at 2:32 pm

    #1908114

  • RE: trigger for table

    sqlfriends (10/21/2016)

    By looking at the code again, I see it really just updated the inserted.row, not for all, so it is not too bad.

    Each time we talked about ...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 21, 2016 at 12:46 pm

    #1908076

  • RE: trigger for table

    I agree with Gail - see if it hurts before bothering with it.

    If it DOES hurt, then I agree with Phil - this is a VERY silly thing for a...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 21, 2016 at 11:08 am

    #1908035

  • RE: SQL query running slow after upgrading from 2005 to SQL 2012

    Sqlsavy (10/20/2016)

    Thank you everyone.

    I can't post the actual query plan because of company policy.

    You've been very helpful we've logged a case with MS now

    I can't see this being Microsoft's fault...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 20, 2016 at 8:36 am

    #1907679

  • RE: Differential backup too big

    Robert vd Berg (10/19/2016)

    I found the cause, so I thought I'd let you know. Between the small diffs and the larger diffs was a failed full backup (due to the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 19, 2016 at 8:41 am

    #1907437

  • RE: DBCC CHECKDB Taking a Huge Time due to DBCC SSB CHECK Command.

    satnam.singh 44358 (10/19/2016)

    Hi Everybody,

    We have a Database whose size is around 76 GB. DBCC CHECKDB is taking around 15 hours to complete and the step at which it takes a...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 19, 2016 at 8:39 am

    #1907435

  • RE: SQL query running slow after upgrading from 2005 to SQL 2012

    I would like to see the query too.

    My guess without further information is a huge rowcount somewhere is needing a huge memory grant for a sort, hash, etc and with...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 19, 2016 at 8:37 am

    #1907434

  • RE: Query Performance - MIN vs Top 1

    mitzyturbo (10/18/2016)

    Hi guys

    Similar to a previous thread I started last week about query performance I need to figure out why 2 queries, designed to do the same thing, are both...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 18, 2016 at 8:40 am

    #1907160

  • RE: Differential backup too big

    Robert vd Berg (10/17/2016)

    Hello Kevin,

    "No" to all three.

    Greetings,

    Robert

    Next guess is perhaps the algorithm Paul posted in 2008 is off for 2014 databases for some reason. I do note he specifically...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 17, 2016 at 2:58 pm

    #1907006

  • RE: Differential backup too big

    Thinking outside the box:

    1) Got filestream by any chance?

    2) In-Memory OLTP?

    3) Columnstore indexes?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 17, 2016 at 11:37 am

    #1906947

  • RE: Differential backup too big

    1) What is the exact script you used to identify changed extents?

    2) What changed between the period where DIFFs were always small and the recent issues?

    3) What activity was done...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 17, 2016 at 9:51 am

    #1906924

  • RE: CONFLICTING PARAMETER SNIFFING ISSUES AND WORK AROUNDS?

    JALLY (10/14/2016)

    I will try to explain as much as i can.

    I have a dynamic SQL in the form of A SP.

    I used Option recompile and option for local variables to...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 14, 2016 at 5:00 pm

    #1906724

  • RE: Performance issue when testing the value of ROW_NUMBER in a WHERE clause

    cmartel 20772 (10/11/2016)

    The plans are quite similar.

    The more I am analyzing this, the more it appears to be a SQL Manager Studio issue. I just discovered that if, within Manager...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 11, 2016 at 3:32 pm

    #1906002

  • RE: Performance issue when testing the value of ROW_NUMBER in a WHERE clause

    Grant Fritchey (10/11/2016)

    Check the execution plans for each query to see how they're being resolved.

    Be sure to compare estimated and actual row counts in both plans.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 11, 2016 at 2:43 pm

    #1905991

  • RE: Which of the 2 queries is better in terms of performance

    Do they give the same query plan?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 7, 2016 at 1:41 pm

    #1905453

Viewing 15 posts - 691 through 705 (of 5,841 total)