Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 49,552 total)

  • RE: Query returning incorrect results randomly

    It's going to be nearly impossible to diagnose without the query, as it's probably something related to the query and/or table structure.

    You can obfuscate the table and column names,...

    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

    November 7, 2016 at 3:12 pm

    #1911055

  • RE: Query returning incorrect results randomly

    Can you post the query? Execution plan might also be helpful.

    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

    November 7, 2016 at 2:51 pm

    #1911048

  • RE: Are the posted questions getting worse?

    Good, then it's decided. Thank 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

    November 7, 2016 at 2:30 pm

    #1911044

  • RE: Are the posted questions getting worse?

    Got my blog working again, finally. Hosting provider can't figure out how the files got wiped, restored a 3 month old backup, got my name incorrect in their last reply...

    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

    November 7, 2016 at 2:18 pm

    #1911040

  • RE: MSDB jobs in DB mirroring and AlwaysOn availability group

    szejiekoh (11/7/2016)

    q2) As part of the release process, Do we also have to add the following line in the script ->

    "EXEC msdb.dbo.sp_update_job @job_name='Your job name',@enabled = 0 " ...

    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

    November 7, 2016 at 10:40 am

    #1910980

  • RE: Query returns incorrect value

    It is indeed the quotes causing the problem. As written, the query is looking for an ID equal to the string literal '@COLLEAGUE_ID' because it's in quotes.

    exec sp_executesql N'SELECT COUNT...

    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

    November 7, 2016 at 8:22 am

    #1910935

  • RE: Check my backup knowledge?

    Brandie Tarvin (11/7/2016)

    GilaMonster (11/7/2016)

    No, a compressed backup is compressed from the start.

    If it worked according to your theory, then a compressed backup would take longer than a normal backup...

    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

    November 7, 2016 at 6:54 am

    #1910907

  • RE: Migrating Data from SQL server 2012 to Data Warehouse

    By 'data warehouse', do you mean Azure SQL Data Warehouse, or just a generic, on-my-own-servers 'data warehouse'

    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

    November 7, 2016 at 6:33 am

    #1910903

  • RE: Check my backup knowledge?

    No, a compressed backup is compressed from the start.

    If it worked according to your theory, then a compressed backup would take longer than a normal backup (write out 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

    November 7, 2016 at 6:29 am

    #1910901

  • RE: MSDB jobs in DB mirroring and AlwaysOn availability group

    szejiekoh (11/5/2016)

    Even if msdb has system information embedded within, what is the problem of taking a msdb backup and restoring it in a new instance ?

    The fact that it has...

    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

    November 7, 2016 at 5:50 am

    #1910889

  • RE: DBCC CHECKALLOC returns errors

    Please don't post multiple threads for the same question.

    No replies here. Direct replies to http://www.sqlservercentral.com/Forums/Topic1832272-2893-1.aspx

    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

    November 6, 2016 at 11:59 am

    #1910797

  • RE: DBCC CHECKALLOC returns errors

    Please don't post multiple threads for the same question.

    No replies here. Direct replies to http://www.sqlservercentral.com/Forums/Topic1832272-2893-1.aspx

    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

    November 6, 2016 at 11:59 am

    #1910796

  • RE: DBCC CHECKALLOC returns errors

    What's the full and complete output of

    DBCC CheckDB('<database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS

    ?

    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

    November 6, 2016 at 11:58 am

    #1910795

  • RE: Table valued fucntion or scalar valued function

    sqlfriends (11/4/2016)

    Thanks. Because it will be used in several places , so other developer request to create a function for reuse

    Often in SQL, 'reusable code' = 'slow code'

    Have you considered...

    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

    November 5, 2016 at 2:47 pm

    #1910776

  • RE: How to find executed time

    Jeff Moden (11/4/2016)

    With the understanding that it clears out on a restart of the SQL Service, you could also look at sys.dm_db_index_usage_stats. It won't differentiate between INSERTs and UPDATEs...

    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

    November 4, 2016 at 8:57 am

    #1910621

Viewing 15 posts - 2,146 through 2,160 (of 49,552 total)