WOW not sure where to begin with this. You should start by reading Gail's blog about catch all queries. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

It actually looks like you have probably read parts of this....

Why all the join hints? Do you know what they do? Can you explain and justify very clearly why you need them? (to make it faster does not count, you...

Oh....are you trying to connect via remote desktop for administration?

So no error message? How do you know it doesn't connect?

Well you can't use a subquery in CONTAINS like that. What exactly are you trying to do here? This looks like part of where clause in dynamic sql but your...

So is this a question or just explaining how you fixed it?

Do you get an error message? Is the sql service running?

Jeff Moden (5/24/2012)

---

dwain.c (5/24/2012)

---

Jeff - I've been a fan of this splitter for a long time even though I've been a slow adopter, 🙂 recommending it highly around my office...

Do these jobs call stored procs? It could possibly be parameter sniffing.

ananda.murugesan (6/20/2012)

---

as of now all the database sql 2008 collation is SQL_Latin1_General_CP1_CI_AS but still database user password working as case senstive only.. how to reslove user password case insenstive? which...

mvillegascuellar (6/19/2012)

---

Sean Lange (6/19/2012)

---

That is a bit vague in requirement but there are some things you can do. Are these queries pass through queries or stored procs? That will make...

This works on your sample data. I added the outer query because at least in your sample data the first row has a Event_Type_Id = 3. In the real data...

Excellent!!! Glad you get it working and thanks for letting me know. Super cool of you to post your solution so others can glean some info from your hard work....

Grant Fritchey (6/19/2012)

---

All the hints included in a query are stored with the execution plan, so you could query the plans, using XML, to pull the information out of the...

That is a bit vague in requirement but there are some things you can do. Are these queries pass through queries or stored procs? That will make a big difference...