Search Results

When you set the database to single user, it allows a single user into the database. If there's someone else trying to get into the database, and you don't have a connection to the database someone e …

The error indicates your database is corrupt. The good news is that database ID 2 indicates this is the tempdb database, so fixing this is easy - just restart the database instance. Once you resta …

No. In fact you can't restore the system databases from a SQL Server 2000 system to a SQL Server 2008 instance. If you did parts of (or the entire) database engine won't work as the SQL Server 2000 sy …

Any members of the db_owner fixed server role can do anything they want within that database (include drop the database). They can't do anything outside the database without additional rights.

If it works for you then it's a good practice. There are basically no hard rules for databases.

You need to grant rights to use the function. GRANT EXECUTE ON Function to UserOrRole

CXPACKET is not the cause of high CPU workload. CXPACKET simply means that the query has gone parallel and that the thread which is reporting CXPACKET is waiting for another thread of the query to run …

In either case (Log Shipping or Mirroring) when you bring the DR server online for testing any changes will be replicated back to the production server. If you don't want this to happen you'll want t …

OK, so I'm not going to comment on the table design as I assume that this is just part of the tables. To do the update that you are looking for there's a couple of options. You can get the Permissio …

No there are no specific bad things about using temp tables and temp procedures. For the temp tables you'll want to make sure that you've got indexes as needed when querying from them, but that appli …

You can change this at any time from full to simple. After making the change manually run checkpoint for the databases, then you can begin shrinking the transaction log. This does require a short lo …

The SQL Server will maintain these indexes automatically. If they have become fragmented you'll need to defragment them manually or via a scheduled job just like the user databases.

When you have Mirroring and Replication you usually have two different problems that you are trying to solve. You are using the mirroring to solve a high availability problem and you are using replic …

So there's a couple of ways that this can happen. The queries in the blocking database reference objects within the blocked database. The queries are waiting for tempdb to allocate pages and one que …

What you are looking for is an Enterprise Job Scheduler. Computer Associates has a good one called AutoSys. There's also JAMS, OpCon, Tivoli as well as others. There's a decent list available on wi …