I am n ot sure about Beta 2 specifically, but I know that this feature has been missing in several CTPs of SQL erver 2005. I believe it was missing...

This should work I think, but it is written from memory with no server to test on so I cannot guarantee it:

EXEC sp_MSforeachdb @command1 = 'SELECT ''?'' AS DatabaseName, name...

Like Frank says, MS feels that SQL Server is better at deciding how to work with tempdb and optimize it's own memory. You can still help by optimizing tempdb though,...

This is set on a file-by-file basis, not for an entire database. The setting is stored in sysfiles, in the maxsize column. -1 indicates unrestricted growth.

And if there are other columns and already a primary key you instead add a unique constraint.

ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE CLUSTERED (group_id, folder_id)

You might want to create...

If these are the only columns of the table, create a primary key as (group_id, folder_id) or the other way round, depending on which query is most used in your...

Bersileus, it is not a good idea to convert the column before comparing it. This means that no index can be used to find the rows that match the where...

Why use a UDT? Are you saying he should create a string representation of numbers that have the required format and store that? That would be a very bad idea,...

People believe that just because SQL Server is easy to install it is also easy to use, and then blame all their problems on SQL Server being a lousy product....

sushila, I am not in any way involved in this great site, other than that I write articles once in a while and try to hang out here at the...

>ORDER BY is important because relational theory specifies that the rows in a result set cannot be assumed to have any sequence unless ORDER BY is specified.

Hmm, maybe they should...

sushila: What do you mean "have a clustered index"? A clustered index does not guarantee a specific order of rows for a select query.

joel: Sure, it might seem strange that...

Rows are never guaranteed to be returned in any specific order unless you specify an order with ORDER BY.

SELECT * FROM INFORMATION_SCHEMA.TABLES

Add them to the db_accessadmin, db_securityadmin and db_ddladmin roles, and of course db_datareader and db_datawriter I suppose. Specifically do not add them to the db_owner or db_backupoperator roles.