Undo send in Gmail

March 26, 2009 at 7:35 am (Technical, Tips and Tricks) (, , )

Gmail has another feather in its cap. Gmail has introduced a new funtionality in web mail to undo send email. Eventhough, I have seen this in email client application, Gmail is the one having this functionality in web application. Its a great advantageous feature. Click here to know more in detail about the functionality.

Whats next??? Undo Past events in Life 🙂

Permalink 4 Comments

DateDiff function in SQL Server

March 17, 2009 at 3:13 pm (SQL, Technical, Tips and Tricks) (, )

I frequently used to calculate date difference between two dates. I use to open the calendar and calculate the difference. But now I have found a easier way to calculate the date difference using the SQL DateDiff function

DateDiff returns the number of date and time boundaries crossed between two dates.

Syntax:

DateDiff(datepart, startdate, enddate)

Read the rest of this entry »

Permalink 4 Comments

KeyBoard shortcuts in Microsoft SQL Server

December 18, 2008 at 6:20 am (Technical, Tips and Tricks)

I was wondering for long days the keyboard shortcut for switching between Query and Result panes or windows, whatever you call them. Finally I moved a step forward to get the shortcut. Here is the shortcut to switch between Query and Result pane or window.

Switch between query and result panes -> F6

You can also find more keyboard shortcuts here.

Permalink 3 Comments

Manually register a dll in Windows

February 28, 2008 at 9:33 am (Technical, Tips and Tricks)

There will be a need to manually register a dll on few occasions. For example if you are generating a dll from a COM  application, you need to register it before using it. To register the DLL in Windows, you need to run a command. Click start -> Run. Enter regsvr32 “pathdllname.dll”.

Where path = the path where the dll is located and dllname is the dllname.

For Example if a dll say example.dll is located in c:projects directory then run regsvr32 “c:projectsexample.dll”. This will register the dll. By register i mean a entry will be made in the operating system registry .

Permalink 15 Comments

WITH (NOLOCK) IN SQL Server to improve performance

February 27, 2008 at 8:57 am (SQL, Technical, Tips and Tricks)

I used to see my senior developers use WITH (NOLOCK) when querying in SQL Server and wonder why they use. Now i explored it and found that its useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is currently being updated in the Table ie Without lock protection, you cannot be guaranteed that the data isn’t changing during the time that the query is running. I reffered this link and found it prettu useful.

Permalink 12 Comments

Creating own run command in Windows

December 7, 2007 at 11:51 am (Technical, Tips and Tricks)

Many tech guys would be thinking of creating their own run command. Yes !!! we can create our own run command.

Step 1: Create the shortcut for the folder or tool for which you need to create the shortcut.

Step 2: Open the run command and goto \Windows

Step 3: Paste the shortcut to that folder and change the name of the shortcut to run command as we want.

Now we can open the folder or tool from run command using the name we have given for the shortcut.

Permalink 19 Comments