You administer a SQL Server 2008 instance that contains a database named Sales. The
Sales database contains a table named Customers that has a column named
CompanyName.
The current database collation is SQL_Latin1_General_Cp1_CI_AS. You need to ensure
that the indexes which include the CompanyName column are case-sensitive.
You also need to ensure that other case-insensitive queries are unaffected.
What should you do?
A.
Use the UPPER function in the filter criteria on all queries that filter on the CompanyName
column.
B.
• Drop all indexes on the Sales database.
• Modify the database to specify SQL_Latin1_General_Cp1_CS_AS as the default collation.
• Rebuild all the indexes.
C.
Use the CAST function in the filter criteria on all queries that filter on the CompanyName
column.
D.
• Drop all indexes on the Customer table that include the CompanyName column in the
index key.
• Modify the column to specify the SQL_Latin1_General_Cp1_CS_AS collation.
• Recreate the CompanyName indexes on the Customer table.