Viewing 15 posts - 19,381 through 19,395 (of 22,202 total)
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.
October 22, 2008 at 6:25 am
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...
October 22, 2008 at 6:01 am
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...
October 22, 2008 at 5:55 am
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...
October 22, 2008 at 5:53 am
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...
October 22, 2008 at 5:46 am
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.
October 22, 2008 at 5:42 am
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,...
October 22, 2008 at 5:38 am
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,...
October 22, 2008 at 5:34 am
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...
October 21, 2008 at 12:57 pm
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...
October 21, 2008 at 10:38 am
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...
October 21, 2008 at 9:23 am
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....
October 21, 2008 at 9:18 am
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...
October 21, 2008 at 8:44 am
Several of the Red Gate people haunt these forums. Hopefully they'll pick it up & run with it. Contact them and offer your services. I'd like to see a cheaper...
October 21, 2008 at 8:10 am
I'm sure you can move the backups, but I don't think you move the logs. I see Quorum there. That usually means a cluster. Which further means that all the...
October 21, 2008 at 6:06 am
Viewing 15 posts - 19,381 through 19,395 (of 22,202 total)