Forum Replies Created

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

  • RE: Option recompile and temp tables in a proc.

    just a good article. No question.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    August 10, 2016 at 8:59 am

    #1894817

  • RE: Find value is prim or not

    drew.allen (6/24/2016)

    I think that Luis' solution will perform faster than any looping solution, especially once the square root short circuit is added.

    Drew

    surely the cte is faster, but they do different...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 24, 2016 at 4:20 pm

    #1886862

  • RE: Find value is prim or not

    Here is something I did some time ago.

    Little bit loopdy loop, but returns primenumber list from first million integers in about 12 seconds on my server due to optimised incrementing...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 24, 2016 at 9:20 am

    #1886775

  • RE: Extended Event vs Profiler Trace

    GilaMonster (6/22/2016)

    MadAdmin (6/22/2016)

    Cos the plan cache is there, juicy enough to eat, with all the info you need in one crispy query.

    His event is for actual execution plans (plans with...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 22, 2016 at 9:38 am

    #1886320

  • RE: Extended Event vs Profiler Trace

    simon.letts (6/22/2016)

    Hi,

    I want to get the Exec Plans for anything that uses my TBS_SEG_WORK_CON_ORDERS_DATA table.

    Is this a problem that you want to solve with Extended events and only...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 22, 2016 at 9:23 am

    #1886312

  • RE: Your thoughts on dropping redundant indexes...

    Find the queries that are using each index to do a search or scan.

    THEN

    Look at the code and see if the entire index is being used.

    Do this for all queries...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 22, 2016 at 7:04 am

    #1886228

  • RE: Query calculation over a partition

    This returns 3 rows from the base table when doing the except both directions.

    ;WITH CUSTOMERS_SALE AS

    (

    SELECT

    SSF.CUST_ID

    ...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 16, 2016 at 9:00 am

    #1885435

  • RE: Error converting varchar to type float

    Just wondering.

    Why so many [float]?

    Design choice?

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 16, 2016 at 7:08 am

    #1885384

  • RE: How to upgrade to 2016 AlwaysON from SQL Server 2012???

    What is version of primary, and what is version of secondary?

    You will have an error if the primary is 2016 and secondary is 2012.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 16, 2016 at 6:31 am

    #1885372

  • RE: Can't upgeane SQL Server 2014 Developer to SQL Server 2016 Developer

    I would check the setup logs.

    I had an issue but that was with SSRS and had to look throught the logs to find that out.

    Might be here somewhere

    C:\Program Files\Microsoft SQL...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 10, 2016 at 9:45 am

    #1884432

  • RE: faster index rebuild from prod server verse local computer.

    Snargables (6/8/2016)

    What about querries? Should the same logic apply? It's been my experience that queries take longer to execute from my laptop as opposed to me remoting in and running...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 10, 2016 at 2:47 am

    #1884307

  • RE: Query to find tables with Forwarded Records

    I got same error and then after fixing got the error of converting from int into tinyint.

    Here is a less iterative way that does not include global temp tables and...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 9, 2016 at 7:46 am

    #1884102

  • RE: Brute Force data search tool

    Hi

    I have made it work with varchar and nvarchar max, and also XML.

    Also, I have compacted the nested if statements so that we have one insert.

    Also, I have added a...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 3, 2016 at 6:34 am

    #1883060

  • RE: Adventureworks database for SQL Server 2016

    Gareth Swan (6/2/2016)

    Here you go, guys - The NEW database for use with SQL Server 2016. AdventureWorks is dead. Long live Wide World Importers !!! https://github.com/Microsoft/sql-server-samples/blob/master/samples/databases/wide-world-importers/documentation/root.md It even...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    June 2, 2016 at 10:11 am

    #1882870

  • RE: Simple Query Running long in PROD

    Check to see if the tables have the same columns and indexes in prod and dev.

    If it is sorting on Prod but not on Dev, then I assume that the...

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

    May 9, 2016 at 5:40 am

    #1877437

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