Mahipal Padigela's Blog

Troubleshooting Performance Problems in SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

Memory configuration settings in SQL Server

some useful links on SQL Server memory management:

http://sqlnerd.blogspot.com/2007/07/further-explanation-of-sql-memory-use.html

How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005

http://support.microsoft.com/kb/918483/en-us

Querying table, column names and datatypes – Sql Server 2005

Select
a.name TableName,b.name ColumnName,c.name DataType
FROM sys.tables a
	inner join sys.columns b on a.object_id=b.Object_id
	inner join sys.types c on b.system_type_id = c.system_type_id
order by a.name,b.name

Tags: column names, datatypes, Sql Server 2005