1. Don't use EM for building queries. Especially complex ones.

Including ones containing GROUP BY clause.

2. Replace HAVING clause with WHERE.

Minimise calls to linked server. Everywhere you need remote data call one of local SP's (very limited number of them) which access remote server.

Place all calls to linked server in...

The problems with his assertions is that is that there are indeed precise values.

There are no precise decimal numbers.

1/8th of a dollar is precisely .125.

1/8th of a...

Jeff,

by the way, if to go to extreme performance tuning you need to locate all your databases on raw partitions.

They are faster.

But how many of you databases use it?

William, you've got it wrong.

I just think that taking a 10:1 performance hit for the sake of code reuse is a bit much no matter how big or small a database may be.

As one...

Jeff, you're comparing to the wrong thing.

To be closer to real life you should compare performance of function vs. something what would be used by normal developers.

Like this:

select Left(GetDate(),11)

simply because...

Jeff, we've done it once together. Here, on this forum.

Indexes computed column using dateadd/datediff function.

You must remember that issue with implicit conversion of 0 to date which made that function...

It was long topic here about it, and we did plenty of exercises there.

All methods involving conversions were slower.

Method using conversion to FLOAT was in my library before that, and...

Seems impossible.

Different SysID values are trying to access different segments of the table, so they cannot block each other.

Or you don't show full query.

Or there is another, third query.

What about indexes?

It would be helpful to have clustered index on (SysID, Trans_no, Location_ID)

So, why you need quotes?

OK, black box,

but how XML ends up in the table?

You may use Profiler to catch the process storing XML.

If it uses some SP you may call another SP (created...

> --- If I use datetime datatype it saves the data in the following format 'April 4 2007' where as i want it to display '04/04/07'.

Wrong.

It does not save...

> Works for me.

Really?

Then who was writing this:

Replaced all the float declares with decimal(38,20) but I still get bad results?

Here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=370393

Well I've been in IT for 20 years, so...