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.
