Forum Replies Created

Viewing 15 posts - 976 through 990 (of 49,552 total)

  • RE: tempdb causing constant Disk IO

    Reside in, yes, but structures in TempDB still get written to disk.

    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

    August 4, 2017 at 7:40 am

    #1954140

  • RE: Creating ASDW tables

    Ed Wagner - Friday, August 4, 2017 6:29 AM

    Having never used SQL Azure, I had to research it and learned something new. ...

    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

    August 4, 2017 at 7:01 am

    #1954130

  • RE: Creating ASDW tables

    TomThomson - Friday, August 4, 2017 5:04 AM

    GilaMonster - Friday, August 4, 2017 2:17 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

    August 4, 2017 at 5:54 am

    #1954122

  • RE: Using Print To Debug Stored Procedures

    vincentshanecurtis - Thursday, August 3, 2017 9:35 PM

    Sure looks like a Fetch command to me

    It is, because if you want to run...

    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

    August 4, 2017 at 2:24 am

    #1954102

  • RE: Why do I need Enterprise version for R

    newdba2017 - Thursday, August 3, 2017 11:42 AM

     Again the confusion, why do I need enterprise version of SQL Server for R language....

    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

    August 4, 2017 at 2:21 am

    #1954101

  • RE: Creating ASDW tables

    Unfortunately the question is out of date. REPLICATE is also an option now.

    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

    August 4, 2017 at 2:17 am

    #1954100

  • RE: Are the posted questions getting worse?

    Thom A - Friday, August 4, 2017 2:08 AM

    GilaMonster - Friday, August 4, 2017 1:56 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

    August 4, 2017 at 2:09 am

    #1954099

  • RE: How Important Is The Semi-Colon In Coding Stored Procedures?

    rigerta.demiri21 - Friday, August 4, 2017 1:54 AM

    Alternatively, developers put the semicolon before the WITH statement, like this:

    ;WITH test_cte AS

    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

    August 4, 2017 at 1:58 am

    #1954093

  • RE: Are the posted questions getting worse?

    Some people need to learn basics of error handling, transactions and common sense. 🙁

    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

    August 4, 2017 at 1:56 am

    #1954092

  • RE: How Important Is The Semi-Colon In Coding Stored Procedures?

    At the moment, not very, unless you're using one of the statements that has to be semi-colon terminated or has to have the previous statement semi-colon terminated (merge, CTEs 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

    August 4, 2017 at 1:56 am

    #1954091

  • RE: CPU utilization 100%

    krishna83 - Friday, August 4, 2017 12:32 AM

    We find  CPU utilization reached to 100% last night. Client could not able to access...

    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

    August 4, 2017 at 1:26 am

    #1954085

  • RE: Are these both same? Begin Tran & Begin Try

    curious_sqldba - Thursday, August 3, 2017 11:24 PM

    I ran the code and manually killed the connection, for some reason didn't get logged....

    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

    August 4, 2017 at 1:12 am

    #1954084

  • 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

    What could be the reason for slowness of return, when the Tsql code is executed...

    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

    August 4, 2017 at 1:11 am

    #1954083

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

    er.mayankshukla - Thursday, August 3, 2017 9:31 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

    August 4, 2017 at 1:10 am

    #1954082

  • RE: Are the posted questions getting worse?

    Phil Parkin - Thursday, August 3, 2017 9:34 AM

    Luis Cazares - Thursday, August 3, 2017 9:29...

    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

    August 3, 2017 at 3:12 pm

    #1954051

    • Viewing 15 posts - 976 through 990 (of 49,552 total)