I'm horrified to know the answer, but it's not the book by Jason Strate and me is it?

If so, I'd love to know, what makes the chapter so...

Sorry, I don't know Sybase.

This forum is for Microsoft SQL Server. You might be better off tracking down a forum for Sybase.

Nuts. Sorry Chris. I didn't realize that wasn't the OP reporting a different problem. My apologies.

You need to do what Chris is suggesting, get the execution plan. We can speculate all day why one query runs faster than another (although DISTINCT is an aggregation function...

I'm prejudiced because I work for Redgate, but I think SQL Doc is exactly what you're looking for.

However, Jeff nailed it as usual. To have a...

Deadlocks are best investigated in a 2012 or greater server through the system_health extended event session which is actively running on all your servers by default. Here's an

No, there are no nobs or ways to adjust the behavior of the native intellisense. You can basically turn it on & off and that's about it. However, double check....

If you want to monitor your queries for performance metrics and you really care about individual calls to those queries, not simply an aggregate average of calls, then the best...

If the data is changing though, statistics that are a year old is concerning. I agree with the approach the Chris has to see what has been modified. However, assuming...