Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 49,552 total)

  • RE: Please explain difference between these terms

    larsp777se - Friday, March 3, 2017 3:18 AM

    If you use SQL Server authentication, can you still give rights to groups?

    No, because 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

    March 3, 2017 at 3:23 am

    #1931437

  • RE: Performance of Temp table vs Variable Table in a Procedure

    Thom A - Friday, March 3, 2017 3:10 AM

    Interesting. I did think they had changed it, however, I had a test...

    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

    March 3, 2017 at 3:14 am

    #1931434

  • RE: Perfmormance impact after downgrade from Enterprise to Standard

    You downgraded from Enterprise (which has a lot of performance features over the other editions) to Standard. You should expect that things are slower.
    The one that's probably biting you...

    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

    March 3, 2017 at 1:11 am

    #1931414

  • RE: Please explain difference between these terms

    larsp777se - Thursday, March 2, 2017 8:57 PM

    You can asume that they have indeed googled before posting on a forum.

    No, you...

    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

    March 3, 2017 at 1:00 am

    #1931413

  • RE: Shrink log file

    ramyours2003 - Thursday, March 2, 2017 10:13 PM

    thanks  for the reply , I need a steps to perform the task ?

    Jason gave...

    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

    March 3, 2017 at 12:52 am

    #1931412

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, March 2, 2017 7:47 AM

     Ironically, the ones that knew the least rated themselves the highest when asked...

    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

    March 2, 2017 at 8:24 am

    #1931203

  • RE: Are the posted questions getting worse?

    ThomasRushton - Thursday, March 2, 2017 2:04 AM

    Lynn Pettis - Wednesday, March 1, 2017 12:43 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

    March 2, 2017 at 8:17 am

    #1931198

  • RE: RDP into SQL server BAD or not

    Beatrix Kiddo - Wednesday, March 1, 2017 9:18 AM

    Where do you all stand on those third party privileged access management systems 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

    March 2, 2017 at 6:49 am

    #1931162

  • RE: How to determine Windows domain username when the user connected to SQL as SQL login with SA access

    Custom account, minimal permissions.

    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

    March 2, 2017 at 6:31 am

    #1931153

  • RE: in-memory rowstore

    If it's 2008, then it'll be something internal that you can't affect and can't change, and can't use for your own tables. Probably just an optimisation to avoid constant writes...

    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

    March 2, 2017 at 6:30 am

    #1931152

  • RE: in-memory rowstore

    Google: "In-memory OLTP" It's a feature added in SQL 2014, way too large to cover in a single forum post.
    Also consider getting https://www.simple-talk.com/books/sql-books/sql-server-internals-in-memory-oltp/

    It's not 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

    March 2, 2017 at 5:13 am

    #1931136

  • RE: Help required regarding Batche Requests/sec

    https://blogs.msdn.microsoft.com/psssql/2013/09/23/interpreting-the-counter-values-from-sys-dm_os_performance_counters/

    cntr_value

    Current value of the counter.
    Note 

    For per-second counters, this value is cumulative. The rate value must be calculated by...

    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

    March 2, 2017 at 3:56 am

    #1931131

  • RE: RDP into SQL server BAD or not

    Perry Whittle - Wednesday, March 1, 2017 4:47 AM

    John Mitchell-245523 - Wednesday, March 1, 2017 4:41 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

    March 1, 2017 at 5:43 am

    #1930937

  • RE: RDP into SQL server BAD or not

    Generally I would say bad practice. It's not just 300MB, that's the minimum. Start doing heavy work in SSMS or BI tools and it will chew memory. And that ignores...

    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

    March 1, 2017 at 4:30 am

    #1930924

  • RE: Function works when passing in parameters, does not work with CROSS APPLY

    When you say 'doesn't work', what do you mean?

    No results?
    Wrong results?
    Error message?
    Something else

    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

    March 1, 2017 at 3:38 am

    #1930909

Viewing 15 posts - 1,711 through 1,725 (of 49,552 total)