Forum Replies Created

Viewing 5 posts - 136 through 141 (of 141 total)

  • RE: Stairway to SQL Server Indexes: Step 4, Pages and Extents

    Nice article! Just one tweak:

    "If one page in an extent is owned by TableA or IndexB, all eight pages will be owned by that same object. An exception...

  • RE: Come Vacation on the SQL Cruise

    Hahaha, yeah, Alaska & the West Coast are probably coming soon. Ideally, I'd like to do a spring/summer one out of Seattle to Alaska, and a fall/winter one in the...

  • RE: Backup database structure and schema only

    DAC Packs aren't a solution, though, because they only support a subset of schema objects. For example, you can't include certain datatypes or stored procedures. Thanks for the...

  • RE: disk size

    As far as 3rd party backup tools there are so many available but I have worked only with SQLLItespeed and Hyperbac so I can talk about this. Advantage with...

  • RE: DBCC updateusage and sp_updatestat

    If you run sp_updatestats without specifying a sampling ratio, it won't do a full scan of the tables to calculate the statistics. It'll use your default sampling ratio, which...

Viewing 5 posts - 136 through 141 (of 141 total)