Menu
My question comes from the frustration that I have every time I launch SSMS. We have few hundred of different databases in one server instance, from different projects and customers, and having them in one long flat tree view just does not feel very ergonomic to me.
Is there any smart way to keep them more organized? I thought, that for example being able to group them in custom folders would be a nice solutions, but AFAIK SSMS does not support it.
Being able to group stored procedures in a similar way would be a nice added value, but I'd be more than happy with being able to group databases only.
468
The SQL GROUP BY StatementThe GROUP BY statement groups rows that have the same values into summary rows, like "find the number of customers in each country". The GROUP BY statement is often used with aggregate functions ( COUNT() , MAX() , MIN() , SUM() , AVG() ) to group the result-set by one or more columns.
Right-click solution item (tree root) and from menu select Add > New Solution Folder. Step 1 now works also on any folder you added.
The filegroup contains the primary data file and any secondary files that aren't put into other filegroups. User-defined filegroups can be created to group data files together for administrative, data allocation, and placement purposes.
Step 1 : First of all you should select the respective filetable in which you need to create a folder and right click on it and select “Explore filetable directory” as shown in the image below. Step 2 : Once you select “Explore filetable directory”, it will open that particular filetable directory folder.
I have good news for all of you. There is an SSMS add-in for this. It allows to organize into custom folders all databases, stored procedures and other database objects as well. Just as if this was a native SQL Server Management Studio functionality.
The tool name is SQL Handy Groupie and can be found at www.skilledsoftware.com. Have fun.
97
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
