THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Design » DBA » SQL Programming   (RSS)
  • ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

    Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White ...
    Posted to Kevin Kline (Weblog) by KKline on March 30, 2015
  • MySQL, NoSQL, and NuoDB

    I've been keen on MySQL ever since I first started using it heavily more than a decade ago.  In fact, I liked it well enough to include it as one of the four main database platforms, over and above the ANSI-ISO SQL standard, in my popular book SQL in a Nutshell. However, with the advent of NoSQL data platforms in the last few years, ...
    Posted to Kevin Kline (Weblog) by KKline on July 8, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement