I got that old feeling last year when Joey Ramone died... Now it's starting to feel like a conspiracy. I wasn't really a fan of Aspirin, but the others... This...

I've been very happy with ER/Studio, but we mainly use it for documentation. All the management stuff that comes with it haven't worked out for us.

Actually no, it's not that weird. The optimizer and the query engine are pretty amazing pieces of engineering. They're able to identify that you only need a single row returned...

The key problem is, desiging, building and deploying software is still not an act of engineering like building a car, a toaster or a bridge. As Steve pointed out in...

I outlined a way to hook stuff out of the cached execution plans over here. It's not magic or anything, but you're going to have a tough time assessing what's...

OK. I'm stumped. I tried mucking with the indexes and loading the data into a temp table. The temp table fixed the query time on the sort, but it took...

You'd have to show sample code and structure (and preferably some sample data) in order to get really detailed help.

Read this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

I'm doing about 35 miles each way here in the US. The trick I've found that works is to come in early and leave early. Avoid the common commute times....

It really sounds like you're trying to generate reports.

I'd suggest one of two options, first, use a reporting tool, like the Reporting Services tool that comes with SQL Server or...

Personally, I'd go with option 2. That way, you don't have to worry about spelling and, when another state, "suspended" or something, comes along, you're ready and won't have to...

We get these debates where I work a lot. For some reason, many of my fellow DBA's believe that every known bug has to be addressed prior to release or...

May as well pile on to this one...

It's not a problem. Half the time when I type up the question to post it up here when I'm stuck, the act...

Not to mention, is there more than one access path? Can people modify the values after they've been entered? If so, are there triggers in place to account for that...

HA!

And I thought you meant Quality Face Time...

Oh jeez. The internet has let me down... again...

:alien:

I had to go and look QFT up. :ermm:

See, even when you're not teaching, you're teaching. There's a darn good reason you're an MVP.