Tag Archives: SSMS

SSMS Tip Of The Day – Show Row Count

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count(*) from TableName but it has quite a nasty performance. Another way to do it with much […]

SSMS templates in SQL Server 2012

There is nothing new about using templates in SSMS. Each time you create let’s say a new stored procedure you use a template like this one They have been around since SQL Server 2000. Where is my template parameters pop-up dialog ? In previous versions of SQL Server you wanted to use the key combination […]