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 » Indexes » Tools   (RSS)
  • Update to Rules-Driven Maintenance

    Back in August I posted a first version of a rules-driven solution for backups, index and statistics maintenance and integrity checks. The system in general has been working well, and has saved my team a huge amount of time and effort. We are coming to the anniversary of its use in production soon. Today I offer an update that contains a few ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 16, 2013
  • Another bugfix for sp_indexinfo

    JackMcC reported correctly at that sp_indexinfo will count rows double (or even tripple) if there are lob or row overflow allocations. Now fixed. Thanks Jack.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 9, 2010
  • Match those types!

    This is a recommendation I believe is worth repeating from time to time: Make sure you match data types when you write TSQL code. Else you in most cases end up with an implicit data type conversion. And in worst case, this conversion is performed at the column side - not the literal side of your query. What does that mean? Consider below: WHERE ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 28, 2009
  • Geek City: Included Columns

    When an issue comes up more than once in a short period of time, I figure it is a message from the Universe. I might even assume it is a gift of blog fodder. So I won't turn down the gift, even if it means another juicy post before the end of year, much to Denis' disappointment. The issue is SQL Server 2005 ''Included Columns''. There was a post ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 31, 2007
Privacy Statement