\\Dev's Place: 2011

Dec 7, 2011

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

Oct 12, 2011

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 -

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

if(ApplicationSetting("DebugStartup"))

System.Diagnostics.Debugger.Break();

#end if

Aug 5, 2011

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

Jun 26, 2011

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..

Feb 20, 2011

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