Viewing 15 posts - 24,121 through 24,135 (of 49,552 total)
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 17, 2011 at 1:12 am
DTS still works in SQL 2008. May not in the next version...
They're not openable in BIDs, download the DTS designer from the resource pack site and you can open them...
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 17, 2011 at 1:12 am
If a foreign key constraint references a table, that table cannot be truncated. Doesn't matter if the other table is empty, doesn't even matter if the constraints are disabled. 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
August 16, 2011 at 1:47 pm
The damage is to one of the critical system tables. Specifically table 4 (I think that was sysrowsetcols ion SQL 2005)
Msg 7985, Level 16, State 2, Line 1
System table pre-checks:...
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 16, 2011 at 11:37 am
drew.georgopulos (8/15/2011)
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 16, 2011 at 10:46 am
Todd Canedy-416047 (8/16/2011)
Any thoughts as to what the correct thing to do is?
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "WM_PlannedSupplySummary", index ID...
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 16, 2011 at 10:44 am
As long a you didn't break anything by removing the transaction... There are some operations that really should be done as atomic operations
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 16, 2011 at 9:08 am
SQL shouldn't need to use the page file, so on a server that just has SQL, page file size isn't as cut and dried as 1.5xRAM, especially on larger machines...
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 16, 2011 at 8:25 am
p.s. If you want some more info on reading deadlock graphs, Chapter 42 of SQL Server MVP Deep Dives is on that topic </blatant self-promotion>
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 16, 2011 at 7:46 am
First question: why? Are you trying to solve some particular problem?
For deep internals, try this: http://technet.microsoft.com/en-us/sqlserver/gg429796.aspx (Video)
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 16, 2011 at 7:40 am
Maybe.
The rollback will finish after the restart, it has to. How long it takes is another matter. May be quick, may take hours.
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 16, 2011 at 7:10 am
As soon as the database was restored to 2008 R2 it became completely a 2008 R2 database in every way.
The compatibility level just affects how the query processor and parser...
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 16, 2011 at 7:07 am
Bhuvnesh (8/16/2011)
SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection...
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 16, 2011 at 6:16 am
Bhuvnesh (8/16/2011)
GilaMonster (8/16/2011)
That 0 seconds, 0% often means the rollback is stuck waiting for something, maybe DTC, maybe a resource in the DB. Check for that.
How to approach here...
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 16, 2011 at 6:16 am
That's a shotgun to kill a mosquito approach....
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 16, 2011 at 6:00 am
Viewing 15 posts - 24,121 through 24,135 (of 49,552 total)