Absolutly, only add the user to the specific database they need access to.  Then give them only say datareader and datawriter role in that database.  They will be able to...

I am and always will be dead against compound keys.  I have been thrown into environments where they existed and have been faced with nightmare situations in regards to maintenance...

What is happening is that the active part of the log is located near the end of the file.  Therefore you cannot shrink the file since you can't truncate the...

You can use ALTER DATABASE to change the default collation of a database. For a detailed example, see the topics "SQL Server Collation Fundamentals" and "ALTER DATABASE" in SQL Server Books...

If you are talking about this kind of message:

JOB RUN: 'DBA Optimizations Job for DB Maintenance Plan 'User Database Maintenance'' was run on 07/04/2005 at 2:57:47 PM

DURATION: 0 hours,...

There is a server role called Process Administrators.  If you are a member of this role you can start and stop the SQL Server Service as well as the Agent...

This does seem to be new with SP4.  I do not see it on any of my pre sp4 servers.  As for the problems aligning FK between tables, I have...

Here is a silly way to do it although I am not a big fan of temp tables:

select top 1 count(col1)as num, col1

INTO #temp1

from tabl1

where (col2 = 666)

group by col1

SELECT...

I agree.  I designed a database which used policy numbers as primary keys which then cascaded downwards to a number of owning relationships.  This was designed this way after being...

I ran into this problem and just bit the bullet and broke the table out.  It came down to the fact that there was a possibility that the row could...

First thing that comes to mind is how much RAM is associated to each instance.  With 7 instances the minimum RAM setting may just be leaving a couple of the...

I have been using the suggestion of the following website.  The nice thing is that you can download the trace file and stored procedures used to interogate the data profiled.

Here is an example that will generate the sp_spaceused statements for every user table in a database.

DECLARE @l_table_name VARCHAR(255)

DECLARE CHECKSIZE CURSOR For

SELECT name FROM sysobjects WHERE xtype LIKE 'U'

OPEN...

You can use the stored procedure sp_spaceused to obtain the size information for each table. You will need to supply the table name as a parameter, so if you want...

You can try to return only the data you want to see by using a WHERE clause, or if you really want to archive the data you can create a historical...