Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 49,552 total)

  • RE: SSC Forum Updates

    One other request.
    Would it be possible to get the username of the person who started the thread displayed on the "Latest Posts" view?

    Please?????

    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 12, 2017 at 7:15 am

    #1922254

  • RE: Convert Datetime to UTC based on TIME Stamp

    vijay.singh 46672 - Thursday, January 12, 2017 7:05 AM

    GilaMonster - Thursday, January 12, 2017 6:21 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

    January 12, 2017 at 7:12 am

    #1922252

  • RE: SSD Drive

    In general, if you have a choice of only one, then you want to put the files with the highest IO latency (or highest IO load) on the faster storage.

    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 12, 2017 at 6:47 am

    #1922233

  • RE: CASE help for newbie

    What are the names of the columns in the table aliased as 'z'? Can you post the rest of the query and the CREATE TABLE statement?

    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 12, 2017 at 6:29 am

    #1922224

  • RE: CASE help for newbie

    rob.king - Thursday, January 12, 2017 6:16 AM

    Hi all,

    Looking to get some help with the following that I just can't get the case...

    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 12, 2017 at 6:24 am

    #1922219

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, January 12, 2017 6:14 AM

    And that was my morning. How is yours going?

    Trying to diagnose why a PDW spent...

    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 12, 2017 at 6:23 am

    #1922215

  • RE: Convert Datetime to UTC based on TIME Stamp

    vijay.singh 46672 - Thursday, January 12, 2017 6:11 AM

    GilaMonster - Thursday, January 12, 2017 6:07 AM

    How...

    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 12, 2017 at 6:21 am

    #1922214

  • RE: Convert Datetime to UTC based on TIME Stamp

    How does your app know what time zone it is logging the data 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

    January 12, 2017 at 6:07 am

    #1922208

  • RE: SSC Forum Updates

    Request: Can the SQL Code IIF link be made easier to get to?
    Currently it's 'hover over "Insert, click IIFCode, scroll way down the list to "SQL Code",...

    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 12, 2017 at 5:52 am

    #1922205

  • RE: Find partitions, row count of each partition of a partition table

    arifulhaq - Thursday, January 12, 2017 5:37 AM

    If there is no index for any partition then I will get one row in output...

    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 12, 2017 at 5:49 am

    #1922203

  • RE: Find partitions, row count of each partition of a partition table

    Or, much simpler,

    SELECT OBJECT_NAME(object_id) AS TableName, partition_number, row_count FROM sys.dm_db_partition_stats
    WHERE OBJECT_ID = OBJECT_ID('STORE')

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

    #1922172

  • RE: Read committed isolation level and select on large tables

    jesijesijesi - Wednesday, January 11, 2017 6:14 PM

    Acquire shared page lock, read page, release shared page lock, move to next page and so...

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

    #1922161

  • RE: Not Excited by Linux

    Revenant (1/11/2017)

    GilaMonster (1/11/2017)

    Eric M Russell (1/11/2017)

    GeorgeCopeland (1/11/2017)

    SQL Server on Linux makes lots of sense for Azure databases, I don't see tons of use elsewhere.

    No doubt someone at this moment is...

    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 11, 2017 at 1:31 pm

    #1922058

  • RE: Not Excited by Linux

    Eric M Russell (1/11/2017)

    GilaMonster (1/11/2017)

    Eric M Russell (1/11/2017)

    GeorgeCopeland (1/11/2017)

    SQL Server on Linux makes lots of sense for Azure databases, I don't see tons of use elsewhere.

    No doubt someone at 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

    January 11, 2017 at 1:31 pm

    #1922057

  • RE: Not Excited by Linux

    Eric M Russell (1/11/2017)

    GeorgeCopeland (1/11/2017)

    SQL Server on Linux makes lots of sense for Azure databases, I don't see tons of use elsewhere.

    No doubt someone at this moment is trying 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 11, 2017 at 11:21 am

    #1922026

Viewing 15 posts - 1,891 through 1,905 (of 49,552 total)