Forum Replies Created

Viewing 15 posts - 406 through 420 (of 49,552 total)

  • RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

    jonathan.crawford - Thursday, January 25, 2018 6:56 AM

    Because I don't have to know T-SQL inside out and upside down in order 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

    January 25, 2018 at 7:22 am

    #1977327

  • RE: SQL deadlock on delete in clustered index

    It's deadlocking because there's some statement earlier in the transaction holding other locks. You need to identify what those other statements are before you can solve this deadlock problem.
    Don't...

    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

    January 25, 2018 at 7:19 am

    #1977324

  • RE: Last execution date for stored procedure

    For when the procedure was created, look at the create date in sys.procedures. SQL doesn't track the last execution date except as tied to the plan (which is not necessarily...

    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

    January 25, 2018 at 6:49 am

    #1977312

  • RE: Snapshot Isolation

    Yes, it will take a while if there's stuff running. It doesn't need single user, but it can't complete until all requests running at the point it started have finished.

    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

    January 25, 2018 at 5:16 am

    #1977298

  • RE: Licensing

    No, it means that 20 devices max can connect to that single SQL Server

    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

    January 25, 2018 at 3:28 am

    #1977286

  • RE: Snapshot Isolation

    The first allows you to use SET TRANSACTION ISOLATION LEVEL SNAPSHOT in your queries. SNAPSHOT cannot be made a default isolation level
    The second makes   changes the default isolation level...

    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

    January 25, 2018 at 3:27 am

    #1977285

  • RE: master..spt_values is not found in Azure SQL database

    Narine M - Thursday, January 25, 2018 3:00 AM

    Is there any alternate solution

    No idea. What are you doing with that table?

    Cross 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

    January 25, 2018 at 3:25 am

    #1977283

  • RE: Licensing

    Understand what about 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

    January 25, 2018 at 1:46 am

    #1977268

  • RE: Is 'Select Top 1000 Rows' functionality still available in SSMS 17.4?

    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

    January 25, 2018 at 1:45 am

    #1977267

  • RE: SQL deadlock on delete in clustered index

    sqld-_-ba - Wednesday, January 24, 2018 4:57 PM

    The deadlock happened 30 minutes back on Production, and I'm checking the table now.
    If only...

    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

    January 25, 2018 at 1:40 am

    #1977265

  • RE: SQL deadlock on delete in clustered index

    TheSQLGuru - Wednesday, January 24, 2018 8:21 PM

    Having different RECORDS doesn't mean they don't have one or more identical VALUES in 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

    January 25, 2018 at 1:37 am

    #1977264

  • RE: master..spt_values is not found in Azure SQL database

    Correct, that table won't be there, it's not expected to be there.

    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

    January 25, 2018 at 1:35 am

    #1977263

  • RE: Multiple parameters from Querystring to serach the Database

    babar_ch - Wednesday, January 24, 2018 10:46 PM

    Hi,
    Thank  you for the reply. I am using a function to avoid injection like ColorC=Sqlinj(Request.QueryString("Color")) 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

    January 25, 2018 at 1:32 am

    #1977262

  • RE: Differential Restore Question

    Yes, no, no

    They just must not take their own transaction log backup.

    Edit:  And you can carry on just restoring the log backups on the sunday, 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

    January 24, 2018 at 11:26 am

    #1977165

  • RE: IF clause, cannot get rid of the red squiggle...

    A CTE must be followed immediately by a query. Yours is not, it's followed by an IF statement.
    The IF needs to go outside of the CTE.

    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

    January 24, 2018 at 9:20 am

    #1977129

Viewing 15 posts - 406 through 420 (of 49,552 total)