Indexes, like triggers, have always been a part of SQL Server but now we have even more features that we can take advantage of when creating indexes.
One of the biggest changes is allowing us to have an index on a computed column. A computed column is the answer from a sum. For example, consider a [...]
sql server, servers, web hosting, domain, web-design software, fonts, php, writing, software, laptop, computer
User-defined functions (UDFs) rock! UDFs allow us to create compliant units of Transact-SQL that can return either a scalar value or a table.
A scalar value returns a single value (as our UDF did) of the type we specify in the CREATE FUNCTION statement.
A table returns a table of results. It leverages the new data type [...]
