Free SQL Server command line tool "SQLS*Plus"
There is a free SQL Server command line tool "SQLS*Plus" (on http://www.memfix.com ) - exactly like SQL*Plus for SQL Server. It is very flexible with data formatting (set lines size, p…
Showing posts from April, 2012
Moving the system database "tempdb"
If the system database "tempdb" is defined on several data files as recommended in general, each data file is moved by a ALTER DATABASE statement. USE master; GO ALTER DATABASE tempdb …
Modify SQL Agent Errorlog path and Default Database Path
If you are moving databases to a new drive/volume or another server (different drive letter), you will find it useful to also change the SQL Server Agent log path as well as the Database Default Loca…
TSQL Script to return files and Free Space
Here is the script ; WITH c AS ( SELECT g.name AS [FileGroupName] ,s.type_desc ,s.physical_name AS [FileName] ,s. size * CONVERT ( FLOAT , 8) AS [ Size ] , C…