Should've read your reply on Monday morning

The same query with reduced result sets works better with table variable. Try and select top 100 instead of 10000.

I think it greatly depends on the kind of usage the...

We are developing a solution and are analyzing all the possible ways to optimizing query preparation and execution. So as of now I don’t have any issues with my query...

Yeap, asynchronus execution is a good term to describe what I am looking for. The only hitch is that it needs to be on the same connection. 🙁

Eg: Queries Q1 and...

Does a partioned view work only in SQL ENT or will it work the same way in SQL Developer Edition.

I mean I tried to create two tables with the required...

I am facing the same problem. Could this be due to the type of installation, i.e. Enterprise / Standard/ Desktop etc?

Any help would be appreciated.

I tried the query on a table which contains 40K records (not much) which has a PK - clustered. Tried 2 scenarios, the first one in which the column has...

Nice article. Thanks for sharing that information. I particularly liked the conclusion.

Heres wishing all the junkies a Merry Christmas.

May all your dreams and wishes come true.

Nice article. Frankly i was also looking at the explanation of the other heads which are a part of the estimated execution plan.

But this made for a very good reading.

The reason it is not present in 2005, i think, could be because tools like ERwin are much better at both forward & reverse engineering. From what I know we...

Usually when you are considering points of failures for a web 24/7 database you also need to keep in mind other factors like a denial...

That was some very useful info guys. I was trying to setup SQL mail myself, but i had completely overlooked the fact that though my SQL Server was not...