I meant to ask you that does the optimizer always process the two tables/queries separately (i.e. not a row-by-row process as you've mentioned) and do a equality join, similar to...

Thanks guys, I've just verified it in Books Online...

The only obvious reason I am thinking of is that the optimizer has to do a "Scalar Operation" on RANK() & ROW_NUMBER() whereas "Aggreagate Operation" on MIN() function....

GilaMonster (1/16/2009)

---

Ramesh (1/16/2009)

---

So, if the database is not in production or you don't need any information from the logs then you can simply hrink the database, and take...

GilaMonster (1/16/2009)

---

The optimiser can handle most correlated subqueries just fine. If the comparison with the outer query is...

Strange, I never came across this situation. Its kind a stupid question, but it's that you see the reporting services option in component selection but in disabled state?

Or 'till we get "Overflow", "Truncate" errors:D

"reserved space" is actually the amount of space allocated by objects in the database. So, if the database is not in production or you don't need any information from...

You are using correlated sub-queries, which is another form of RBAR..., to know more about RBAR and its performance implications see http://www.sqlservercentral.com/links/276514/84234.

Based on the query, what I understood is that...

Do you see "Reporting Services Configuration" in "Configuration Tools"?

Guys,

I've been reading the thread from the start, its been so exciting to read that I just can't resist myself joinin' in.:D

Can you believe that this thread...

I believe all editions except Express Edition (without Advanced Services) support reporting services and the components are available in the installation itself.

Well, it means that the query SQL is executing didn't complete in the predefined configured time.

This SP on the remote Server hasn't been changed and the SP is executing fine...

Actually, PIVOT is available in all editions..., check BOL for comparisons of edition...

Which examples have you tried? What error do you get when executing those samples?

Does the...

I am not if I've understood what you said and want, but if you want to restrict the clients from viewing/editing the procedures at their end after deploying then what...