Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 49,552 total)

  • RE: Using Named Transactions

    vincentshanecurtis - Sunday, July 23, 2017 9:14 AM

    Gail,
    Thanks for the assist.  In my case I don't think it will be an issue. ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2017 at 10:34 am

    #1952266

  • RE: Backup command with multiple threads.

    SQL-DBA-01 - Sunday, July 23, 2017 7:16 AM

    GilaMonster - Sunday, July 23, 2017 5:57 AM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2017 at 8:01 am

    #1952263

  • RE: Using Named Transactions

    Yes, query sys.dm_tran_active_transactions.

    However, that just tells you that the transaction exists, which should be for a very short time and so is more useful for debugging than seeing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2017 at 6:03 am

    #1952261

  • RE: Developer Edition - Free to use (or not)?

    Please ask the people telling you that what those 'other' costs are.

    https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/

    Starting today, SQL Server 2014 Developer Edition is now a free download...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2017 at 5:59 am

    #1952260

  • RE: Backup command with multiple threads.

    You get one thread per file in the DB (I think), and one per backup file, so if you want more threads, you stripe the backup.

    Why do you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 23, 2017 at 5:57 am

    #1952259

  • RE: Msg 823 and Msg 8921

    If CheckDB's returning that, it's probably a fatal error.

    Do you have a clean backup of this database?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2017 at 2:24 pm

    #1952213

  • RE: Stored procedure is a lot slower than standard query

    Something to try...

    Linked servers have estimation problems if the linked server isn't using a sysadmin account (which it shouldn't be)
    Try inserting the data you need from the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2017 at 4:42 am

    #1952028

  • RE: Stored procedure is a lot slower than standard query

    Can you post both execution plans please? Actual plans, not estimated.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2017 at 3:53 am

    #1952018

  • RE: CREATE EXTERNAL DATA SOURCE

    solus - Wednesday, May 10, 2017 5:57 AM

    Im trying to extract data stored as a csv file in azure blob storage and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 21, 2017 at 3:22 am

    #1952015

  • RE: Reseed one table column

    I would advise leaving it alone and not trying to reuse the gaps. Doing so is asking for trouble.

    If, say, you had the values 10, 20 and 35...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 20, 2017 at 1:37 pm

    #1951959

  • RE: Pass dataset as parameter from application to stored procedure

    Table-type parameters.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 20, 2017 at 8:20 am

    #1951854

  • RE: Who inserted duplicated key value yesterday

    Unless you have some custom monitoring in place recording user errors and what login caused them, you can't tell.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 20, 2017 at 4:18 am

    #1951801

  • RE: Distinct query with all columns

    bmg002 - Wednesday, July 19, 2017 2:36 PM

    While I do agree you should get rid of duplicates, I am a little...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 19, 2017 at 4:29 pm

    #1951770

  • RE: Distinct query with all columns

    With that level of duplicates, and no foreign keys, easiest is probably to SELECT DISTINCT *  INTO <new table> FROM ..., then drop (or rename) the original table, rename the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 19, 2017 at 1:33 pm

    #1951743

  • RE: Can I point a SP to a databse on a different server?

    Look up Linked Servers.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 19, 2017 at 1:32 pm

    #1951742

Viewing 15 posts - 1,081 through 1,095 (of 49,552 total)