Code Analysis

External Article

Database Code Analysis

  • Article

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.


3,546 reads

Technical Article

RE: Agile Development with Scrum

  • Reply

"The customer lists all the features they want in priority order."And how often can your customers tell you exactly what they want, let alone as a prioritized list?If you are lucky enough to get a feature list, and it doesn't change half-way through, everything will be top priority. If you make the decision for them, […]


Technical Article

RE: SQL Agent won''''t start

  • Reply

Brian,Thanks for your help. I ran netstat -an, I did not see the sql server listening. Here is a view of the log file for the primary server:2005-03-16 09:36:35.62 server    Microsoft SQL Server  2000 - 8.00.194 (Intel X86)  Aug  6 2000 00:57:48  Copyright (c) 1988-2000 Microsoft Corporation  Personal Edition on Windows NT 5.1 (Build 2600: […]


Technical Article

latch timeout

  • Topic

Hi All, I am getting a latch (Type 4) timeout when accessing a certain page.CheckDB returns no errors and after truncating the table (Even dropping it) I still get the error.Trying to shrink the DB causes the error as well as all the backups.I got a log backup that runs once an hour and it's failing.Any […]


3 reads

Technical Article

RE: Query Analyzer hosed

  • Reply

Just a thought. I've worked places where the system support staff would handle system updates, updates of common applications, and suchlike outside of normal working hours. Does your company do this? Could they have done this last night (even if they normally don't do it)? Do you have anything that processes updates/upgrades automatically (Windows Update […]



Daily Coping 8 Dec 2022


Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.


One of my favorite parts of having a new job is that I learn...

Daily Coping 7 Dec 2022


Today’s coping tip is to stop for a minute when you walk outside and...

Read the latest Blogs


Problem Importing NULLs in varchar field

By John524

hello, This is something I'm really struggling with and haven't found much when I...

SQL Server 2022 is RTM

By Grant Fritchey

You can get your hands on SQL Server 2022 right now and this forum,...


By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers