There are basically two good ways to get query metrics out of the system. You can query the cache and see what's there for query performance, or you can audit...

Yeah, just run a query on the server that uses RAISEERROR and the appropriate error level. Nothing else needed. It won't hurt the server or any processes on the server.

Any login can have a query that causes blocking. That's just how SQL Server works. Based on what you've described, that's about all I can see. To minimize blocking, go...

Looking it over, the only hope for tuning is, as was already pointed out, to eliminate the key lookup. Otherwise, we're just processing a lot of data and that's going...

Access.

But seriously, Access & ODBC and... yeah... Access.

There must be differences. No such thing as magic. Differing data sets leading to an error, maybe corruption on that database, something. Keep looking and look in and around settings...

If the same code doesn't work, then I'd start checking settings. First, default ANSI settings on the server. Collation on the server and the database. Also check collation on tempdb....

It's usually not a network problem, but it might be. It's usually an issue where the client code is doing row-by-row processing. There is no other wait occurring. It's literally...

UNION is an aggregate function that is basically going to give you unique values. If you want to eliminate them from the query any other way, it's probably through having...

And remember, those costs are just estimated values. They don't represent a literal real-world performance metric. It's just a measure of what the optimizer thinks a given operation will cost...

OK. Have you checked the error logs, both SQL Server and Windows? I can't really suggest a whole lot more than that without more details than that you have an...

KWymore (1/15/2014)

---

I have worked with many in the past who did just enough to get by and rarely pushed themselves to provide anything beyond the bare necessities. I was always...

below86 (1/15/2014)

---

I agree that I've looked at what I've done 2/5/10 years ago and think "what the 'H' was I thinking". And yes you would love to go back...

I agree on the number of students. Also, what's the difference between student_pk and student_id? Seems like one or the other isn't needed unless the ID is some sort of...

I'm actually a little shocked at some of the responses from the editorial. I thought the editorial was absolutely spot on.

For all those who think that you shouldn't be striving...