Viewing 15 posts - 871 through 885 (of 1,363 total)
December 16, 2008 at 10:23 am
Make sure you close the connections once your work is done under them.
MJ
December 16, 2008 at 5:47 am
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
December 16, 2008 at 5:22 am
Please specify the sql server edition and memory configuration.
MJ
December 16, 2008 at 5:02 am
Look out for @attach_query_result_as_file and @query parameters under sp_send_dbmail for the same.
HTH
Mj
December 15, 2008 at 4:35 pm
Please check for presence of indexes(for columns mentioned in where clause) for that one table.
MJ
December 15, 2008 at 3:06 pm
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...
December 15, 2008 at 4:08 am
SELECT C.name 'Schema',
B.name AS Object,
...
December 15, 2008 at 2:40 am
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...
December 13, 2008 at 6:59 pm
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
December 13, 2008 at 6:45 pm
By any chance did you removed builtin adminitrator accout on this server? Are you checking database integrity also?
MJ
December 13, 2008 at 6:11 pm
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...
December 13, 2008 at 6:02 pm
Is your application making use of Read Uncommitted isolation level?
MJ
December 13, 2008 at 5:50 pm
Please post the error message here. Check for errors under sql error logs and database mail logs.
MJ
December 13, 2008 at 5:27 pm
Is the sql server memory and processor configuration same on both?
MJ
December 13, 2008 at 5:24 pm
Viewing 15 posts - 871 through 885 (of 1,363 total)