By tag: indexes
0
kicks
SQL Server - Filtered Indexes
Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index. In filtered index, you can define index to the filter portion of your data.
0
kicks
Does the order of columns in an index matter?
In this blog Joe answers the question, 'does the order of columns in an index really matter?' He provides several examples and shows the results of the Query Execution Plan.
0
kicks
Create Data Disaster: Avoid Unique Indexes
The convenience of surrogate keys produced by ORM tools can lull lazy developers into ignoring unique constraints. Find out why this oversight can lead to disaster.
0
kicks
The real reason SELECT * queries are bad: index coverage
Are SELECT * queries bad? Sure, everyone know that. But, why?
0
kicks
Why Can't Database Tables Index Themselves?
Obviously, indexes are a central concept to databases and database performance. But horror tales still abound of naive developers who "forget" to index their tables, and encounter massive performance and scalability problems down the road as their tables grow.