Poor summary about column considerations in an index. For the complete picture, I suggest

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

You can only judge if an index is well-used if it has some statistics (about hits and updates). If an index doen't exists in the DM view, it doesn't say...

The answer was already given on the SQLTeam site by Saggi Neumann:

Since the DMV sys.dm_db_index_usage_stats also tracks changes in indexes (not only seeks and scans) in the user_updates column, it...

Since I'm a DBA, i'm only interested in...

5/5: New version deployed

- FILEGROUP_NAME() function implemented (actually ... discovered :Whistling:)

- removed join to sysindexes (not used)

Waiting for approval!

WOW! :w00t::w00t: that was an easy one! Sometimes you're working on a solution which can be replaced by a very few lines ( I feel stupid :ermm::ermm::ermm: )

Have a drink...

It's how you define pressure: I was considering a negative pressure as no pressure (I had to explain that :unsure: ).

Another update! I was triggered by the Question of the day

. (The answer is yes 😀 )

So I moved the select part...

Another update:

- new columns: perc_seeks, perc_scans, perc_lookups. these columns represents the index method represented as a percentage

- The ratio calculation is changed: Since a lookup is better than a seek...

Another minor modification: indexes with only updates and no hits now have a negative ratio (instead of 0). The ratio calculation for those indexes is updates * -1.

For those of...

aha! make sure "results to text" is selected 🙂

I just posted an updated version (waiting for approval, so be patient). I removed the join to sysobjects (thanks to Jason who pointed to this). I replaced the <TAB> character...

Which commands and in which order do I have to execute to stop/remove this trace?

crainlee2 (3/29/2010)

---

Wilfred,

What is the purpose of this elaborate query?

(NOTE: I have commented out the ALTER INDEX (DISABLE) statement until I get an explanation of what the query is supposed...

Nested tasks not possible?

Situation: from a main routine, I execute a subroutine with sp_exec. inside this subroutine, some calculations are done (a generated SQL statment). If I execute this SQL...