You could turn on profiler or, better still, extended events to capture the query executions that are occurring. But, there's a way to look at what was going on at...

Ha!

Well developers have their cross to bear as well as us. I get it. Entirely. However, I'm pretty sure, based on the info provided, that's where the problem lies.

A bunch of things going on with this one. First off, you're joining on views, which presumably have multiple tables joining together within them. That would reflect in the high...

Generally, but not always, instead of IN I would be doing a JOIN. The optimizer might interpret it that way any for you. Since you're going for matching records that...

It could be any number of things. Your best bet is to look at the error log and the execution log of your mirroring operation in SQL Agent. There's no...

I don't think there's a standard answer for either question. Auditing requirements are either a business or legal requirement. If the business you're working with doesn't need auditing, there's no...

I've been using Access as a front-end for Windows Azure SQL Database for a project for the Boy Scouts. It works well enough. You can get going pretty quickly. There...

Because you're using LIKE and the wild cards around a space, it's going to find every single record that matches up on any value that contains a space. You could...

You sure there's not something else at work here? I just tested your code and it's working fine. There's no intervening code of any kind?

Yeah, no real way to tell you how to improve a query without seeing that query. Imagine I said my car wasn't running well and asked you to fix it......

For error number one, it sounds like you're trying to cast something from a varchar to a date that can't be converted. For example '3 March 2013' can be, but...

I'm nominating ChrisM@Work for saint hood.

And, he should be charging for the amount of work he's doing for one company in India. A lot.

tony28 (5/8/2013)

---

here is simple select, I found in little difficult, but here you can see also

subtree cost

IX 0,0032838...

For an immediate snapshot for what's going on, INPUT_BUFFER is very SQL Server 2000. Switch to the Dynamic Management Objects such as sys.dm_exec_requests and sys.dm_exec_query_stats as the previous poster said....

Without the plan itself (saved & posted as XML as the previous poster said) it's hard to make serious suggestions to you. But, the one thing I can tell you,...