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.

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, ...

In-Depth Top 7 Features Coming to SQL Server 2016 SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. By Joey D ...

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 ...