Grant Fritchey (5/3/2010)

GilaMonster (5/3/2010)

Why? SQL won't recompile when a different branch...

Why? SQL won't recompile when a different branch is taken. It'll...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Why do you have DropCleanBuffers at the beginning? Is that just there for performance testing?

You may also be running...

Means there's likely some blocking...

So why does the client want you to do it if they know that you know almost nothing about databases? Better to get someone in who does.

From your requirements, there's...

Blog post on rebuilding master - http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/rebuild-master-and-restore-system-databa

Rebuild the master database. It's an option of the 2005 setup tool. You will lose all logins and server level permissions, you'll have to reattach all user databases, you'll lose...

If the file header is damaged, the database cannot be opened. That's one of the things that there's no workaround for.

Unfortunately , working on thesis != relaxing. Still break from forums was good and needed.

I am. Took a complete break for 2 weeks, posting just a little now. Down to 100 posts a month (from 700)

Why are you using a cursor in the first place? They are slow, slower than set-based operations in the vast majority of cases.

I can see that this is test code....

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Depends on the company. They are not industry-wide definitions.

Indeed. And reading SQL's transaction log is a really odd thing to ask in a class exercise. If the exercise just asks you to track data changes, it's pretty unlikely...

Please post the current execution plan of the query with OR? I suspect it may have to do with covering and number of records as it looks like it should...