There's not enough information to answer this question fully. Yes, you need to use JOIN's to put the tables together, but what columns constitute the primary and foreign keys that...

Rather than changing the locking mechanisms everywhere, I'd strongly suggest looking at the execution plans of the query and the indexes on your tables. Resolve the problems at the root,...

If my understanding of what you're trying to do is correct, then yeah, I think that's the right code. But please, test it and verify it. Don't simply take my...

I know Steve emphasized hitting pads as a way to take off the stress, but I don't mind suggesting, if you don't object to a few bruises (and jambed fingers...

If I'm reading this correctly, something like this:

SELECT wcadmin.WTDocumentMaster.WTDocumentNumber AS NUMBER, wcadmin.WTdocument.nameB2folderingInfo AS FOLDER,

...

Something along these lines should work:

SELECT *

FROM TableA a

WHERE a.Id = (SELECT TOP(1) a2.Id

...

Are these multi-statement table valued functions? If so, understand that this type of function has not statistics. This means the optimizer treats them like a table that returns one row....

If the first guy through creates a plan that uses a scan, unless something fires a recompile of the procedure or the plan ages out of cache, it's going to...

You'll want to rebuild all your indexes and update the space usages after you move it.

But before you move it, use the Upgrade Advisor as mentioned above. There may...

I can't help you on the rogue DBA topic. Hunt 'em down & hurt 'em may be your only option.

As to the rest, why not manage the database code in...

Don't worry about it. There's always more to learn, for everyone. Speaking of which, I need to download 2008 and get started learning new stuff.

Not per se. The thing is, you need to be very careful about how you manage security. If you give a role blanket execution priveleges, then you may need to...

OK. You may or may not want to continue the existence check. From what I can see though, I think you could skip it. It looks like you're doing a...

I volunteer to continue processing beer to lager as time & money allows. I know it's a sacrifice, but someone has to do it.

This really gets into DB design, but based on what you're saying, I would drop the FK that is currently in place on the Property table. From what you say,...