Phil Factor demonstrates why SQL Prompt has a 'Best Practice' rule (BP010) that checks for use of the @@IDENTITY function, and suggests less error-prone ways to get the latest identity values used in a table.
2019-09-05
Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.
2017-08-18
3,546 reads
By Vinay Thakur
Today was working on SQL Server cursor standard cursor deification would be like this:...
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
By SQLPals
If your organization uses a password policy (there are very good odds these days...
Comments posted to this topic are about the item Numeric and Decimal, which is...
We migrated from sql 2005 to sql 2016 recently in one of the job...
I would like to know the working principle of DBCC regarding the tempdb. I...
Ask SSC