😀 Glad you enjoyed it.

Possibly the stats getting inaccurate. Run an update statistics with fullscan and see if that helps.

Post the stored proc's code?

I would suggest, once...

1204 alone is enough. 3604 is used to direct output of some commands to the client. Good example is...

Enable traceflag 1204 (DBCC TRACEON (1204,-1) or add -T1204 to SQL's startup parameters). That will write the deadlock graph into the error log

The deadlock graph will show you exactly...

If you don't mind the indexes been more fragmented afterwards than they were before the rebuild, then yes, you...

Not much. My .net skills are almost non-existent and I didn't have much trouble with the exam.

Make sure you're familiar with creating assemblies in SQL (CREATE ASSEMBLY ....). Make sure...

Then you should be set. That column value indicates that the log space is not been reused because a log backup is required. Once the log backup runs (check and...

You need to backup the log a lot more than...

I haven't done that course, but I have written the exam. I don't recall any of the .net languages showing up, though you do have to be familiar with creating...

Which course/exam in particular?

ggraber (10/20/2008)

---

That is quite a generalization. If you are reporting off of transactional data, it is a good idea to use NOLOCK because you don't want to lock up the...

Maybe. Try an index there and see if SQL uses it.

Where do you want to put the server name?

Run the query on the server that the backups were made on and replace the placeholder

AND sysdb.name = 'MY_DB_NAME'

with your actual DB...

Yup. Row versioning is used by the DB engine internally, even if Snapshot isolation isn't enabled in any DB. Other things that use row versions:

Online index rebuilds

MARS

http://www.sqlmag.com/Articles/ArticleID/93465/93465.html

You'll need a SQLMag...