Oops...I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact?
First published on MSDN on Aug 13, 2013 One of the several advantages you get with partitioning a very large table is the ability to add or remove partitions instantaneously to help you with sliding window scenarios.Are my actual worker threads exceeding the sp_configure 'max worker threads' value?
First published on MSDN on Jul 01, 2013 Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such.SQL Collation and related performance impact, viewing collation in query plans
First published on MSDN on Feb 04, 2013 It has been a while since there has been activity on this blog, we as a team will be trying to post weekly going forwards so as to share what we do on a regular basis – happy reading!I was posed a question by a fellow PFE during his performance `engagement.Backup compression behavior when appending backups to an existing Media Set
First published on MSDN on Aug 09, 2010 There will be an upcoming Knowledge base article detailing this out as well When you append a compressed backup to an existing Media, it inherits the compression setting from the Media set.
