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 » Performance » SQL Server   (RSS)
  • Updated File & Wait Statistics Procedures

              For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some minor modifications that I want others to be aware of. Since many of you have received copies of the past revisions ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • Try-N-Save SSIS Packages

    The Try-N-Save SSIS Packages from my SSIS Dimensional Data Optimization presentation are available at I'm still working on getting the sample database uploaded - even compressed a backup is larger than SkyDrive's upload filesize limit. I'll script it out when ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 29, 2010
  • Moving on up… but not to the East Side

    It is with both sadness and excitement that I am announcing I am leaving my position as Senior Data Architect at OTO Labs. The sadness comes because I am leaving behind a great company and an outstanding team, many of whom I am quite happy to consider friends rather than co-workers.   This decision was not easy; I spent several days and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 18, 2010
  • Watch those clustered indexes

    I had a discussion with a friend in Microsoft  IT this morning, and as we were evaluating some query plans we ran into more clustered index woes. Remember that clustered indexes affect the base table itself (which is why there can be only one) and are expensive to update. They are fantastic for reading data, but you need to carefully evaluate ...
    Posted to Buck Woody (Weblog) by BuckWoody on August 11, 2010
  • Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)

    While at the PASS Community Summit in November 2008, I had the pleasure of attending a handful of excellent presentations.  One of the best was delivered by Mike Ruthruff (& not just because he shilled for my presentation on disk partition alignment later that day—though I suspect he contributed to my session being SRO). Mike is a ...
    Posted to Jimmy May (Weblog) by aspiringgeek on March 1, 2009
  • Filegroups Part I-a: Dividing for Performance (a partial rant)

    In my previous post on filegroups, I tried to make the case that using filegroups (please everyone tell me you use other filegroups than PRIMARY...) can improve database performance. I received a number of comments challenging that notion, which personally I find wonderful - disagreement and real arguing ( no Monty Python  ''This isn't an ...
    Posted to James Luetkehoelter (Weblog) by James Luetkehoelter on December 18, 2007
  • Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

    You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those in a lookup table and then you create another table where you store all the categories for each customer. What if I tell you that you can store all that info in 1 row instead of 10 rows if a customer picked 10 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on May 29, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement