Identifying Page Splits in SQL ServerIf I could have done better I would rewrite this article myself, but today I read a comprehensive article by Nagaraj Venkatesan related to getting a handle on Page Splits in SQL Server. If you manage any volume of SQL servers then I strongly recommend that you read this article... simply fantastic!
SQL and SQL only: Identifying Page Splits - by Nagaraj VenkatesanIs this code snippet, product or advice warrantied against ill-effect and/or technical malaise? No. No it's not! Not expressed - Not implied - not at all.