Viewing 15 posts - 136 through 150 (of 965 total)
You have one that is a SELECT-DELETE deadlock and one that is a SELECT-INSERT deadlock. The problem is most likely going to be that your SELECT statements have a...
July 14, 2010 at 2:42 pm
From the Books Online Topic: Database Mirroring Witness:
Database mirroring partners are supported only by SQL Server 2005 Standard and later versions and by SQL Server 2005 Enterprise Edition and later...
July 14, 2010 at 7:28 am
What version of SQL Server is this on? If it is SQL 2000, turn on Trace Flag 1204 and it will write a deadlock graph to the ErrorLog when...
July 14, 2010 at 7:16 am
There is no other way to do this other than copy all the data to a new database that is created on the new 4KB sector size.
What's a reference for...
April 8, 2010 at 7:59 am
You would use sp_trace_setstatus to remove the trace. You'd have to get the traceid from the sys.traces DMV and then you can remove the trace:
-- Find the TraceID for...
March 30, 2010 at 10:01 am
Since this sounds like a DBA only function in a recovery scenario, I'd probably enable xp_cmdshell for the duration of the recovery and turn it back off once you finish...
March 22, 2010 at 11:20 am
Ron Jennings (3/22/2010)
This function is exactly what I was looking for as part of a SQL Server Disaster Recovery solution I'm developing. The only additional thing I would need to...
March 22, 2010 at 10:47 am
adish (3/1/2010)
It is clustered. Am I doing something terribly wrong? Some light on this please, I am not an expert in SQL and would appreciate guidance from SQL gurus.
Thanks
adish,
Read the...
March 1, 2010 at 8:13 pm
SQLBOT (3/1/2010)
It's the random insertion, not the datatype that causes the problem.
What's the differece if the data inserted is Johnson, Jonsonn, Johnsen or three guids?
Under the hood, there's not...
March 1, 2010 at 7:23 pm
Paul White (3/1/2010)
adish (3/1/2010)
I've been using GUID as PKs, but this is a novel way of using it. Great.Not a clustered Primary Key, I trust?
It probably was clustered, its common...
March 1, 2010 at 12:06 pm
This was a bug in SQL 2008 that is fixed in CU6 for SP1 as per the following link:
February 19, 2010 at 4:39 pm
Thor (Hammer of God) (2/5/2010)
I can certainly see that logic, but would have to say one could always abstract out the functionality to a separate application layer process, even within...
February 5, 2010 at 11:47 am
thor 67519 (2/5/2010)
February 5, 2010 at 11:09 am
thor 67519 (2/5/2010)
February 5, 2010 at 10:48 am
thor 67519 (1/29/2010)
February 5, 2010 at 10:47 am
Viewing 15 posts - 136 through 150 (of 965 total)