Then of course those two columns should be the primary key. I guess you have confused primary keys with surrogate keys.

I'll add my .02 as well (soon we'll have that 1). I fully agree with Frank and Kenneth. Using a clustered index with a correctly designed table more or less...

Just use a very long string for varchar(max). For instance:

DECLARE @foo VARCHAR(MAX)

SET @foo = REPLICATE('foo', 10000)

UPDATE dbo.foobar

SET varchar_max_column = @foo

> I have Yukon - Beta3 installed on my machine.

There is...

See my article Moving system databases - a checklist, which describes exactly how to do this.

Every table should always have a primary key. If it does not it is not even a relational table, which defeats the whole purpose of using an RDBMS for managing...

Sounds like a line from The Incredibles or something.

But it's true, the only stupid questions are those that are not asked.

I would say it depends extremely depending on the level of the candidate and the specific position they are applying for. For a development-ish position I like to let a...

Something like this?

SELECT Company, SUM([Pieces of Equipment])

FROM ...

GROUP BY Company

If they are named according to the standards expected by Enterprise Manager, then you can view a description in EM. Right click the table, Design Table. The field description contains...

And it works with VS2005 Beta 2 as well! Oh the joy!

Before you can edit anything using Management Studio you must first choose which server to connect to. You either connect to a SQL Server 2000 instance or a SQL Server...

SQL Server 2000 and 2005 does not play very well together yet. Since 2005 is in beta you should install it in a separate testing environment, for instance a virtual...

Why are you using TOP 100 PERCENT and ORDER BY LastModifiedDate in the view?? That means that the entire table must first be sorted on LastModifiedDate for the view to...

If you could post some DDL that would probably make it easier to look at this.

Are the column(s) you are ordering by indexed?