Forum Replies Created

Viewing 15 posts - 1,201 through 1,215 (of 49,552 total)

  • RE: #temp Table

    etl2016 - Tuesday, July 4, 2017 3:17 PM

    1) What is the Life and Scope of a #temp table?   Is it per-session?  If...

    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 4, 2017 at 3:38 pm

    #1949374

  • RE: Integer to Big Integer and foreign keys

    You will need to:

    Drop the foreign keys
    Drop the primary key
    Make the data type change
    Recreate the primary key
    Recreate the foreign keys

    With a billion...

    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 4, 2017 at 1:42 pm

    #1949371

  • RE: Using Lead And Lag Functions As A Means Of Navugating Back And Forth In A Recordset

    vincentshanecurtis - Tuesday, July 4, 2017 1:08 PM

    Sounds like what your saying is that I should just keep my navigation code 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

    July 4, 2017 at 1:25 pm

    #1949368

  • RE: Splitting TempDB

    Perry Whittle - Tuesday, July 4, 2017 10:26 AM

    Mike Scalise - Friday, June 30, 2017 8:04 AM

    Hi, 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

    July 4, 2017 at 1:14 pm

    #1949367

  • RE: Are the posted questions getting worse?

    Some people are kinda getting on my nerves.
    People who are the excellent at something usually don't have to go around proclaiming that fact.

    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 4, 2017 at 1:10 pm

    #1949365

  • RE: Reasons to have Mirroring AND local backups?

    JaybeeSQL - Tuesday, July 4, 2017 9:50 AM

    Could you elaborate on the index part?  I'm also involved in rationalising indexing.

    Reorg followed...

    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 4, 2017 at 1:06 pm

    #1949363

  • RE: CPU troubleshooting with Perfom counters

    One more try.

    Can you post the perfmon showing the max, min and avg of the privileged time?
    Also, what process is that?

    CPU usage is definitely too...

    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 4, 2017 at 4:04 am

    #1949300

  • RE: Using Lead And Lag Functions As A Means Of Navugating Back And Forth In A Recordset

    vincentshanecurtis - Tuesday, July 4, 2017 2:57 AM

    Thanks for your input.  It's very helpful. Yes I know that a cursor is intended...

    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 4, 2017 at 3:32 am

    #1949296

  • RE: Reasons to have Mirroring AND local backups?

    JaybeeSQL - Tuesday, July 4, 2017 3:15 AM

    Hi all,

    One of my clients has both of these for the same server.

    Good, finally...

    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 4, 2017 at 3:31 am

    #1949295

  • RE: Question about TABLOCKX and HOLDLOCK

    divinomestre79 - Monday, July 3, 2017 1:36 PM

    Hi,
    Thanks for the reply.
    So if  i understand i would need to add a new parameter...

    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 3, 2017 at 2:48 pm

    #1949239

  • RE: General advice needed - database design - Is this a bad way to design a pricing table?

    Method 1 is terrible. It's a violation of first normal form, and it's a pain to work with. What happens if there's a decision to allow up to 5 bottles,...

    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 3, 2017 at 8:32 am

    #1949161

  • RE: Running total for previous 7 rows

    michelle.mabbs - Monday, July 3, 2017 6:51 AM

    No I'm using 17 but the databases are old and most of the new functionality...

    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 3, 2017 at 8:23 am

    #1949155

  • RE: Running total for previous 7 rows

    Are you really using SQL 2008?

    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 3, 2017 at 6:39 am

    #1949120

  • RE: CPU troubleshooting with Perfom counters

    How many CPUs does that server have?

    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 3, 2017 at 3:50 am

    #1949111

  • RE: CPU troubleshooting with Perfom counters

    Post more of perfmon please, including scale and in/max/average

    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 3, 2017 at 1:44 am

    #1949104

Viewing 15 posts - 1,201 through 1,215 (of 49,552 total)