msSQL Session running on database
To see witch session id, that run command against a database, you can run this:
To see witch session id, that run command against a database, you can run this:
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…
With this query, you can see whitch database that is using most memory
Whit this code, you can see how much of query in percent at this moment is reading from the cache/buffer.
Run this command to see if any database on the SQL Server is using enterprise features
If you got an error about compression, when trying to attach the database from an enterprise version to a standard version. You will have to attach the database to an…
WIth this command you can see witch user that have SysAdmins access.
To show all MSSQL databases except the normal system databases.
To get a list of the databases files, and the current disk size in MB, and the Free Space in MB in each fil, you can use this commands If…
USE GO ALTER DATABASE SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(, 1) ALTER DATABASE SET RECOVERY FULL WITH NO_WAIT GO Where TestDB, is the database name, and TestDB_Log is the…