I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server.
Tuesday, 25 August 2009
List tables files and filegroups
Here's a simple query to get a list of database tables and the files and filegroups they are assigned to: I found this helpful tip on blog.sqlauthority.com and added a few little bits for better readability.
No comments:
Post a Comment