Nice! 🙂 I got it as i have been playing around with Unions lately. But i could not undertand what makes a difference when it is executed on SQL Server...

Very Interesting dabate just got started! Cheers Andy!

Well, mine is playing guitar, even sometimes when i'm hitting the bottom rock of some db with findings of very high logical reads,...

OCTom (5/26/2010)

---

TravisDBA ,

It could very well be that they didn't care.

They talked a good game, though. The way they presented themselves to the public made it look like they were...

🙂

i chose the last answer, cause this is what happend to me. But my answer is wrong. I don't understand. what I'm missing here?

Regards,

Mazhar Karimi

Agree, normally in Pakistan all IT pros work 57 hours a week. Official timings are 9 to 6 Or 10 to 7, and almost 75% people work more than that...

very interesting, this table alias in select clause got me puzzled for a moment. 🙂

very coo! 🙂

I got it right as i knew that <> null doesn't work in that scenario, but if one would use 'is not null' instead of <> null, it would get...

Agree, implementation of proper indexes is a continous process, thats a big part of indexing strategy, you put some indexes, run some load test, get the results, compare with the...

Another thing, you can also eliminate the rarely used index with the help of statistics.

Select ObjectName=object_name(s.object_id)

...

based on the statistics, Sql server maintain suggestions itself, you can query from a DMV like...

SELECT user_seeks * avg_total_user_cost * (avg_user_impact * 0.01) AS [index_advantage],

migs.last_user_seek, mid.[statement] AS [Database.Schema.Table],

mid.equality_columns, mid.inequality_columns,...