With this, you can increase your productivity by 75% from typing out G R O U P B Y and instead use gb and hit tab. I’m not going to talk about “Code Formatting” – saved my sanity many times.Ī well-known secret with SQL Prompt’s autocomplete is the snippets feature.

I’m not going to talk about “Save and Recover Lost Tabs” – saved my ass many times. Now I consider myself lucky that work has invested in the RedGate tools, and right now, especially SQL Prompt. Trawling the bulletin boards, question sites, and forums – okay maybe a quick question online, it’s called poetic exaggeration people! – they eventually learn the folly of their ways and correct their mistake. I mean the error message is still red, looks nearly identical to the original one encountered, and can cause a rage-inducing damnation of SQL Server error messages. So some eager yet lost scholar ventures into this land of aggregate functions, reads the error message and adds in a GROUP BY clause. SUM(t.user_objects_dealloc_page_count) AS UserObjectDeallocatedīut…if you forget to put in the GROUP BY clause, as a ski instructor once said, you’re going to have a bad time! Pizza…French Fries…Pizza The Repetitiveness of Questioners: SUM(t.user_objects_alloc_page_count) AS UserObjectAllocated, Did you know that the SQL language allows you to do amazing analysis of data such as aggregate functions?

Sql prompt where clause warning