newbieuser (7/28/2015)
I'm reading in the whitepaper that index fragmentation with less than 1000 pages is not a concern.
FWIW - that number has no real meaning.
The person that said it made up the number.
You can read about that from his site - here[/url].
The key take away is to get to know your data and what is actually suitable for your databases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events