Table monitoring & Table informations in SQL-Server databases

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... Continue Reading →

2014-08-16 0

Enumerate Database-Role Membership

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. SELECT dbrole1.name AS dbrole1_name , dbrole1.principal_id , dbrm.role_principal_id , dbrole2.name ... Continue Reading →

2012-11-12 0

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑