Interesting statement "All indexes are there"

One thing I have noticed over and over again, is many Developers and some DBA's don't really understand how and why indexes are used.

You can...

Ok I have played some more with this and saw one interesting thing

With SET STATISTICS TIME ON

I ran the original query with the 2 CASE statments that is in the...

Yes Dave the article was awesome.

It was almost exactly what I was hoping for when I stated this topic.

It is more on UDF's than on the 2 CASE statements. But...

Good introduction to indexes!

I hope in the 2nd or 3rd you will talk about 2 of my favorite index terms Cardinality and Distribution.

How much ram do you have an the server? How much of that can SQL Server use? Is your SQL Server memory configuration set to dynamically manage RAM? Are there...

That is correct Spotlight does not keep history on running sql.

The alerts by time are great on Spotlight for Oracle but almost useless on SQL SERVER.

I got a blocking event...

Yes the UDF,s are called in the where clause of a select statement.

But changing the queries from using the UDF's would be painful as I do not own the code.

The...

No I do not know the calling procedures. This may be a next step for me.

I am new to this company and have installed spotlight for SQL Server reciently.

Spotlight has...

I am using Spotlight for SQL Server.

I am also using Spotlight for Oracle.

Spotlight for Oracle is the better of the two.

The show query plan xml dump in the SQL Server...