I am back now :)

After a long time, I am thinking to write again.. Hope I can continue writing :)

Best Practice for deleting large records from a table

Request Timed out for Large Table records delaetion.

Even sometime it sayes Transaction Logs Full, or sometime Memory Issues...

So here i get the Best Practice for deleting large records from a table...

WHILE (SELECT COUNT(*) FROM <table name> WHERE [Filter Condition] > 0
BEGIN
DELETE TOP 10 FROM <table name> WHERE [Filter Condition]
END

Debug (F5) Global.asax.cs Application_Start() Method

Many Times we need to debug the Application_Start on server where we can not debug with Visual Studio IDE, instead we use CLR Debugger. So debugging on Global.asax.cs is deifficult as you need to attach the W3WP process, but it starts only when your application get a first hit, and so Application_Start code already executed. So how we can debug ??

So I was reading few discussion over mail thread when I came across this wonderful ideas.

(Hey Guys accept my thanks and from others as well [who read this ] for your good debugging tricks.)

So here we goes -

1. Put delay in Application_Start Methods first Line as approx. you need to attach the debugger.
2. #if DEBUG

                       if(ApplicationSetting("DebugStartup"))

               System.Diagnostics.Debugger.Break();

            #end if

Iftaar Timing Noida Delhi 2011

Noida & Delhi

	Date	Day	Sehar	Iftar	Date	Day	Sehar	Iftar
2-Aug	Tue	4:16	7:12	17-Aug	Wed	4:28	7:00
3-Aug	Wed	4:17	7:12	18-Aug	Thu	4:29	6:59
4-Aug	Thu	4:18	7:11	19-Aug	Fri	4:30	6:58
5-Aug	Fri	4:19	7:10	20-Aug	Sat	4:30	6:57
6-Aug	Sat	4:19	7:09	21-Aug	Sun	4:31	6:56
7-Aug	Sun	4:20	7:09	22-Aug	Mon	4:32	6:55
8-Aug	Mon	4:21	7:08	23-Aug	Tue	4:32	6:54
9-Aug	Tue	4:22	7:07	24-Aug	Wed	4:33	6:53
10-Aug	Wed	4:23	7:06	25-Aug	Thu	4:34	6:52
11-Aug	Thu	4:23	7:05	26-Aug	Fri	4:35	6:50
12-Aug	Fri	4:24	7:04	27-Aug	Sat	4:35	6:49
13-Aug	Sat	4:25	7:03	28-Aug	Sun	4:36	6:48
14-Aug	Sun	4:26	7:03	29-Aug	Mon	4:37	6:47
15-Aug	Mon	4:26	7:02	30-Aug	Tue	4:37	6:46
16-Aug	Tue	4:27	7:01	31-Aug	Wed	4:38	6:45

MOTHERS & CHILDRENS

Pencil: I'm sorry

Eraser: For what? You didn't do anything wrong.

Pencil: I'm sorry cause you get hurt because of me. Whenever I made a mistake, you're always there to erase it. But as you make my mistakes vanish, you lose a part of yourself. You get smaller and smaller each time.

Eraser: That's true. But I don't really mind. You see, I was made to do this. I was made to help you whenever you do something wrong. Even though one day, I know I'll be gone and you'll replace me with a new one, I'm actually happy with my job. So please, stop worrying. I hate seeing you sad. :)

I found this conversation between the pencil and the eraser very inspirational.

Mother is like the eraser whereas their children are the pencil.

She is always there for their children, cleaning up their mistakes.

Sometimes along the way...  She get hurt, and become smaller (older, and eventually pass on).

Though her children will eventually find someone new (spouse), but she is still happy with what she do for their children, and will always hate seeing her precious ones worrying, or sad.

This is to all the MOTHERS & CHILDRENS..............!!!!!!!!!!!!!!!!!

Ref: Dont know the origin but I get it from Ahsan

P.S. Thanks a lot (whomsoever compose it) for writing such a wonderful inspirational message..

How to pass variable to sql script from batch file?

How to pass variable to sql script from batch file?

1.       Create a Table called Employees

id int

fname varchar(50)

lname varchar(50)

dept varchar(10)

2.       Insert few records into it as

Id            fname                   lname                   dept

01           Mohd                    Irfan                      IT

02           Gaurav                  Thakur                  IT

03           Animesh              Mishra                  Security
04           Ashok                   Roy                        Admin

3.       Create the sql script as getEmployees.sql

use $(dbname)

select * from $(tablename)

4.       Create the runsqlscript.bat file for running the sql script as below.

sqlcmd -S %1 -i getEmployees.sql -v dbname = %2 tablename = %3 -o %4

5.       Run this command from cmd.

>runsqlscript.bat SQLServerName DBName Employees D:\EmployeesList.txt

Ref - http://blogs.msdn.com/b/ssehgal/archive/2009/04/03/passing-parameters-to-sql-script-using-batch-files.aspx

HCL Care Noida

Hcltouch Number for Noida - 18601800425

For Desktop - Monday to Saturday 9:00 AM to 5:00 PM

For Labtop - 24x7