Check-->

http://msdn.microsoft.com/en-us/library/ms143799.aspx

MJ

Make sure you close the connections once your work is done under them.

MJ

You can't specify it at database level but you can do that at query level by making use of QueryHints.

http://msdn.microsoft.com/en-us/library/ms181714.aspx

MJ

Please specify the sql server edition and memory configuration.

MJ

Look out for @attach_query_result_as_file and @query parameters under sp_send_dbmail for the same.

HTH

Mj

Please check for presence of indexes(for columns mentioned in where clause) for that one table.

MJ

As per books online:

Logical Scan Fragmentation Percentage of out-of-order pages returned from scanning the leaf pages of an index. This number is not relevant to heaps and text indexes.

Extent...

SELECT C.name 'Schema',

B.name AS Object,

...

Yes, it true. Storage size for the image and ntext data type, in bytes, is two times the number of characters entered.

Note: ntext, text, and image data types will...

Select Results to file option under Query-->Results to-->Result to file in ssms. This works gud with csv files.

You can also use openrowset for this.

MJ

By any chance did you removed builtin adminitrator accout on this server? Are you checking database integrity also?

MJ

Did you give this a try:

1) Use this query to get the UOW (a GUID) of the offending transaction:

use master

select distinct req_transactionUOW from syslockinfo

Note: Ignore the...

Is your application making use of Read Uncommitted isolation level?

MJ

Please post the error message here. Check for errors under sql error logs and database mail logs.

MJ

Is the sql server memory and processor configuration same on both?

MJ