Category: MSSQL

0

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 the cache. Witch the...

0

See if a database is using Enterprise features of an Microsoft SQL server.

Run this command to see if any database on the SQL Server is using enterprise features

 

0

MSSQL see witch user that have SysAdmins access

WIth this command you can see witch user that have SysAdmins access.

 

0

MSSQL Databases

To show all MSSQL databases except the normal system databases.

 

0

MSSQL Free Space in Databases files

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 you need a...

0

Shring SQL log file

USE [TestDb] GO ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE([TestDb_Log], 1) ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT GO   Where TestDB, is the database name, and TestDB_Log is the SQL Log file name.