And while I'm on it, I've run Powershell scripts against SQL Server 2008 before. I created a silly little test script for placing a load on a copy of AdventureWorks...

It looks like it did precisely what you told it to. It limited the names to where they did not equal 'Name1' and it showed those for values not...

Or

SELECT f.footballer_name

,a.goals_scored

FROM football.table f

JOIN another.table a

ON f.footballer_name = a.footballer_name

WHERE f.mins_played > 300

The problem you defined is a classic and simple JOIN between two tables.

It's just a scan against a heap? You won't see any real improvements there until you change the situation, adding a clustered index, or an index, period. 7.0 might just...

Nothing free that I'm aware of. SQL Prompt is pretty inexpensive though. It's got a real return on investment with the speed you can realize in writing TSQL code. You...

In general, there are exceptions, you should have a clustered index on each table. You only get one and it affects how the data is stored, not just how it's...

Are the query plans different?

My guess, and this is just a guess, the optimizer spends a little less time figuring out the ANSI 92 syntax than it does the ANSI...

Did you get errors or anything? I had a heck of a time installing the 2008 version of AdventureWorks until I had file streaming installed & configured.

Now that's a really hard answer. A SAN should, in theory, perform almost as well as a RAID system, but with a lot more redundancy, safety, blah, blah, blah. BUT,...

Then, if you're not going to get one of the third party tools mentioned above, you should look at a solution using PowerShell or TSQL. Personally, for something like this,...

Huge discussion onging about ER tools right here: http://www.sqlservercentral.com/Forums/FindPost588361.aspx

Short answer, Visio, without additional tools, is for documenting small database entity relationship diagrams. ERWin is an enterprise scale er diagraming and...

Barkingdog (10/21/2008)

>>>>

But we've been doing our physical design work more and more without the ER tool and simply plugging it right into code from day one

>>>>

do you mean you...

How's this for synchronicity. We're having this discussion and I see that Buck Woody has a post up on his blog about ER tools. http://blogs.msdn.com/buckwoody/archive/2008/10/20/erd-designer.aspx.

I'd like to comment, but...

It's especially egregious because it doesn't simply want a copy of VS or even the Team System, or the Database Edition of the Team System, but the ever-lovin ENTERPRISE version....

I can only use Visio for documentation. From the help file:

This version of Visio can't forward engineer your database model. In other words it can't use a database model you...