Category: TSQL
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
2009-06-22 08:37, by Torsten Schüßler, Categories: SQL-Server 2005, SQL-Server 2008, TSQL , Tags: backup, index, integrity, maintenance SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization more »
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
2009-04-20 08:23, by Torsten Schüßler, Categories: SQL-Server 2005, SQL-Server 2008, TSQL , Tags: backup, index, integrity, maintenance SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization more »
German translation of Tibor Karaszi`s updated datetime article
2008-11-27 00:53, by Torsten Schüßler, Categories: SQL, SQL-Server 2005, SQL-Server 2008, TSQL , Tags: datetime German translation of Tibor Karaszi`s updated datetime article more »
List all tables with specified field
DECLARE @COL_NAME NVARCHAR(50)
SET @COL_NAME = '%SOMESTRING%'
SELECT DB_NAME(DB_ID()) AS DatabaseName,
B.name AS TableName,
A.name AS ColumnName
FROM sys.syscolumns AS A INNER JOIN
sys.sysobjects AS… more »
BgInfo, WMI and SQL Server
2008-06-27 11:23, by Torsten Schüßler, Categories: SQL, TSQL , Tags: script, serverproperty, services BgInfo from Sysinternals (now Windows Sysinternals, by Mark Russinovich) automatically displays relevant information about a Windows computer on the desktop's background, such as the computer name, IP address, service pack version, and more interesting f… more »
:: Next >>
XML Feeds
©2010 by tosc
Contact | Blog theme by Asevo | multiple blogs | web hosts