Forum Replies Created

Viewing 15 posts - 331 through 345 (of 5,841 total)

  • RE: MAX date from previous month

    Break your query down to find issues like this. Start with the table that you filter on. Make sure it gives expected results. Join in one table to it, make...

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

    March 20, 2017 at 12:26 pm

    #1934069

  • RE: Issue with deleting millions of rows of data

    Note that it is pretty silly to REBUILD indexes and then update statistics on them! With REBUILD you get 100%-scan stats, the best you can have. With update stats unless...

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

    March 20, 2017 at 11:23 am

    #1934054

  • RE: Update Query Performance

    Eddie Wuerch - Monday, March 20, 2017 1:03 AM

    sqlrob - Sunday, March 19, 2017 10:37 PM

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

    March 20, 2017 at 9:40 am

    #1934026

  • RE: Update Query Performance

    Sergiy - Monday, March 20, 2017 4:23 AM

    I don't think that TOP 1 does what you think it does.

    It does exactly...

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

    March 20, 2017 at 9:37 am

    #1934024

  • RE: Update Query Performance

    Sergiy - Sunday, March 19, 2017 6:04 AM

    sqlrob - Sunday, March 19, 2017 5:33 AM

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

    March 19, 2017 at 11:15 am

    #1933897

  • RE: Memory-optimized tables and table-types

    N_Muller - Friday, March 17, 2017 3:55 PM

    I have a very large stored procedure on my OLTP that runs multiple times concurrently...

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

    March 17, 2017 at 8:24 pm

    #1933854

  • RE: Issue with deleting millions of rows of data

    If you need to keep a relatively few of the billion+ rows in the combined tables I like the idea of quiescing the database, copying off what you need in...

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

    March 17, 2017 at 11:19 am

    #1933808

  • RE: Convert Cross Join to Inner Join

    RonMexico - Thursday, March 16, 2017 11:27 AM

    I took care of the duplicates in one table but now I'm having trouble joining...

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

    March 16, 2017 at 1:22 pm

    #1933608

  • RE: Update Query Performance

    Use sp_whoisactive to see what is happening in real time. Review the 30-day blog post series that Adam Machanic has on SQLBlog.com about how to use it. For example, if...

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

    March 16, 2017 at 8:30 am

    #1933493

  • RE: HELP! Why did a restart improve performance?

    Brandie Tarvin - Thursday, March 16, 2017 4:35 AM

    Can I just mention that having a Test database on the same server as...

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

    March 16, 2017 at 8:26 am

    #1933490

  • RE: HELP! Why did a restart improve performance?

    Since you didn't do anything other than reboot (such as add an index, update statistics, etc) then it is almost certainly a parameter sniffing issue. Adding to this likely hood...

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

    March 14, 2017 at 11:56 am

    #1933110

  • RE: Cleaning up SKU's in my master POS DB, need to move SKU's with check digit to temp table

    chef423 - Thursday, March 9, 2017 9:03 PM

    Ok, so I have read over n over you cannot delete related data from 2...

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

    March 10, 2017 at 3:33 pm

    #1932805

  • RE: Cleaning up SKU's in my master POS DB, need to move SKU's with check digit to temp table

    Thank you, but I am still unsure how to move the SKU's with an 11 digit length to a temp table.

    Did you set up a quick demo...

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

    March 9, 2017 at 12:16 pm

    #1932583

  • RE: checkdb "Multiple IAM pages for object"

    sgt500 - Thursday, March 9, 2017 7:51 AM

    a weird thing, on test server checdb runs in 1.15 h  against 15h on the...

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

    March 9, 2017 at 12:15 pm

    #1932582

  • RE: Cleaning up SKU's in my master POS DB, need to move SKU's with check digit to temp table

    chef423 - Wednesday, March 8, 2017 3:26 PM

    So when I run this simple query:
    select * from Inventory
    where Dept_ID = '1123'

    Department...

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

    March 8, 2017 at 4:45 pm

    #1932432

Viewing 15 posts - 331 through 345 (of 5,841 total)