Maybe I need to clarify that. I hate out of control recompiles. On rare occasions I've found queries that benefit from having WITH RECOMPILE attached to them so that you...

The max appears to be 256. I suspect you'll run into other problems long before you hit that limit.

As to the post that 10-12 is a max, I just don't...

Volunteer to build a database for the local church, community group, Boy/Girl Scout troop, soup kitchen, community farm... Whatever. They can't pay you, but you can use actual user requirements...

You would probably need to develop this for yourself, although if you search around someone else may have written a script or a piece of code. You might also want...

Even if it's not RBAR, recompiles can cause queries to block themselves. See this link to identify what the cause is, if you're having a recompile. This MSDN article is...

Listen to Gail. Don't use these.

However, if you do, test, test, test, the queries to verify that you're actually getting usefulness out of them.

How many have you got?

Seriously though, I've seen performance begin to degrade after 50 or so joins, mostly due to the time it takes to compile the query, not the...

There are good examples in Books Online:

UPDATE dbo.Table2

SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB

,dbo.Table2.ColC = dbo.Table1.ColQ

FROM dbo.Table2

INNER JOIN dbo.Table1

ON (dbo.Table2.ColA...

Also, both these are reviewed over at the SQL PASS Book Review SIG. Along with a bunch of others.

I've got two, one I've read and one I want to read:

Inside SQL Server 2005: T-SQL Querying

by Itzik Ben-Gan

It's just a wonderful book. I refer back to it regularly. The...

I'd suggest instead of spending your time trying to prop it up, you dive in and start refactoring it in bits and pieces to reduce the compile time and run...

Not arguing, just pointing out, Size06...Size24 is a pretty serious violation of 3NF. I'd think you could get the same results without that.

I'll give it a shot. If I end up in the hospital, after I get out, we're going to have a chat. 😛

dfalso (5/2/2008)

---

Jeff, I appreciate both your and Grant's replies. I also appreciate your concerns about something that's written for a small situation now, but for whatever reason is used in...

How did you know what I had planned for the week-end... 😀

I have to ask though, what's drowning breath exercise? While we do incorporate a lot of traditional stuff, including...