SQL Server also creates a row in the sysobjects table, as it does for most database objects. The problem arises when you rename the object in Enterprise Manager or with the sp_rename stored procedure.

8) Don't Rename Script-Based Objects You'll often create a script-based object, such as a view, a stored procedure, or a user-defined function. SQL Server then stores the script that created the ...

1) Replace COUNT (*) With EXISTS When Checking for Existence Developers often use the value from the COUNT (*) function when enforcing business rules in Transact-SQL code. However, try the EXIST ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...