Category: sql-server

Validate MSSQL identifier (parameter) in .NET or regular expression

In a .NET project I need to verify if a string is a valid Microsoft SQL Server 2005 parameter identifier. Example: SELECT * FROM table WHERE column = @parameter Is there a runtime class method to validate a string for being a parameter, or is there a regular expression that verifies the rules? (see below) […]

Declaring an Index as unique in SQL Server

If I know an index will have unique values, how will it affect performance on inserts or selects if I declare it as such. If the optimiser knows the index is unique how will that affect the query plan? I understand that specifying uniquenes can serve to preserve integrity, but leaving that discussion aside for […]