Snipplr

(SQL) Find Keywords in SQL Server Stored Procs and Functions - marcocs

Wed, 23 Sep 2009 17:51:37 GMT

Find Keywords in SQL Server Stored Procs and Functions Written By: Tim Ford

(SQL) Last statement run for a specific SQL Server session - marcocs

Wed, 23 Sep 2009 17:49:45 GMT

Identify last statement run for a specific SQL Server session Written By: Tim Ford -- 7/22/2009

(SQL) Who block Who? - marcocs

Sun, 20 Sep 2009 18:12:17 GMT

"LEFT JOIN sys.dm_exec_sessions SB" only for test... It is not necesary becouse in a real block condition "blocking_session_id" is not null. so, when you have tested it just replace Left with INNER JOIN sys.dm_exec_sess... Good block detection to all!

(SQL) All Columns in a Table - marcocs

Wed, 16 Sep 2009 10:44:50 GMT

Simple but...

(SQL) Foreign Key with Action - marcocs

Wed, 19 Aug 2009 04:51:43 GMT

Foreign Key with actions on delete or update.

(SQL) Buscar tablas por tipo de columnas - marcocs

Fri, 31 Jul 2009 03:56:11 GMT

Buscar tablas por tipo de columnas; Note:AND OBJECT_NAME(object_id) NOT LIKE 'sy%': cuidado si tienes tablas que empiezan con "sy%"

(SQL) Buscar tablas por nombre de columnas - marcocs

Fri, 31 Jul 2009 03:53:37 GMT

Buscar tablas por nombre de columnas;