Recently I had to create a script which will monitor free space of all the datafiles and send alert if the free space within a datafile falls below 10% of the Total file space. The following script should help to … Continue reading
Monthly Archives: February 2012
Blogs on SQLServerGeeks
TweetFollowing are links to my blog post on SQLServerGeeks.com. Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? http://sqlservergeeks.com/blogs/Parikshit/personal/427/does-parallel-plan-for-rebuild-index-impact-the-fragmentation-of-index Understanding SQL Server Page Allocation using new sys.dm_db_database_page_allocations introduced in SQL 2012 http://sqlservergeeks.com/blogs/Parikshit/personal/433/understanding-sql-server-page-allocation-using-new-sys-dm_db_database_page_allocations-introduced-in-sql-2012 Parikshit … Continue reading