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 » Performance » SQL Server   (RSS)
Showing page 1 of 2 (11 total posts)
  • SQL Nexus 5.5.0.1

      The SQL Nexus set of utilities are some of the most under utilized tools available to the SQL Server community. I used and touted the RML utility for many years to help people analyze trace information very fast and easily. Eventually XE traces were added to the list along with much more.  This blog post link will give you a pretty ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 20, 2016
  • SQL Server Hardware

    From Red-Gate website you can download (for free) the ebook SQL Server Hardware written by Glenn Berry (@GlennAlanBerry). This ebook will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on October 29, 2014
  • Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security

    Preamble This is the second in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in my big deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide an ...
    Posted to Jimmy May (Weblog) by aspiringgeek on May 26, 2014
  • Columnstore Case Study #1: MSIT SONAR Aggregations

    Preamble This is the first in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in this deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide an easy-to-consume ...
    Posted to Jimmy May (Weblog) by aspiringgeek on May 19, 2014
  • Updated File & Wait Statistics Procedures

              Please note that I have a newer version of these procedures that you can find herehttp://sqlblog.com/blogs/andrew_kelly/archive/2015/09/02/revised-file-wait-statistics-procedures.aspx .  For many years I have been using a set of stored procedures to capture and report on both ...
    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 http://cid-8f7e6c950afc6b3e.office.live.com/self.aspx/.Public/Presentation/TryNSave.zip. 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
1 2 Next >
Privacy Statement