Posts Tagged ‘database management’

Table monitoring & Table informations in SQL-Server databases

August 16th, 2014 No comments

If you are a database admin or developer you always should know and take care about, where tables are stored, how much space they consume and how data grows in the tables. One of the golden rules in SQL-Server database development is not to use the PRIMARY file group as the default location for user-tables in your projects.

Better create a new custom file group, and set it as the default file group. From my opinion, this is the point, where a good database design starts: “With the implementation of additional and customized file groups”. In this article you will find a fast example how to do that. I had to mention file group separation first, before we can move on, because this was actually my motivation to write that query and this blog post.

If you never think about it, or don’t even have an idea where the tables in the database are located, how big they are and how much rows your tables contains. You better take care of it…NOW!

Therefor i wrote a quick management query, especially aligned Read more…

Enumerate Database-Role Membership

November 12th, 2012 No comments

Hey Guy’s

here i am with my 1st SQL-Server Post!

If you want to know the membership of a database role, to what other database roles the role
belongs to, i have a good satatement for you.