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 » SQL Server » performance   (RSS)
  • For the Better Developer: When indexes are not enough

    Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think, also a key point for any developer to have success in future of AI. Here’s the session title and abstract: For the Better Developer: When indexes are not ...
    Posted to Davide Mauri (Weblog) by manowar on October 3, 2017
  • 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
  • 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
  • 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
Privacy Statement