It depends. All the data is stored in tables. So even when you query a view, except for materialized views, you're querying the tables that make up the view. The...

This is the kind of information you can get out of the Books Online as well as a gazillion third party books and web sites. Do a little basic research...

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. 😛