Breaking Changes in SQL Server 2012
Transact-SQL Feature Description Selecting from columns or tables named NEXT Sequences use the ANSI standard NEXT VALUE FOR function. If a table or a column is named NEXT and the table or column is…
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…
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…