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   (RSS)
Showing page 1 of 10 (98 total posts)
  • 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
  • ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

    Great Articles at SQLPerformance.comThere are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as we look back:Troubleshooting SQL Server CPU Performance IssuesThis outstanding ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 2015
  • Off to Richmond for SQL Saturday

    I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the ...
    Posted to Louis Davidson (Weblog) by drsql on March 13, 2015
  • SQL Saturday Birmingham #328 Database Design Precon In One Week

    On *August 22, I will be doing my ''How to Design a Relational Database'' pre-conference session in Birmingham, Alabama. You can see the abstract here if you are interested, and you can sign up there too, naturally. At just $100, which includes a free ebook copy of my database design book, it is a great bargain and I totally promise it will ...
    Posted to Louis Davidson (Weblog) by drsql on August 14, 2014
  • How In-Memory Database Objects Affect Database Design: Uniqueness

    This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on the prefix of this blog's title. It is a work in progress as I explore the effects of the new in-memory model. I would love comments that tell me that I am wrong (especially if it turns out that I am!) The first issue that arose in my ...
    Posted to Louis Davidson (Weblog) by drsql on July 6, 2014
  • How In-Memory Database Objects Affect Database Design: Or does it?

    This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on the prefix of this blog's title. It is a work in progress as I explore the effects of the new in-memory model. I would love comments that tell me that I am wrong (especially if it turns out that I am!)  Before ...
    Posted to Louis Davidson (Weblog) by drsql on June 30, 2014
  • How In-Memory Database Objects Affect Database Design: The Logical and Physical Models

    This part is part of an ongoing series of blogs I am writing while preparing to give a presentation based on the prefix of this blog's title. It is a work in progress as I explore the effects of the new in-memory model. I would love comments that tell me that I am wrong (especially if it turns out that I ...
    Posted to Louis Davidson (Weblog) by drsql on June 28, 2014
  • Speaking this weekend at SQL Saturday 286 - Louisville

    Wow, where does the time go? Hope I see every reader there in Louisville this weekend for a lovely time. Say you live in Alaska and it would be too far to go in one day? Hey, we all have our problems (and don't tell anyone, but I am going to try to finish up video versions of these sessions by the end of the year.. shh.) I will be doing my ...
    Posted to Louis Davidson (Weblog) by drsql on June 19, 2014
  • Speaking this week at Richmond SQL Server User Group

    Thursday night, at 6:00 (or so) I will be speaking in Richmond (http://richmondsql.org/cs2007/ ), talking about How to Implement a Hierarchy using SQL Server. The abstract is: One of the most common structures you will come across in the real world is a hierarchy (either a single parent ''tree'' or a multi-parent ''graph''). Many systems ...
    Posted to Louis Davidson (Weblog) by drsql on June 8, 2014
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement