There's a free course on your computer (assuming it was installed with your client tools), called SQL Server Books Online.

Pages are allocated in a round-robin fashion among all the files in a filegroup.  If the table is more than a few extents, it probably has pieces in every file.

If...

The command is DBCC UPDATEUSAGE, and there's actually a second parameter for sp_spaceused to run it for you.

EXEC sp_spaceused @objname = '', @updateusage = 'TRUE'

The only problem with your DELETE query is the column list in the subquery.  It would work like this:

delete from table where (rowid)

    not in

     (select min(rowid) from table group by...

ExecuteScalar returns the value of a one row, one field result set.  Mohammed's procedure doesn't return any result set, it sets the return value.

You have to create a return value parameter...

I created a VBScript file to set up standard server definitions in Enterprise Manager.  We have two production servers that we access over a VPN that require alias definitions and...

I don't know that changing the fill factor will help, I'm also concerned about the full tables scans where you expect index seeks.  But I wondered if you rebuilt the indexes after changing the...

SQL 2005 x64 will definately perform better with more memory.  If your databases add up to 9GB and you put them on a system with 16GB RAM, it can hold...

You could migrate your butt to a job where they let you buy a new server once in a while

SELECT

s.st_id, s.st_name

FROM Student s

INNER JOIN