Forum Replies Created

Viewing 15 posts - 46 through 60 (of 49,552 total)

  • RE: Incorrect syntax near '.'.

    datsun - Friday, November 2, 2018 9:45 AM

    Yes, actually it is SQL server 2000 (80) compatibility level.  
    Is that the reason for this...

    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 2, 2018 at 11:44 am

    #2012246

  • RE: Why we schedule copy_only backup on secondary in always on

    peter2501 - Friday, November 2, 2018 8:55 AM

    When you do a regular full backup on the primary database, you break the chain...

    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 2, 2018 at 9:34 am

    #2012212

  • RE: Why we schedule copy_only backup on secondary in always on

    It's got nothing to do with the log records as full backups do not interfere with the log chain. EVER.

    The DB on the secondary is read-only. A...

    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 2, 2018 at 9:33 am

    #2012211

  • RE: Incorrect syntax near '.'.

    Functions need the schema name.
    Also check that you aren't somehow in compat mode 80 or  lower.

    The code as posted parses fine for me, can't run as I...

    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 2, 2018 at 9:27 am

    #2012210

  • RE: Column data type - Msg 207 Invalid column name

    gjoelson 29755 - Wednesday, October 31, 2018 12:30 PM

    Correct, don't ask - its to do with read only permissions on that...

    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 1, 2018 at 3:12 am

    #2012005

  • RE: Executing a query with highest possible priority

    VoldemarG - Wednesday, October 31, 2018 12:44 PM

     I pretty much know where the issue is, its a view that returns 21...

    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 1, 2018 at 3:09 am

    #2012004

  • RE: Need help with SQL trace

    A .trc file is a binary file, so you should expect to get garbage when you open it in a text editor.

    What are you trying to do?

    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

    October 31, 2018 at 3:50 pm

    #2011970

  • RE: Encrypt and Decrypt password in SQL

    Never encrypt passwords. Salted hash, then the app hashes (with the same salt) and you compare the hashes.

    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

    October 31, 2018 at 3:49 pm

    #2011969

  • RE: Orphaned tables in sys.tables?

    datsun - Tuesday, October 30, 2018 5:31 AM

    Why would there be some orphaned table entries in sys.tables, when those tables don't exist...

    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

    October 31, 2018 at 3:47 pm

    #2011968

  • RE: How many clustered indexes can a table have?

    Please note: 8 year old thread.

    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

    October 29, 2018 at 2:09 am

    #2011482

  • RE: Error - 'The multi-part identifier A.Months could not be bound"

    You'll need to join to the table [Test1]. You can't just dump a partial select inside a function where a column or value is required and expect it to...

    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

    October 27, 2018 at 3:06 pm

    #2011457

  • RE: TRANSACTION effects and considerations

    sgmunson - Friday, October 26, 2018 11:53 AM

    GilaMonster - Friday, October 26, 2018 11:26 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

    October 26, 2018 at 12:10 pm

    #2011394

  • RE: TRANSACTION effects and considerations

    sgmunson - Friday, October 26, 2018 7:38 AM

    Lynn Pettis - Thursday, October 25, 2018 2:40 PM

    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

    October 26, 2018 at 11:26 am

    #2011386

  • RE: NOT IN vs NOT EXISTS

    IN vs EXISTS: https://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
    NOT IN vs NOT EXISTS (beware the behaviour difference with NULLs) https://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    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

    October 26, 2018 at 2:51 am

    #2011306

  • RE: TRANSACTION effects and considerations

    Nope. Temp tables are part of user transactions, and if there's a rollback any operations against them within the transaction will be rolled back. Table variables are the only thing...

    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

    October 25, 2018 at 1:44 pm

    #2011235

Viewing 15 posts - 46 through 60 (of 49,552 total)