SQL Server 2005 Tidbit 026

Happy SQL Express User

This tidbit comes as an answer to a really good question asked at a recent TechNet Event:

“If I’m running SQL Server 2005 Standard Edition, and I use the Database Engine Tuning Advisor, will I see Partition options available?”

This quesiton came about mainly because partitioning is available SQL Server 2005 Enterprise Edition, but not Standard.  The answer is that the Tuning Advisor will simply not make partitioning suggestions on Standard Edition. 

Got an IT question?  Give me a comment, or contact me.