This is a good example of whey it isn't a good idea to do any sort of linked server activities inside a trigger. It would be easier to maintain...

Francis,

I've worked with a POS (Point Of Sale) system that uses text stored in tables for use in Dynamic SQL. It's mostly for appending to the WHERE clause (filtering)...

sam-1083699 (8/29/2011)

---

I need to select all columns so you suggest me to write a select statement with all columns instead of select * ??

and the reason i created non-clustered...

Hans,

Are you sure the index hasn't been disabled? Since the query is a TOP 1, it really should have used the index for a seek, even if there aren't...

ChrisM@Work (8/23/2011)

---

Put it into a stored procedure. Crystal works fine with them, the performance is likely to be better, and there will be no temptation for folks to attempt to...

Christi,

Another big addition is error handling. Be sure to look up TRY/CATCH blocks. I use them religiously.

Todd Fifield

Here is an example of using a calendar table as the 'Anchor' to the query. This particular example uses a day type table and the days when nothing happened...

Joe90-646727 (2/19/2008)

---

Hi there,

this seems like it should be simple, but is a little frustrating!

I have an sp which takes a list of keys like "12,13,14,15,16" as a varchar param.

I would...

Ninja's_RGR'us (8/19/2011)

---

ChrisM@Work (8/19/2011)

---

Just as easy...

Just to add my 2 cents. I've found that identity columns for both clustering key and primary key to be very, very fast when doing complex queries, and as...

nageshp,

This is not really a strange case at all. I've seen it sometimes where the left table will only have rows that correspond to the right table. This...

Ninja's_RGR'us (8/12/2011)

---

All you need to do is answer how can the optimzer stop at only 15 rows knowing that sorting is a blocking operator (nothing else can run untill that...

Bruce,

If you think about it, ROW_NUMBER() probably has to touch each row...

Sometimes I find that using a CROSS APPLY works out better than row numbering performance wise.

Here's your code with a CROSS APPLY to the ManualHubodometerReading instead of a JOIN:

select

at.AssetID,

at.CustomerIdentifier as...

I'm a fan of SubVersion (aka tortoise SVN) for source control. It makes versioning very easy. I have most of my clients also set up with SubVersion. ...