Not quite. It will consider all queries whose execution plans are still in cache. As soon...

It's a profiler event. Under the Stored Procedures group. It traces each statement within a proc. It can get intensive so make...

Sure. Add the NoRecovery option to the log backup statement along with no_truncate.

The...

I don't understand exactly what you're saying.

If you have space constraints, get more space. Repeatedly shrinking the dataabse and log (and having them grow again) will cause index fragmentation, internal...

Sure. Tonnes

Try these for starters:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

shekihan (11/24/2008)

---

However my experiments with Query Analyzer (SQL Server 2005) confirm that regardless of whatever order you use in JOIN there is no difference in query plans! From here out...

That's not a decrease. 1.3e+010 is scientific notation...

Windows groups are best. Get the developers added to a windows group, grant that group a login to SQL. Create roles for permissions and add those roles to the group.

Make...

How big were the tables in question?

Small tables don't show changes in fragmentation, and there's no need to worry about fragmentation on small tables. (~100 pages)

Nov 3-6 2009, Seattle.

Stick a print or select inside the IF block, see if that prints out, or if the update is coming from somewhere else.

You can also trace the exact steps that...

Check the Total Working Sets counter in perfmon. See if the total working set of all processes decreases or if it remains steady when this happens.

What else is running on...

It prints results on each execution? Means that the exists is correct, there are always rows.

Couple more recommendations

Chat with other people between sessions. Everyone has something that they can teach you, and you can make friends that you can chat with long after the conference

Chat...

The first problem is that you have two table scans. Second problem is that you're getting a hash join because you have no indexes.

Add indexes to support the join and/or...