Orlando,

There is another situation where even if recursive triggers is turned off in the database, you can still get recursion from what I call cross-firing triggers. That is when...

Rudolf,

Gail Shaw wrote and excellent series of articles covering IN vs. Exists, NOT EXISTS vs. LEFT JOIN.

You should take a look:

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

Todd Fifield

sclements,

Any time you join from a parent table to a child table that has multiple rows per parent, you get the child number of rows in the query. That's...

Antonio,

Here is a solution that is a bit easier to read than Cadavre's solution. It doesn't perform quite as well on large record sets, however.

It's just another option.

CREATE TABLE...

Emmet,

You need to post the DDL for the tables involved and some sample data for the tables. Also we don't have an idea as to what the variables are...

As Rich said before, you want to use a time based table as the anchor and left join to the real data.

Here's an article with an example of using a...

Gerald,

If you want something like comparing the current year to the same period in the prior year, setting up a proper calendar table would immensely help out with the heavy...

Ken,

You're on the right path if you select from the OPENQUERY into a temp table and use that from there on out. I found out long ago that doing...

CXPACKET waits are usually more related to IO than anything else from my experience - a thread is waiting for IO to complete.

I find it hard to believe...

I recall seeing 2 instances of this. The clients went from 2000 to 2005 and a few queries performed poorly. Full index rebuilds were done in both cases...

Vijay,

For this type of complicated WHERE clause containing many OR type conditions, I've found I can usually get better performance by doing several queries with a UNION. If the...

Rafi,

The first thing I noticed about the execution plan was a clustered index scan (same as a table scan) on the tfsReceipt table. If you have an index on...

mgchris (1/20/2012)

---

Creating a #table to look through the inserted and deleted table when dealing with hundreds of thousands of entries an hour would be a beast on resources and not...

Actually the test IF UPDATE(ColA) will always test true for an INSERT (if the trigger happens to be for both UPDATE and INSERT) and will always test true if ColA...

My 2 cents on query designers. I'm not a huge fan of them for SQL Server. They are about the only place I've ever seen a RIGHT JOIN...