By Grant Fritchey
Author Grant Fritchey describes how SQL Prompt Pro and SQL Data Generator help speed up performance tuning:
"Understanding the execution plan is only part of the problem when it comes to performance tuning. I also need to write accurate, clear TSQL code and I need to test the code prior to releasing it into the wild of a production environment. To perform these tasks, Red Gate supplies a lot of what I need. SQL Prompt, especially SQL Prompt Pro, helps me write accurate code faster by supplying me with type-ahead in the Query Editor and in Visual Studio.
I love how the columns popup after only a couple of key strokes and how the key fields are read, even compound keys, and output for me when writing joins and all of it with accurate aliases and correct case. Not only does this increase my speed but it increases my accuracy because the code completion means fewer typos. The Pro version also supplies a nice way to format the code automatically so that all my queries are structured the same way. All this makes this tool a must have for writing TSQL.
Once it's written and I have to test the code, SQL Data Generator has recently become the go-to tool to provide a bloated database. The way the tool works with existing data or from disparate sources as well as its ability to generate data makes creating a complex load easy. I can bloat a database quickly and repeatedly. It makes a huge difference in the accuracy of my testing."
Author Grant Fritchey describes how SQL Prompt Pro and SQL Data Generator help speed up performance tuning:
"Understanding the execution plan is only part of the problem when it comes to performance tuning. I also need to write accurate, clear TSQL code and I need to test the code prior to releasing it into the wild of a production environment. To perform these tasks, Red Gate supplies a lot of what I need. SQL Prompt, especially SQL Prompt Pro, helps me write accurate code faster by supplying me with type-ahead in the Query Editor and in Visual Studio.
I love how the columns popup after only a couple of key strokes and how the key fields are read, even compound keys, and output for me when writing joins and all of it with accurate aliases and correct case. Not only does this increase my speed but it increases my accuracy because the code completion means fewer typos. The Pro version also supplies a nice way to format the code automatically so that all my queries are structured the same way. All this makes this tool a must have for writing TSQL.
Once it's written and I have to test the code, SQL Data Generator has recently become the go-to tool to provide a bloated database. The way the tool works with existing data or from disparate sources as well as its ability to generate data makes creating a complex load easy. I can bloat a database quickly and repeatedly. It makes a huge difference in the accuracy of my testing."
