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 » indexes   (RSS)
Showing page 1 of 2 (15 total posts)
  • Updated sp_indexinfo

    It was time to give sp_indexinfo some love. The procedure is meant to be the ''ultimate'' index information procedure, providing lots of information about all indexes in a database or all indexes for a certain table. Here is what I did in this update:Changed the second query that retrieves missing index information so it generates the index name ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on May 22, 2014
  • Speaking at the Charlotte Users Group

      I will be giving a presentation in between Earthquakes and Hurricanes in Charlotte NC. this Wednesday the 31st of August on Understanding Indexes in SQL Server 2008. If you are in the area please drop by and say hello. You can find out more information and register for the event here. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on August 26, 2011
  • SQL Server, Seeks, and Binary Search

    The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks: In test 1, making the clustered index unique improved performance by around 40%. In test 2, making the same change reduced performance by around 70% (on 64-bit systems – more on that later).  ...
    Posted to Page Free Space (Weblog) by Paul White on August 8, 2011
  • Ola Hallengren's maint procedures now supports exclusions

    Ola has a set of stored procedures to do maint operations, see http://ola.hallengren.com/. Ola has now updated them to support exclusions or inclusions of tables, indexes or even whole schemas from index rebuild/reorg. Check out http://ola.hallengren.com/Documentation.html#SelectingIndexes for info on how to define exclusions and ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 9, 2010
  • How selective do we need to be for an index to be used?

    You know the answer already: It depends. But I often see some percentage value quoted and the point of this post is to show that there is no such percentage value. To get the most out of this blog post, you should understand the basic structure for an index, i.e. how the b+ tree look like. You should also understand the difference between a ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 1, 2010
  • Adding a PK online?

    I just read in a forum about a user who want to replikate a table, but the table doesn't have a PK. The table is pretty large, and having the table not available while adding the PK is undesireable. The table has a clustered index already, and there are other columns which are known to be unique (presence of unique indexes). What I ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on January 13, 2010
  • Heaps, forwarding pointers, ALTER TABLE REBUILD and non-clustered indexes

    Let's start with some background on forwarding pointers: Forwarding pointers in heaps can be a mess to get rid of. A forwarding pointer happens when you modify a row so that the row doesn't fit on the same page anymore. SQL Server moves the row to a new page and leaves a forwarding pointer where the old row used to be. This means that ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 28, 2009
  • Automating dm_exec_query_stats and dm_db_index_usage_stats analysis

    Everyone should know by now how really useful the DMVs dm_exec_query_stats, and dm_db_index_usage_stats and the associated DMFs for obtaining the SQL and XML plan: dm_exec_sql_text, dm_exec_query_plan, and dm_exec_text_query_plan. Of course it has been explained that dm_exec_query_stats is not a replacement for SQL Server Profiler and SQL Trace. ...
    Posted to Joe Chang (Weblog) by jchang on June 22, 2009
  • 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
  • Sp_indexinfo updated

    For a long while, I've had a few things I wanted to add for sp_indexinfo (my procedure which returns bunch of information for indexes). Dejan Sarka suggested adding XML indexes as well as making the column list look nicer. I've also had a request to add some documentation of what the procedure returns. Done. ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on February 18, 2009
1 2 Next >
Privacy Statement