Forum Replies Created

Viewing 15 posts - 7,306 through 7,320 (of 49,552 total)

  • RE: Heap or clustered, What to do ...

    You should have a clustered index. The storage engine is built around tables having clustered indexes.

    Unless you're doing millions of single-row inserts per second, you're unlikely to hit problems...

    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

    November 13, 2014 at 2:34 pm

    #1758408

  • RE: Heap or clustered, What to do ...

    g.britton (11/13/2014)

    SeanNerd (11/13/2014)

    My question is about indexing strategy for the following scenario:

    I have a table where we cannot use the typical int identity primary key column. The table can have...

    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

    November 13, 2014 at 2:32 pm

    #1758407

  • RE: Big O(1) in SQL 2012

    Do you know what O(1) means?

    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

    November 13, 2014 at 12:41 pm

    #1758377

  • RE: Unused indexes, should I delete them?

    dndaughtery (11/13/2014)

    I'm 99% sure that the server hasn't been restarted in a couple months

    And you're absolutely sure that there's no chance they can be used by a business process 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

    November 13, 2014 at 12:39 pm

    #1758376

  • RE: Are the posted questions getting worse?

    rodjkidd (11/13/2014)

    Jack Corbett (11/13/2014)

    Wow, the thread has been quiet lately.

    Had a great time at the PASS Summit last week where I got to see many threadizens....

    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

    November 13, 2014 at 12:25 pm

    #1758369

  • RE: Is there a rule of thumb for number of rows in the partition for a very large table

    Why are you partitioning it? What is the goal?

    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

    November 13, 2014 at 12:24 pm

    #1758368

  • RE: AlwaysON Secondary Full backup?

    What was the command?

    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

    November 13, 2014 at 1:00 am

    #1758150

  • RE: Covering index and parameter order

    Order of parameters in a where clause does not matter

    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

    November 12, 2014 at 10:42 pm

    #1758134

  • RE: AlwaysON Secondary Full backup?

    Why do you think they don't support full backup (which I assume means full database backup)?

    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

    November 12, 2014 at 10:41 pm

    #1758133

  • RE: how to encrupt storedproc in one script.( one go)

    Generate the ALTER scripts for the procs and add WITH ENCRYPTION. No real easy way.

    Bear in mind that it's not actually encryption and it takes someone who knows what they're...

    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

    November 12, 2014 at 10:40 pm

    #1758132

  • RE: Problem with creating a Index on a temp table

    Don't name the constraint. Unlike temp table names, constraint names aren't 'uniqified', so by naming it you're ensuring that it is impossible for two sessions to run that proc at...

    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

    November 12, 2014 at 1:22 pm

    #1758085

  • RE: 823 Error

    Jack Corbett (11/12/2014)

    Yes, since the corruption is in an non-clustered index you can either REBUILD the index or explicitly drop and recreate it.

    You can never rebuild to fix...

    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

    November 12, 2014 at 1:11 pm

    #1758083

  • RE: 823 Error

    Index 1 = clustered index = actual data loss. Restore from last good backup + log backups.

    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

    November 12, 2014 at 1:00 pm

    #1758080

  • RE: Configuring large memory on a SQL instance

    Beautiful. Ok, 4 NUMA nodes, each with 8 physical cores. Try maxdop at 12 to start, 8 and 16 also viable values.

    Before you make assumptions about what apps are 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

    November 12, 2014 at 12:12 pm

    #1758069

  • RE: backup of database

    Jack Corbett (11/12/2014)

    1. Use backup compression

    2. Stripe your backup across multiple files

    3. Change the BUFFERCOUNT

    4. Change the MAXTRANSFERSIZE

    5. Move the data files to faster drives (permanently)

    6. Put 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

    November 12, 2014 at 12:09 pm

    #1758068

Viewing 15 posts - 7,306 through 7,320 (of 49,552 total)