Forum Replies Created

Viewing 15 posts - 1,771 through 1,785 (of 49,552 total)

  • RE: Rename instance name in SQL Server 2008 R2

    Igor Micev - Wednesday, February 15, 2017 1:30 AM

    You can rename an instance name, why not?

    No, you can't. You can change...

    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 15, 2017 at 2:47 am

    #1928575

  • RE: Multiple Files & disks

    Rechana Rajan - Tuesday, February 14, 2017 10:59 AM

    GilaMonster - Tuesday, February 14, 2017 5:51 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 14, 2017 at 4:13 pm

    #1928518

  • RE: Reducing the size of a 500 Gb database on standard edition

    ffarouqi - Tuesday, February 14, 2017 3:59 PM

     As a matter of fact the client is more interested in performance and not space...

    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 14, 2017 at 4:05 pm

    #1928514

  • RE: Reducing the size of a 500 Gb database on standard edition

    SQL 2016 SP1 added table compression (along with In-memory OLTP, columnstore indexes and a whole pile of other things) to Standard Edition, so that's an option. Row compression is often...

    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 14, 2017 at 3:49 pm

    #1928510

  • RE: Slow query performance advice

    Index definitions for the involved tables?

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

    #1928351

  • RE: Flipping between SIMPLE and FULL recovery mode

    Ken McKelvey - Tuesday, February 14, 2017 6:26 AM

    Bulk-logged still has a couple of problems:
    1. Point in time recovery will not work...

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

    #1928350

  • RE: Slow query performance advice

    Can you post table definitions and index definitions of the involved tables, as well as the actual execution plan please?

    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 14, 2017 at 5:53 am

    #1928322

  • RE: Multiple Files & disks

    Rechana Rajan - Tuesday, February 14, 2017 5:35 AM

    But if the DB grew very large, wont the file\filegroup backup help?

    Maybe, depends...

    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 14, 2017 at 5:51 am

    #1928321

  • RE: Multiple Files & disks

    Igor Micev - Tuesday, February 14, 2017 5:10 AM

    It's early for that now. For one year you'll be about half of 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

    February 14, 2017 at 5:11 am

    #1928310

  • RE: Massive disk vs. multiple disks?

    By "More Granular" i hope you meant about filegroup backup\restore.

    Backing Up Specific Files or Filegroups
    BACKUP DATABASE { database_name | @database_name_var }
    <file_or_filegroup> [...

    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 14, 2017 at 4:55 am

    #1928305

  • RE: Multiple Files & disks

    Extra files aren't a matter of size. Why do you want to split the data file?

    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 14, 2017 at 4:44 am

    #1928302

  • RE: Add A Column And Create A Non Clustered Index on a Table

    Unless the table is empty, adding a column and creating a unique index at the same time will fail, as the newly added column is not unique.

    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 14, 2017 at 2:31 am

    #1928293

  • RE: Query never completes with CXPACKET waits

    Isabelle2378 - Monday, February 13, 2017 1:12 PM

    Hi Gail,
    The compatibility level of the test server that completes is SQL Server 2008(100).  On...

    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 14, 2017 at 2:29 am

    #1928292

  • RE: Licensing types

    The Microsoft licensing documentation is reasonably clear about how cores are licensed, I suggest you read it carefully.

    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 14, 2017 at 2:27 am

    #1928290

  • RE: Massive disk vs. multiple disks?

    Rechana Rajan - Tuesday, February 14, 2017 1:24 AM

    Gail  , you meant to say that single file and multiple files doesnt...

    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 14, 2017 at 2:25 am

    #1928289

Viewing 15 posts - 1,771 through 1,785 (of 49,552 total)