THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Database Design » Performance   (RSS)
  • GUID, fragmentation and performance: the eternal flame.

    In the last months a lot of discussion has been done around the topic of GUIDs and their usage as Clustered Keys. We had a very “hot” discussion on that several years in Italy, and looking on the web you can see that this kind of question surface gain periodically. Recently I discussed it also with my friend Thomas. Discussion that gave me some ...
    Posted to Davide Mauri (Weblog) by manowar on April 6, 2014
  • NOSQL- A Quick Overview

    Several attendees at the SQLRally were asking about NoSQL (''Not Only SQL'') and its benefits. This article gives a quick overview: HERE. Also, two good resources have come out from my friend Guy Harrison. This piece on Cassandra, one of the most popular NoSQL databases, was published a while back in Database Trends and Applications Magazine. I ...
    Posted to Kevin Kline (Weblog) by KKline on June 2, 2011
  • Partitioned views

    I must say I am a big fan of views. They give flexibility of changing the logic of the data retrieval without affecting DAL layers in your application. I posted series of articles about updateable views and triggers on views, their application in SSIS for example. Recently we finished development of system that loads data from several external ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 10, 2010
  • In-Memory Databases (IMDBs)

    Moore's Law tells us that CPU's get a LOT faster over time.  Unfortunately for the database professional, all of the secondary elements of our databases DO NOT get a lot faster over time.  Overall, the main methods of storing data since the 1960's, magnetic tape and hard disks, have improved only in the single percentiles year ...
    Posted to Kevin Kline (Weblog) by KKline on June 28, 2010
  • Join Me May 19th for 24 Hours of PASS

    Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May ...
    Posted to Kevin Kline (Weblog) by KKline on April 26, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement