At a glance it looks like the cursor is there to enforce an insert into a logging table. Is there any reason why this could not be done with a...

Are you looking for the query to produce the resultset or a way of exporting into a csv format?

Seeing as this is in the 7/2000 forum I would suggest that...

The query appears to be doing table scans on the tables TaxRules and Interface_CorrectionMethods. Ideally you would want to create some clustered indexes on these tables, do you have someone...

Congratulations, I passed it last month see blog entry and after my recent holiday am starting to crack on with 70-450. I can see this becoming addictive!

One of the features of database mirroring in 2008 is automatic page repair which would allow you to restore corrupt pages directly from the copy. If the database were on...

Yin Halen (7/8/2010)

---

Just barely failed the 70-450 test today.

Don't waste your money with the nuggets. They are ok but do not go into the detail you need to pass this...

Have you tried doing comparisons using the SOUNDEX function?

I took and passed the 70-432 exam at the weekend and there were 40 questions, seems pretty low compared to the number listed on the dev track.

As study guides I...

Gianluca Sartori (6/21/2010)

---

Horrible match. Looks like the "world champions" have disappeared.

Just a few notes:

1. Killen should...

You'll need to show what locks you are having the issue with before anybody will be able to help you with as you are just showing "_Total"

We haven't had any issues, you just need to ensure that all keys/certificates are on all physical nodes. The only thing I will say though is that once you enable...

Microsoft have replied to the Connect Issue and have confirmed that they will be changing the documentation about this DMV.

MAPs is very useful, I used it at my current position when I joined to see how big the estate was, one thing to take note of is that it...

Interesting question, it was the alias that almost caught me out. Have seen plenty of attributes named as reserved words in the past which has caused a few issues unless...

After reading Robert's post I rechecked the code and found that the plan handle was not being taken from the procedure_stats DMV but a temporary table I had used to...