Forum Replies Created

Viewing 15 posts - 946 through 960 (of 49,552 total)

  • RE: temp tables exist in tempdb under folder : "Temporary Tables".

    Only the session that created a temp table can drop it, or look at it in any way.

    They're probably cached temp tables, not ones in use. SQL caches...

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

    #1954918

  • RE: Recovery Model-Tlog Backup

    coolchaitu - Thursday, August 10, 2017 10:42 PM

     Is this the reason why we cannot take log backups in simple recovery mode

    Yes.

    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 11, 2017 at 1:10 am

    #1954917

  • RE: Simple Recovery Model and Checkpoint

    Checkpoint marks VLFs that are not needed for anything (replication, transactions, full backups, etc) as reusable.

    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 11, 2017 at 1:09 am

    #1954916

  • RE: SET NOCOUNT ON at instance level - not working.

    It's not an instance-level setting. It's a session-level setting.
    The user options is, afaik, a default for clients that don't specify the setting, and SSMS does specify it.

    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 11, 2017 at 1:08 am

    #1954915

  • RE: Statistics' update at reaching the threshold

    Neither.

    When a query needs a statistic (for optimisation), the row modification count is checked. If it exceeds the threshold, then that statistic (and only that statistic) is updated.

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

    #1954895

  • RE: Difference in row-size between what was expected and what was — can anyone explain please?

    Sean Redmond - Thursday, August 10, 2017 8:20 AM

    GilaMonster - Thursday, August 10, 2017 8:09 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 10, 2017 at 11:23 am

    #1954853

  • RE: Difference in row-size between what was expected and what was — can anyone explain please?

    Sean Redmond - Thursday, August 10, 2017 8:00 AM

    Hi Gail,
    In answer to your question, neither 'read_committed_snapshot' nor 'allow_snapshot_isolation' are enabled. It 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

    August 10, 2017 at 8:09 am

    #1954812

  • RE: Difference in row-size between what was expected and what was — can anyone explain please?

    ScottPletcher - Thursday, August 10, 2017 7:45 AM

    ben.brugman - Thursday, August 10, 2017 6:03 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 10, 2017 at 7:51 am

    #1954805

  • RE: Difference in row-size between what was expected and what was — can anyone explain please?

    Does the database have read_committed_snapshot or allow_snapshot_isolation enabled on it?

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

    #1954804

  • RE: Union is not working

    hayekmichel - Thursday, August 10, 2017 7:07 AM

     when i use the union it is adding the second query as ROWS and NOT...

    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 10, 2017 at 7:09 am

    #1954796

  • RE: Encyrption - hide definitions

    Adam Sandler - Thursday, August 10, 2017 6:28 AM

    Right thanks yes. I'll ensure they only have the db_reader etc. Thanks for...

    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 10, 2017 at 6:32 am

    #1954788

  • RE: Difference in row-size between what was expected and what was — can anyone explain please?

    2 bytes for the row header, 2 bytes for the slot array index, 2 bytes for the null bitmap offset, then one bit per column (minimum 1 byte) for the...

    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 10, 2017 at 6:13 am

    #1954784

  • RE: Encyrption - hide definitions

    Adam Sandler - Thursday, August 10, 2017 5:02 AM

    You can use with encrytion on  view etc creation cant you. But this  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

    August 10, 2017 at 5:48 am

    #1954773

  • RE: Encyrption - hide definitions

    Adam Sandler - Thursday, August 10, 2017 4:21 AM

    Whats the best way of securing all design from a logon with lesser rights....

    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 10, 2017 at 5:46 am

    #1954772

  • RE: Alwayson with mixed versions

    Possible, yes. In violation of licensing terms, yes.

    That's a production environment (since it's the replica of your production environment) and hence it violates the Developer edition license terms...

    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 10, 2017 at 5:42 am

    #1954768

Viewing 15 posts - 946 through 960 (of 49,552 total)