Finding code smells using SQL Prompt: procedures that lack schema-qualification (PE001)

SQL Prompt will warn you if it spots use of EXECUTE, without specifying the schema in which the stored procedure resides, because it can cause slower execution times, or even result in running of the wrong procedure. Read more

SQL Prompt
SQL Code Snippets
Query Performance

How to record T-SQL execution times using a SQL Prompt snippet

Phil Factor shares a SQL Prompt snippet called timings, which he uses as a standard testbed for getting execution times for procedures and functions. Read more

Redgate Test Data Manager

Redgate Flyway

Redgate Monitor

Overview

Protect

Automate

Monitor

Product articles Query Performance

Finding code smells using SQL Prompt: procedures that lack schema-qualification (PE001)

How to record T-SQL execution times using a SQL Prompt snippet

Product Articles

University

Events

Forums

Community

Simple Talk