Do you have any maintenance plan to back up the transaction log for the same database? If that's the case, log shipping will not function correctly because both maintenance plan...

Dynamic SQL is executed in a separate scope than the batch. The temp table #SQLCmd is created outside...

Try "Add Contraint" instead of "alter column":

ALTER TABLE MyTable ADD CONSTRAINT default_name DEFAULT 'my default value' FOR MyColumn;

Ran "2.Update Statistics" after 3 &...

Not sure what you want to achieve. SQL Server provides Security Catalog Views and Security Stored Procedures that you can use to audit server-level or database-level permissions.

As Leo said, you will also need to know the SQL code (statements in SP, dynamic SQL, ...) by turning on trace 1204. Once you have all the information, you...

You can find the objects and indexes, which caused the deadlocks, based on the information (hobt_id, objid, index name) provided in the deadlock graphs. Just query catalog views (e.g., sys.partitions).

krypto69 (7/16/2010)

---

I was updated an identity value on a table in my DB.

The drive the DB was on ran out of room.

I rebooted the server...and now my DB says 'In...

You can try indexed view, which may solve the performance issue.

The max server memory is the maximum memory used by the buffer pool of SQL Server Database Engine. SQL Server has internal and external components,...

This really depends on your application and requirements. You...

Quote: more specifically the slow down seems to occur when joining a temp table into several other tables.

In your production environment:

Check the configuration of TEMPDB database: make sure to move...

Comment on your second recommendation:

[ 2. As most of our users use tempdb(which can not be avoided) by pulling millions of records in temp tables, i thought i have better...

If you concern about the size of the log file, consider using one of the following methods to prevent the transaction log files from growing unexpectedly:

1. Back up the transaction...

DBCC Shrinkfile with TruncateOnly is applicable only to data files.

You may need to truncate your transaction log before you are able to empty that log file. Try this:

...