Viewing 15 posts - 24,361 through 24,375 (of 49,552 total)
Something is rebuilding indexes. You need to find what is running that and decide whether it should be stopped or not.
As for the statements, they're in the deadlock graph...
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
August 6, 2011 at 5:09 pm
You can't say that one process or the other is at fault. It takes at least 2 processes to cause the deadlock and they are both equally responsible.
Sharepoint does not...
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
August 6, 2011 at 4:28 pm
Multiple processes involved here
The first one is doing an index rebuild. No idea why an index rebuild would be in the middle of an important process, but it's running. It...
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
August 6, 2011 at 3:26 pm
Actually, looking at this again, the repair may not lose anything. The damaged page is index 22, so should not lose data in a repair.
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
August 6, 2011 at 1:25 pm
Err, why would you want to do that? Waste of time.
If you have a clean backup and an unbroken chain of log backups from that clean backup up til now...
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
August 6, 2011 at 1:12 pm
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
August 6, 2011 at 12:46 pm
Or, if you want everything for that day, not for the next day
SELECT ETD, ETA
FROM OceanShipments
WHERE ETD >= @ETD AND ETD < DATEADD(dd,1,@ETD)
ORDER BY ETD
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
August 6, 2011 at 8:54 am
SQL's messages are logged in both. System messages only in the system event log.
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
August 6, 2011 at 8:26 am
sean48 (8/6/2011)
Beschrijving like a table with two columns with no further format, such as lines or color.
It Beschrijving is like a table with 2 columns, then it should be a...
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
August 6, 2011 at 8:25 am
System errors and events. (and no, those aren't just for the system administrators to look at)
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
August 6, 2011 at 8:17 am
Neither. Two values means two columns. Database normalisation rules - columns should be atomic, should contain only one value.
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
August 6, 2011 at 6:44 am
Grant Fritchey (8/6/2011)
In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.
DateTimeOffset, not DateTime2.
Doesn't handle daylight saving though.
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
August 6, 2011 at 4:57 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1155514-338-1.aspx
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
August 6, 2011 at 4:56 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1155514-338-1.aspx
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
August 6, 2011 at 4:56 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1155514-338-1.aspx
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
August 6, 2011 at 4:55 am
Viewing 15 posts - 24,361 through 24,375 (of 49,552 total)