Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 49,552 total)

  • RE: Table size and indexes

    NineIron - Wednesday, April 12, 2017 11:37 AM

    How many rows does a table need to have before you start thinking about adding...

    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

    April 12, 2017 at 2:02 pm

    #1937934

  • RE: Copy-Only backups in backup chain.

    acrutchley - Wednesday, April 12, 2017 9:33 AM

    I understand what you are saying, but this is not what is supposed to happen...

    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

    April 12, 2017 at 2:01 pm

    #1937933

  • RE: Which actions cause tables to be recreated?

    SQL Server, or Management Studio?

    SQL Server will not recreate a table. The closest would be changing the clustered index.
    As for Management Studio, easiest answer there is 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

    April 12, 2017 at 8:28 am

    #1937855

  • RE: Upgrading from sql server 2012 to 2016

    I don't think there's any T-SQL that worked in 12 and not 16.

    What's going to bite you is the cardinality estimator changes. Make sure you test performance of...

    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

    April 12, 2017 at 7:34 am

    #1937832

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Tuesday, April 11, 2017 3:46 PM

    Not a good 'bits ending for me either. Got sick Sat...

    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

    April 12, 2017 at 5:53 am

    #1937813

  • RE: Question about Clustering & Includes

    Grant Fritchey - Thursday, April 6, 2017 12:07 AM

    1) Completely unnecessary

    I strongly disagree. It;s future-proofing code and designs. If the clustered index...

    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

    April 6, 2017 at 10:50 am

    #1937089

  • RE: Altering a trigger

    It's a CLR trigger, common language runtime, written in C#. It's not a T-SQL trigger and that's why you're getting the error when you try to alter it to 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

    April 5, 2017 at 6:45 am

    #1936766

  • RE: Help needed for Creating Stored procedure logic.

    Please don't post multiple threads for the same question.
    No replies here. Direct replies to https://www.sqlservercentral.com/Forums/1869043/Help-required-for-creating-the-Stored-procedure-for-below-logic

    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

    April 5, 2017 at 6:07 am

    #1936759

  • RE: Import AdventureWorks2012_Database.zip to SQL Server 2016

    Don't ever try to put database files or backup files in the root of a drive. Windows protects those locations, especially the root of C
    Put it (and the log...

    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

    April 5, 2017 at 3:14 am

    #1936733

  • RE: SQL Server DBA Certification

    Lowell - Tuesday, April 4, 2017 1:37 PM

     but I did go through a level of effort many people don't, in order 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

    April 4, 2017 at 3:44 pm

    #1936661

  • RE: sys.dm_db_index_usage_stats -- what about tables w/ NO INDEXES defined?

    Express12 - Tuesday, April 4, 2017 8:15 AM

    My question is, will this work for a table with NO indexes on it?

    Yup,...

    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

    April 4, 2017 at 8:46 am

    #1936561

  • RE: Database Architecture Question

    Mike Scalise - Tuesday, April 4, 2017 7:31 AM

    Thank you, Gail!

    I didn't realize there were two versions of AG -- 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

    April 4, 2017 at 7:36 am

    #1936533

  • RE: Are the posted questions getting worse?

    ThomasRushton - Tuesday, April 4, 2017 3:32 AM

    Just today to get through before SQLBits.  Anyone else from here going to be there?

    Yup....

    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

    April 4, 2017 at 3:41 am

    #1936474

  • RE: Database Architecture Question

    Mike Scalise - Thursday, March 30, 2017 12:23 PM

    1) Regarding AlwaysOn AG -- that feature is available in the standard edition...

    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

    April 4, 2017 at 3:31 am

    #1936472

  • RE: SQL Server DBA Certification

    To add what kind of value to what?

    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

    April 4, 2017 at 3:28 am

    #1936469

Viewing 15 posts - 1,576 through 1,590 (of 49,552 total)