Viewing 15 posts - 30,391 through 30,405 (of 49,552 total)
What's the compatibility level of the two databases that it doesn't work in?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 12:12 pm
Alvin Ramard (9/23/2010)
The Dixie Flatline (9/23/2010)
I don't gamble a lot either, Jason, and my preferred...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 12:09 pm
ALZDBA (9/23/2010)
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 10:47 am
GilaMonster (9/22/2010)
There's a lot of important information which is not present in a copy-paste of part of the text plan.
Table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 10:45 am
This one: (from Books Online)
request_owner_guid : uniqueidentifier
GUID of the specific owner of this request. This value is only used by a distributed transaction where the value corresponds to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 10:42 am
Spid -2 is an orphaned distributed transaction.
Query sys.dm_tran_lock for rows with session_id = -2. There's a column called something about 'unit of work'. It's a uniqueidentifier. Find the value and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 7:18 am
Interesting...
Are these DBs still on the 'recovered' drive?
It looks as though the error is in the snapshot that CheckDB creates, not the DB itself. Can you run a CheckDB with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 7:11 am
Am curious...
DBCC Page(11,1,19170)
Will probably give error
I suspect that one's in the 'export data, script objects and hope for the best' category. Not repairable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 6:36 am
george sibbald (9/23/2010)
does anyone see a use for dbcc timewarp here:http://www.sqlservercentral.com/Forums/Topic991811-146-1.aspx
or maybe sp_configure 'go faster',1
I was really tempted to reply to that with a link to my April Fools post....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 6:29 am
Urrr, sorry can you explain that please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 6:21 am
antonyp 46888 (9/23/2010)
"declare @sql_txt varchar(max)
Learner DBA (9/23/2010)
you can try using the nvarchar(max) it stores large data
If you read the initial post, you'd see he's already using varchar(max)
or else if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 6:19 am
I suspect that you're going to need to drop the log shipping destination and recreate it with another full backup from the primary before you can continue log shipping.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 5:58 am
HowardW (9/23/2010)
As Gail said, "Suspended" is not a database state. What's the exact wording that appears next to the database name in Management Studio?
And what messages appear in the SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 5:44 am
antonyp 46888 (9/23/2010)
We are facing the problem thatone of the table field length more than Nvarchar(max).
nVarchar(max) can store over 1 billion characters in it. That's 2 GB of data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 5:43 am
subbu_e (9/23/2010)
Log file grows and do not have space on the disk.
That will not result in a database being marked suspect.
Also, there's no indication that the database actually was suspect.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2010 at 5:41 am
Viewing 15 posts - 30,391 through 30,405 (of 49,552 total)