T-SQL usefull stuff

Move table to different schema

ALTER SCHEMA targetSchema TRANSFER sourceSchema.tableName

Rename object

sp_rename 'schemaName.tableName.columnName', 'newColumnName'




Close all connections to database

USE master;
GO

ALTER DATABASE dbName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

ALTER DATABASE dbName
SET MULTI_USER;
GO

Running IIS7 in 32-bit mode

Very interesting article about running 32-bit and 64-bit ASP.NET versions at the same time on different worker processes

http://blogs.msdn.com/b/rakkimk/archive/2007/11/03/iis7-running-32-bit-and-64-bit-asp-net-versions-at-the-same-time-on-different-worker-processes.aspx

IntelliTrace silently eating-up disk space

Good article on why, if you are using IntelliTrace, you can suddenly run out of disk space.

http://social.msdn.microsoft.com/Forums/en-US/vsdebug/thread/e53aab69-75b9-434a-bde3-74ca0865c165/