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,...

All the enhancements around extended events are pretty excellent. I'm also enamored of the distributed replay mechanism (although I wish it worked with extended events too). Availability Groups are extremely...

todd.ayers (5/7/2013)

---

ok...

minimal Access experience / No SQL experience and I am going to assume no app dev skills either...correct?

you talk about existing databases...what platform are these currently on...who currently manages...

Well, there's the rub. There isn't both an easy and effective way...

Sean Lange (5/7/2013)

---

Grant Fritchey (5/7/2013)

---

Funny you should ask this because the newest version of Access is running SQL Server. The Jet engine is gone. It's just a really fancy GUI...