Technology Archive

29 Nov 2013

Finding the Nth highest value in a table

I recently was asked by a colleague about finding the Nth highest value in a table. For example if there is an employee table then finding the 10th highest salary or something similar. I thought about it
8 Nov 2013

Experience with MS SQL Server

After years of experience with SQL server, I have gathered some of the practices that are good for writing SQL queries, procedures and functions. Here is my work as presentation, enjoy!! Sql good practices from Deepak Mehtani
2 Oct 2013

SQL Server Fun – Averages with Rollup

Here is tsql way of getting averages and also rolling up. Below example is using adventureworks database that is available with SQL server. It is getting average pay rate by each department and also overall by the
30 Sep 2013

My PMI 2013 conference experience – Healthcare in India

I recently attended the PMI 2013 National Conference hosted at “The Leela” Gurgaon. It was indeed a grand event that I enjoyed thoroughly. I was particularly intrigued by the presentation in the field of Healthcare in India
24 Sep 2013

Business Intelligence (BI)

What is business Intelligence I am sure a lot of people can define business intelligence but what we need to know is how it applies to us our business, our life and things we do. Over the
21 Sep 2013

How to get Windows Folder sizes recursively

Ever need to know the folder sizes that has several sub-folders, windows explorer takes really long time and requires checking properties of each folder. This script will do the job just need excel installed on your machine
21 Sep 2013

SQL Server FUN – Split received string using XML

Several time, we have a need to split the string based on a delimiter, for instance to handle multiple input filter parameters etc. Most of the time we end up using a user defined function that accepts
21 Sep 2013

SQL Server FUN – Identity insert

Insert in identity column for a table Sometimes there is a need to insert data into a table that has identity column. Example when you would like to restore a table from a backup including the same
21 Sep 2013

One of the all time technology world buzz word – “Lean”

I decided to find it little more about it. A new term has been coined, Lean software development. Well the work and definition below is from various sites and sources on internet. I would like to thank them
29 Aug 2013

Search Database for Keywords or across all tables

/* Visit my blog http://exuberantindia.com/ */ CREATE PROC dbo.KeywordSearchDB ( @SearchStr nvarchar(100) ) AS BEGIN CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT ON DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) SET  @TableName = ” SET