Why is this a sql centric solution? Would performance be further improved with some C# code on an application server doing the xml heaving lifting?

Thank you so much Perry. This is one of best articles written in a while. VERY RELEVANT!!

one flaw would be ORDER BY and TOP. Check this out:

Check this out

http://blogs.msdn.com/queryoptteam/archive/2006/03/24/560396.aspx

Your point #2 is always where I get my best performance. Even if I persist the output to a physical file on the web server. I have not found a...

This is another example of great free content delivered on SQLServerCentral. Thank you Mr.Hines.

My current position is at a large manufacturing firm with a web front end. Currently our data...

The xml is very complicated. It is barley xml in my opinion. Name value pair with formatting tags. No scheam can be geneated to benefit from an xml index attempt....

Sergiy, I could not agree with you more. I am making enroads here on turning our philosphy around. The XML native datatype has been a setback for me, but...

You cannot have reporting running real time off your session DB in production.

I think one week is way to long before archiving that data. We archive ours every five...

My guess is it involves maybe the replication monitor. This may explain why it takes so much time to load the repl monitor for us. If I find anything...

Great info.

I see a lot of these in all my environments:

CREATE INDEX [missing_index_537_536_MSdistribution_history] ON [distribution].[dbo].[MSdistribution_history] ([agent_id],[time]) INCLUDE ([runstatus], [start_time], [timestamp])

Looks like replication needs some help, but fear would not...

Great stuff here everyone. Thanks OP!!!!! 😀

Do you know if their is a 64bit client?

Again, how in the world is enabling full text search on a server that already has performance issues helping anything. I would argue there is a good chance running full...

Ditto. But be assured, the right setup of SQL Server will meet this requirement very well. There are many concerns at every tier to make this work.

Maybe consider rolling your own DDL trigger functionality.