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...

Try putting a check just before the exists, run the proc from management studio and see what you get back.

SELECT @foundFolderId

SELECT * FROM pageList WHERE folderID = @foundFolderId AND...

Multiple separate RAID arrays is best. The log and data files should be physically isolated from one another.

Don't bother. All the log reader tools need the database to be online. Besides, all that you'll...

Exists doesn't return false results.

Are you sure that the variables are such that rows may not exist? Maybe put a statement just above that to insert the rows that...

It's not a new concept. It existed on SQL 2000 as well. Probably 7 too, though I don't have any docs.

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

Significant quotes:

Tail of transaction log

The transactions that have been committed...