JamesMorrison (12/5/2011)

---

Which 3rd party performance tuning products are the best on the market these days?

I have been informed that I have $10,000 to spend on SQL tools for the purpose...

sp_whoisactive. Amazing freebie you can find on SQLBlog.com. Make sure you find latest version (11.xx last I heard).

1) Here is a great resource for deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

2) The BEST thing you can do is tell the developers to stop using EF. Objects are NOT relational...

Hmm, I think we have a few more...

Based on the questions the OP is asking my best advice is to get a professional on board for a system/performance review because there are some serious gaps in knowledge...

1) I don't EVER want to "learn the hard way" when it comes to HA or DR!! :w00t:

2) I advise my clients to NEVER use maintenance plans. Get...

How many times do we need to ask you for the code that does the insert and select???

Since you gave us absolutely NO information that is useful for us to help you I will take a quick Wild *** Guess and say update statistics on all objects...

znkin (11/28/2011)

---

Thanks all for the replies...

Apart from what was suggested by all would it help if I made a view and transferred all data in a separate table for the...

My guess is that the search query looks something like this:

SELECT...

FROM ...

WHERE (@field1 = Field1 OR @field1 IS NULL)

AND (@field2 = Field2 OR @field2 IS NULL)

...

Do I win a prize?...

That large a T&UPS would likely lead to issues. I do not see where you have upgraded to SP4 yet or checked post SP4 CUs either. I note...

1) this query goes WAY beyond what you can expect help for on a free forum where people donate their time to help others.

2) looks like some Business Objects...

I would try SP4 and also review any CUs for SP4 to see if any bugs fixed by them could be resulting in the behavior you are seeing. ...

Adi Cohn-120898 (11/22/2011)

---

The log backup logged the alter database statement and also modifications to the system’s metadata tables that reflect the database’s modification. It didn't have to copy/backup the...

Thanks for the awesome testing! Seems that the rownumber solution is a fair bit quicker than the tally table solution for larger numbers where the missing value is high...