MSSQL database roles get all securables – Full script out the Database Roles
admin Thanks for the script to John Eisbrener – Check for new version here: https://dbaeyes.wordpress.com/2013/04/19/fully-script-out-a-mssql-database-role/
database
MSSQL How long will data be in cache/buffer
How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in…
MSSQL: Whitch database used most memory
With this query, you can see whitch database that is using most memory
MSSQL Databases
To show all MSSQL databases except the normal system databases.