Practical database guidance
Clear explanations about database reliability, troubleshooting, recovery, performance, and operating without a full-time DBA.
This article explains four concepts that help you assess SQL Server indexes: pages, fill factor, fragmentation, and size. Understanding these concepts helps you decide whether maintenance is worthwhile. They should be considered along side query performance and the cost of maintenance.
Read the article →In this section we will talk about nine common types of in indexes available. We will show sample index creation for each type.
Read the article →A SQL index works much like the index at the back of a book. Instead of searching every page—or, in this case, every row—the database uses the index to locate the requested data more efficiently.
Read the article →Describe the symptoms and we can help determine whether the database is really the cause.