Great article, well written. Fragmentation is not the easiest SQL Server topic to get your head around, but this explained fill factor and fragmentation in easy to understand English.

What about moving the data to a temporary table, resorting it into the order you want it, truncating the Title table and then re-inserting the data?

I will have to give mssqlxpress a go then. Autocomplete functions can be a really good way to build up your skills (as well as saving time and keeping down...

Out of curiostiy, why do you all choose to use another product other than Query Analyzer? Does the other software offer any features better than in QA which would help...

To quote :

"SQL Server knows statistical information about your data through a special object in the database (which I refer to as the statistics blob). The statistics blob contains information...

Great idea! So many SQL Server and other technical manuals available are far too academic, so the knowledge and experience of real-life DBAs and developers in commercial and working environments...

Enjoyed the article and also found dm's suggestion useful. Still finding my way around the expanse of SQL Server and tips like these really help me get to know it...

I agree with all the points in the article and really believe developers should do more to learn how to use both stored procs and SQL Server to their advantage....

This looks to be a very well thought out initial proposal and at first read I cannot see much missing in what I would like to see in a product...

I think Steve's article raised some great points, and some excellent ideas from those who have posted comments too.

I like the idea of those who make the most contributions reviewing...

I don't have a degree in CS so therefore I am excluded immediately for applying for jobs which state that a degree in CS is essential. My degree is in...