Lab Sql

EDIT: Added in sample data that I am trying to disallow. This question is similiar to this: Cannot … Read more How Do I Reference A Table Twice When Creating An Indexed View? Can I Enforce Uniqueness Based On 2 Tables And Multiple Rows Without It?

I'm trying to match user-provided postal address data to an address reference dataset. I want t… Read more Creating Multiple Indexes For Table Join To Accommodate Fuzzy Matching

Here is my query: DELETE FROM events WHERE type = 4 AND author_id IN (?, ?) AND post_id IN (?, ?) … Read more What Kind Of Index Would Be Efficient When There Is In Clause?

In SQL Server 2008 I have tried to reproduce the results from the experiments on clustered index on… Read more Inserts With Sequential Guid Key On Clustered Index Not Significantly Faster

How does SQL Server determine whether a table column has low cardinality? The reason I ask is becau… Read more Sql Server 2005 Indexes And Low Cardinality

Hopefully someone can help with this. We have the need to return a data field from a rowset XML col… Read more Sql Server Not Using Xml Indexes For Querying Xml Rowset

I've got these two queries: SELECT SELECT NamesRecord.NameID, NamesRecord.FulfillmentAddressID … Read more Poor Clustered Index Seek Performance?

I have written a stored procedure that, yesterday, typically completed in under a second. Today, it… Read more Sql Server - Stored Procedure Suddenly Become Slow