SQL Lion

JOB Running Status Report in SSRS

Arun Mallick — Tue, 29 Nov 2011 07:52:40 +0000

Job Running Status report in SSRS for easy viewing and monitoring jobs running on servers. .rdl file attached.

Handling or Importing GUIDs in SSIS

Arun Mallick — Sat, 01 Oct 2011 09:23:56 +0000

Working on UniqueIdentifier GUIDs in SSIS while importing or exporting to Excel files and tips to handle special scenarios.

Monitor T SQL Query performance at millisecond level

Arun Mallick — Sun, 25 Sep 2011 16:53:03 +0000

Easy way to Monitor T-SQL Query performance at millisecond level as well as tracking logical and physical reads.

Football Team Location Problem

Arun Mallick — Mon, 19 Sep 2011 18:12:37 +0000

T – SQL challenge to solve Football Team Location Problem in a single query.

GO ‘N’ Times

Arun Mallick — Fri, 02 Sep 2011 16:40:34 +0000

GO ‘N’ times, i.e. execute t-sql batch scripts multiple times by just specifying one parameter to T-SQL batch separator command.

IDENTITY IN SQL

Arun Mallick — Sat, 20 Aug 2011 13:31:43 +0000

All features of SQL Server IDENTITY property of columns. And a handy procedure to monitor all Identity columns.

MDX DESCENDANTS

Arun Mallick — Tue, 02 Aug 2011 17:44:36 +0000

MDX function that returns the set of descendants of a member at a specified level or distance, optionally including or excluding descendants in other levels.

SQL Server CLR Integration

Arun Mallick — Mon, 17 Jan 2011 17:45:20 +0000

Detail elaboration of CLR Integration (C# .Net) with SQL Server and well explained examples.

Pattern Matching (Regex) in T-SQL

Arun Mallick — Thu, 30 Dec 2010 16:29:13 +0000

Get insights and analysis of textual data by powerful PATTERN matching methodologies. Learn and use various ways to do Regex (Regular Expression) PATTERN matching by SQL Server.

For each database – sp_MSForEachDB

Arun Mallick — Fri, 20 Aug 2010 02:51:55 +0000

Sp_MSForEachDB is a great procedure coming with MS SQL Server even though it is un-documented. It eases some of the complex operations that we mostly do by using CURSORS. Follow the link to know how…