ITDevSpace - Development Tips & Tricks

public class StoredProcedure { private static ILog log = LogManager.GetLogger(MethodInfo.GetCurrentMethod().DeclaringType); static public void Execute (DBSqlPath path , int connectionTimeout, int commandTimeout, string storedProcedureName, SqlParameter[] parameters ) { SqlInfoMessageHandler handler = new SqlInfoMessageHandler(); using (DBConn conn = new DBConn( path , connectionTimeout)) { conn.OpenConnection(); conn.SqlConnection.InfoMessage += handler.connection_InfoMessage; SqlCommand command = new SqlCommand(storedProcedureName, conn.SqlConnection); command.CommandType = CommandType.StoredProcedure; command.CommandTimeout = commandTimeout; foreach (SqlParameter param in parameters ) { command. Parameters . Add (param); } try { command.ExecuteNonQuery(); ...

Update Statistics UPDATE STATISTICS TABLE_NAME Rebuild Indexes ALTER INDEX ALL ON TABLE_NAME REBUILD

http://www.netlogics.ch/en/nantaddin.html It works with both VS2005 and VS2008

DECLARE @sp_who2 TABLE ( SPID INT , Status VARCHAR (255) NULL , Login SYSNAME NULL , HostName SYSNAME NULL , BlkBy SYSNAME NULL , DBName SYSNAME NULL , Command VARCHAR (255) NULL , CPUTime INT NULL , DiskIO INT NULL , LastBatch VARCHAR (255) NULL , ProgramName VARCHAR (255) NULL , SPID2 INT , REQUESTID INT ) INSERT @sp_who2 EXEC sp_who2 SELECT * FROM @sp_who2 WHERE Status > 'BACKGROUND'

Submit to Google Submit to Microsoft BING Submit to Yahoo (requires registration)

The web editor that provides the facilities to draw favicon or convert GIF, JPEG or PNG to favicon. Favicon Editor

Directory of various tools for Web Developers Open Web Tools Directory