Viewing 15 posts - 16,201 through 16,215 (of 49,552 total)
Yup, you're looking in the right place, if you looked during the rebuild. No need to keep the versions around afterwards.
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
October 10, 2012 at 7:19 am
They're not on the same key. Two different keys in the same table. What tells you that is the id in the keylock. It's the hash of the key values...
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
October 10, 2012 at 7:17 am
Triggers use the version store. So do online index creation and rebuild.
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
October 10, 2012 at 7:02 am
Subqueries are seldom a problem themselves. It's a widespread myth that subqueries are slow, they are generally not. When there is a performance problem, the solution requires investigating the cause...
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
October 10, 2012 at 7:02 am
Need more details. Database locks are usually harmless and to be ignored. Only exclusive DB locks (from altering the DB) are problematic, and the operations that require those shouldn't be...
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
October 10, 2012 at 6:59 am
Also asked here: http://dba.stackexchange.com/questions/25730/sql-server-2008-mirrored-database-with-manual-failover-need-reporting-database/
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
October 10, 2012 at 6:57 am
Perry Whittle (10/10/2012)
sql.com (10/10/2012)
@ Gail - I was waiting for a MCM 😉
Why??
i could be wrong but i'm sure I'm not. I wouldn't think that the MCM course will teach...
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
October 10, 2012 at 4:50 am
Err...
No offence, but if you don't understand hex representation, you're going to find the raw page dumps near impossible to decode.
You might want to first read up on hexadecimal...
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
October 10, 2012 at 4:27 am
Just a note, whether it's a split or an in-place update does not in any way affect the behaviour that you, as a user or developer will see. It won't...
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
October 10, 2012 at 4:05 am
TagA and TagB are just the two bytes (first and second) of the record header, nothing fancier than that. You don't need to decode them, DBCC Page does it for...
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
October 10, 2012 at 3:39 am
It's partially true (but the inserted and deleted tables are not the way to prove it)
When the index key column is changed, then the update is split into delete/insert pair....
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
October 10, 2012 at 3:11 am
SQl doesn't drop it's memory usage unless restarted or the server is under memory pressure or max server memory is reconfigured to a low value. Please read chapter 4 of...
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
October 10, 2012 at 3:05 am
Query sys.dm_io_virtual_file_stats
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
October 10, 2012 at 3:04 am
Again, you do not need /3gb for memory usage above 4GB. That's the /PAE switch and the AWE settings alone. With 16 GB memory, /3GB can be harmful as 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
October 10, 2012 at 2:22 am
Providing you've taken no log backups between the backups that got copied and the configuring of the mirror, yes it will catch up. If you have, all those log backups...
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
October 10, 2012 at 1:40 am
Viewing 15 posts - 16,201 through 16,215 (of 49,552 total)