Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: MySQL Primer for the SQL Sever DBA

    I've seen issues building indexes on large tables taking excessive amounts of time on anything over 50 GB keys. As I understand it this is do to the sorting...

  • RE: MySQL Primer for the SQL Sever DBA

    Mysql does get into trouble with larger datasets, and there is a lot of hacking you need to do. If your talking about single instances of Mysql in a...

  • RE: Database Snapshots

    The way snapshots work is they use both a sparse file and the original data source. If you have a table t1, and an update occurs to one row...

  • RE: Patindex

    I'd be a a little concerned about the performance implications of using this function, what's been your experience on cpu impact.

  • RE: MySQL Primer for the SQL Sever DBA

    As a reply to the large datasets, myisam grew out the data warehouse world and understand it can handle large datasets. However the comment is based on the experience...

Viewing 5 posts - 1 through 5 (of 5 total)