Click here to monitor SSC

Author Profile

Luciano Moreira

Luciano Moreira is the founder of Sr. Nimbus, a consulting company based in Brazil, providing training and consulting services in SQL Server and .NET Platform. He holds a bachelors degree in computer science from the Universidade de Brasília. He has been working with Microsoft platforms since 2000, always focused on architecture, programming and SQL Server, his professional passion. After working for some IT companies, including a Microsoft gold partner, he joined Microsoft on January 2006, assuming the role of SQL Server Premier Field Engineer, later acting as a Developer Evangelist, until April 2009. He has some certifications: MCP, MCAD .NET, MCSD .NET, MCDBA, MCTS (SQL Server 2005/2008, .NET 3.5, .NET 4.0 Data Access) and MCITP (SQL Server 2005 and 2008), being a MCT since 2002. He blogs at: luticm.blogspot.com. Luciano was awarded with the SQL Server Microsoft MVP title in July 2010, which he still holds. You can see his MVP profile here.

No Significant Fragmentation? Look Closer…

If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use. Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.