Posts
Sort by recent activity
SQL Prompt incorrectly expanding *
This is an edge case, but it is reproducable. In some code that I ran the SQL Prompt formatter on recently there was a common table expression that referenced a temporary table, and then another co...
How do you track performance of [top] SQL queries over time?
In preparation for changing the database compatibility level for our primary database to 2014, we would like to see which queries and stored procedures are performing poorly after the switch is mad...
Top 10 Objects / Stored Procedures?
Is there already a way to see the top 10 SQL objects in the main monitor pane? I can see a tab for top 10 queries and top 10 waits, but I would like to know the top 10 SQL objects (functions or sto...
How do you see the calling parameters / underlying stored procedure for a top SQL Query
I am new to using the Red Gate SQL Monitoring Tool. The main thing that I need to use it for is to determine the stored procedures in our system that are taking the longest to return (on average) a...
New Error with Tabs: Block after BEGIN all the way to the left
Not sure exactly which version introduced this error, but I am now seeing the following behavior: IF @Country = 'USA' BEGIN
SET @FormatCode = 1;
END;
ELSE BEGIN
SET @FormatCode = 2;
END;
In tha...
SQL Prompt No Longer Aligns Stored Procedure Parameter Default Values
I'm not sure exactly what version this happened in, but my SQL Prompt is no longer aligning stored procedure parameter default values as it once did. Further, I can no longer find an option in the ...
BUG: Cannot add duplicate ViewTableSuperClass with key
I've tried to reduce this error to its simplest form...There is a table in my database (dbo.Person) that has two computed columns. Each column uses a different user defined function to compute its ...
BUG: Change_Tracking set to ON despite being OFF in the script
I am using SQL Compare 13 and in my database project I have the line:ALTER TABLE [dbo].[Person] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = OFF);In the comparison it displays as:ALTER TABL...
Why does Red Gate SQL Prompt add spaces / tabs between table alias and column name?
One issue I've been having with the SQL Prompt formatter recently is that it has been inserting spaces / tabs between aliases and column names. For example:
FROM dbo.Product p
WHERE p.CategoryId = ...