Forum Replies Created

Viewing 15 posts - 571 through 585 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, December 19, 2017 6:20 PM

     the GraphDB Microsoft added in SQL Server 2017, is that in the on premise...

    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

    December 20, 2017 at 12:53 am

    #1972846

  • RE: Profiler hangs and Clustered SQL Server restarts !

    You're far from the first to have crashed SQL by running Profiler (and running it from a different server to production is actually far worse)

    DO NOT use 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

    December 20, 2017 at 12:50 am

    #1972844

  • RE: Creating databse backups automatically in specific period of time

    Simpler than calling SQLCMD and passing it T-SQL? Ok.

    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

    December 19, 2017 at 1:19 am

    #1972636

  • RE: Creating databse backups automatically in specific period of time

    That's T-SQL, so no, it won't run in command line.
    You can run it via the util that John mentioned.

    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

    December 19, 2017 at 12:27 am

    #1972633

  • RE: Using the Key Lookup and Index Seek Properties to construct the missing indexes

    Leading with the clustered index key means that the only advantage it has over the clustered index is that the new index is smaller. It'll give you gains for queries...

    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

    December 18, 2017 at 1:48 pm

    #1972585

  • RE: Item Price changes

    HappyGeek - Tuesday, December 5, 2017 2:18 AM

    An alternative to Anthony's could be to use the WHERE clause as 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

    December 18, 2017 at 1:13 am

    #1972429

  • RE: Restore full backup at first and restore diff backup later, can I?

    Yup, no problem, providing you restore the full backup WITH NORECOVERY, and that there are no full backups taken between Tuesday and Friday evening.

    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

    December 18, 2017 at 12:45 am

    #1972428

  • RE: Index sugggestion...

    Equality predicates first (ComponentID, IsActive, SampleStatusID), then inequality predicates.

    If ISActive is the same everywhere, better to remove it from the query, or make the index filtered. If 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

    December 17, 2017 at 1:37 am

    #1972400

  • RE: Selectivity vs SARGAbility?

    From the blog post:

    A seek requires a predicate and that predicate must be of the form that can be used as a search argument (SARGable)

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

    December 17, 2017 at 1:31 am

    #1972399

  • RE: Using the Key Lookup and Index Seek Properties to construct the missing indexes

    The index you created will do nothing, because the leading column is the clustered index key, and is hence already indexed.

    Key lookups are single-row seeks against the clustered...

    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

    December 16, 2017 at 5:10 am

    #1972377

  • RE: Selectivity vs SARGAbility?

    https://www.sqlinthewild.co.za/index.php/2015/10/06/index-selectivity-and-index-scans/

    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

    December 16, 2017 at 5:02 am

    #1972376

  • RE: Help with SQL memory pressure investigation

    What did the two counters Total Server Memory and Target Server Memory look like over that period?

    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

    December 15, 2017 at 3:30 am

    #1972272

  • RE: Profiler hangs and Clustered SQL Server restarts !

    sqlGDBA - Thursday, December 14, 2017 4:02 PM

    Hello All. We just had this happen on one of our production SQL Servers. One...

    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

    December 15, 2017 at 12:40 am

    #1972244

  • RE: ALIGNMENT

    https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql

    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

    December 13, 2017 at 11:36 pm

    #1972066

  • RE: Fragmented Tables

    No.

    However the tables should have clustered indexes

    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

    December 13, 2017 at 3:16 pm

    #1972048

Viewing 15 posts - 571 through 585 (of 49,552 total)