Posts
Sort by recent activity
Refresh suggestions
Hi Redgate Team,
since the last(?) version the automatic and manual refresh of suggestion is not working properly anymore.
Dropped object are still in the suggestion list (intellisense).
Thanks for...
Additional semicolon
Hi redgate Team!
Formatting the following code introduces an unneeded semicolon between GO and WITH.
A semicolon before the WITH clause is only needed within the same batch...CREATE TABLE dbo.Heap
...
Comment Alignment
Hi Red Gate Team,
comments are aligned in a way I did not expected.
Version 1.3179SET NOCOUNT ON;
SET XACT_ABORT ON;
BEGIN
BEGIN TRY
BEGIN TRAN;
WITH cte
AS ( SELECT * FROM t1 UNION ALL SE...
Word wrap
Hi!
I set Wrap Lines Longer Than to 78
The following code is formatted in this way:IF NOT EXISTS ( SELECT * FROM sys.backup_devices WHERE -- WHERE should send to the next line
name = N'Transac...
Additional space after TO
Hi Redgate Team.
SQL Prompt adds an additional space after TO-- BACKUP DATABASE TransactionLog TO[TwoSpacesHere]TransactionLog_Backup;
BACKUP DATABASE TransactionLog TO TransactionLog_Backup;
GO
...
Begin Tran
Hi Redate Team,
I wonder why a BEGIN TRAN is not formatted like a BEGIN statementBEGIN TRAN T1
INSERT dbo.test ( col2 ) VALUES ( DEFAULT )
SELECT database_transaction_log_bytes_used
FROM sys.dm_tra...
CPU allocation of 100% after a while in SSMS and VS after upgrade to version 9
Hi Redgate Team,
since the last SQL Prompt update to version 9 I experience a massive CPU utilization after a while.
I encountered the problem on two different machines.
The CPU consumption of SSMS...
Rules
Hi Red Gate Team,
I like the idea of code analysis rules and I know that I can decide to disable them if I like. Nevertheless I would not enable some of the rules by default.
For example:
ST011 Rea...
Code Analysis Rules
Hi Redgate Team,
I appreciate the option enabling different code rules but I guess there is a general issue here.
Suppose I enabled the rule "unqualified column name" I will get a hint that a speci...
Goto Label
Hi Redgate Team,
I am missing a suggestion for defined labels after a GOTO command.
Would be nice to see this in a future release.
Thanks!
Torsten