Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 49,552 total)

  • RE: Forum User Post Levels

    Sean Lange - Thursday, February 9, 2017 3:05 PM

    I assume by "Gain" you mean Gail (aka GilaMonster)? And currently she has 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

    February 10, 2017 at 3:19 am

    #1927709

  • RE: 2 Select Statements Deadlocking

    Perry Whittle - Thursday, February 9, 2017 10:52 AM

    as i recall it you shouldnt be seeing a lock mode of X...

    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

    February 9, 2017 at 3:04 pm

    #1927659

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, February 9, 2017 12:14 PM

    Oh, it's not on the forums. Sean sent me an email promising 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

    February 9, 2017 at 3:01 pm

    #1927658

  • RE: LCK_M_IX waittype is found in SQL SERVER

    Narine M - Thursday, February 9, 2017 8:43 AM

    We are continuously facing performance issue in an production server??What all the possible reasons???

    The answer to 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

    February 9, 2017 at 10:35 am

    #1927597

  • RE: High Memory Usage

    WhiteLotus - Wednesday, February 8, 2017 8:12 PM

    Apparently only 2 or 3 GB would be added

    So do you want my laptop...

    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

    February 9, 2017 at 12:50 am

    #1927454

  • RE: Connection Strings. Why?

    Can you post the connection string (obsfucate or remove server name, user name and password of course)?

    I usually use https://www.connectionstrings.com/ if I need to look up options...

    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

    February 9, 2017 at 12:47 am

    #1927453

  • RE: Is having a lookup table that is for multiple entities a common practice?

    IMO, it's an extremely bad practice.

    It reduces database integrity, because foreign keys can't have filters on them, and so there's no way for the DB to prevent 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

    February 9, 2017 at 12:45 am

    #1927452

  • RE: Creating a derived column from multiple tables

    You can't create a calculated column that references other tables.

    Options:
    1) create a scalar udf and use that as the derived column definition (slow and not recommended...

    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

    February 8, 2017 at 11:53 am

    #1927391

  • RE: ShrinkFile

    timwell - Wednesday, February 8, 2017 7:52 AM

    GilaMonster - Wednesday, February 8, 2017 5:10 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

    February 8, 2017 at 11:48 am

    #1927389

  • RE: Your Favorite Feature that Needs Work

    Luis Cazares - Wednesday, February 8, 2017 6:35 AM

    GilaMonster - Wednesday, February 8, 2017 4:57 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

    February 8, 2017 at 7:25 am

    #1927318

  • RE: ShrinkFile

    The TRUNCATEONLY option is ignored on log files, because there's no concept of shuffling data in a log file. Essentially all shrinks of a log file are TRUNCATEONLY.
    The given...

    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

    February 8, 2017 at 5:10 am

    #1927293

  • RE: Possible to share a very large database between servers?

    Adi Cohn-120898 - Wednesday, February 8, 2017 12:46 AM

    There is a very little known feature that is called - Scalable shared databases....

    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

    February 8, 2017 at 5:07 am

    #1927291

  • RE: Your Favorite Feature that Needs Work

    Thom A - Wednesday, February 8, 2017 3:04 AM

     I'd assume for 3 hour intervals the syntax would be GROUP...

    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

    February 8, 2017 at 4:57 am

    #1927289

  • RE: Possible to share a very large database between servers?

    Jim Youmans-439383 - Tuesday, February 7, 2017 2:54 PM

    Are there any features in SQL 2014 or SQL 2016 that would allow multiple...

    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

    February 8, 2017 at 12:11 am

    #1927244

  • RE: High Memory Usage

    WhiteLotus - Tuesday, February 7, 2017 5:07 PM

    GilaMonster - Tuesday, February 7, 2017 10:52 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

    February 7, 2017 at 11:59 pm

    #1927243

Viewing 15 posts - 1,801 through 1,815 (of 49,552 total)