Forum Replies Created

Viewing 15 posts - 196 through 210 (of 5,841 total)

  • RE: Slow DataBase and Hyper-V

    augustos - Thursday, July 27, 2017 8:35 PM

    Hi,

    In the company I work for, we have a slowness problem in the SQL Server...

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

    July 28, 2017 at 8:17 am

    #1953203

  • RE: Queries taking longer than usual time for a subset of inputs when reaching the end

    er.mayankshukla - Friday, July 28, 2017 2:33 AM

    Hi Gail,
    Posting the code might not be possible.
    However, when I am running the same code...

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

    July 28, 2017 at 8:09 am

    #1953201

  • RE: Synonyms causing performance issue - database on same server

    cpeck - Wednesday, July 26, 2017 2:41 PM

    I have synonyms created that point to a database on the same server.  I have been...

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

    July 26, 2017 at 5:55 pm

    #1952936

  • RE: Difference between (where ID = 543 vs Where ID = '543')

    Consider yourself lucky. I tried to encourage a developer while I was deployed to use proper data types, indexing, etc. All he would say is that the app he...

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

    July 26, 2017 at 1:44 pm

    #1952899

  • RE: Difference between (where ID = 543 vs Where ID = '543')

    Lynn Pettis - Tuesday, July 25, 2017 12:53 PM

    TheSQLGuru - Tuesday, July 25, 2017 12:46 PM

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

    July 25, 2017 at 1:03 pm

    #1952662

  • RE: Lookin for Reference for EDI Using SSIS and X12 Format Files

    samp.silvercreek - Tuesday, July 25, 2017 10:42 AM

    I'm tasked with creating SSIS packages that import and export data to an ERP system...

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

    July 25, 2017 at 12:57 pm

    #1952655

  • RE: Row_number() in case statement returning unexpected results

    klopeks - Tuesday, July 25, 2017 9:19 AM

    I've got a long query that contains this

    row_number() over (partition by a.accountnumber, a.closedChatDate order by...

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

    July 25, 2017 at 12:48 pm

    #1952649

  • RE: Difference between (where ID = 543 vs Where ID = '543')

    I have 45000 hours of experience with SQL Server, ALL of it with at least some focus (most with extreme focus) on performance tuning. I tell you this so you...

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

    July 25, 2017 at 12:46 pm

    #1952647

  • RE: 'Testing' a SQL Server 2014

    Honestly your testing is will provide TRIVIAL benefits compared to the HUGELY more important issue here: your admission that you have no DBA. Thus you will ABSOLUTELY mis/suboptimally configure most...

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

    July 24, 2017 at 9:39 am

    #1952407

  • RE: Buffer Pool Extension

    SteveOC - Monday, July 24, 2017 5:14 AM

    Thanks for the response Kevin.

    My take was that the SSDs are what they are -...

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

    July 24, 2017 at 9:32 am

    #1952405

  • RE: ORDER BY with CASE in SELCT DISTINCT

    Can you please state what your desired output is for different inputs?

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

    July 24, 2017 at 9:18 am

    #1952400

  • RE: Tempdb Spills

    So you apparently have scalar UDFs, which a) hose the estimating ability of the optimizer, b) prevent the use of index seeks if appropriate and c) void the use of...

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

    July 24, 2017 at 9:15 am

    #1952395

  • RE: High level performance report aimed at senior management

    lassell - Saturday, July 22, 2017 10:13 PM

    Apologies if you feel this goes way beyond a free forum request but you have...

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

    July 23, 2017 at 6:00 pm

    #1952288

  • RE: Buffer Pool Extension

    SteveOC - Sunday, July 23, 2017 4:39 AM

    Hello.

    I have been puzzling over this for some time and still can't grasp what the...

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

    July 23, 2017 at 5:56 pm

    #1952287

  • RE: High level performance report aimed at senior management

    lassell - Friday, July 21, 2017 3:47 PM

    Hi all,
    I've been in the SQL space for a number of years now and recently...

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

    July 22, 2017 at 10:47 am

    #1952247

Viewing 15 posts - 196 through 210 (of 5,841 total)