Android soft keys unresponsive/dead/not-working

I had my soft keys dead for a about a month. Read various blogs and articles and how to fix them. Finally ended up using tools like floating soft keys and pie controls. 

I knew, it was because of power fluctuations that my soft keys were dead. There was nothing i could do about it. But today to my surprise they started working absolutely fine. I tried and analyse what happened to make it work. Following was different than everyday and one of these was what fixed it. Anyone with soft keys unresponsive issue can try these and confirm if it works for them.

1. I did not charge my phone with the cable slightly broken at the edge. (It charges just fine and the wire is not completely out but could have been the issue.

2. I did not charge the phone for a full stretch of 24 hours. Luckily did not run out of battery.

3. Charged only using use on my computer/laptop.

And so far it has been acting normal and haven't noticed any unresponsiveness since.

Try out and let me know if this simple thing works for you.

Uber - Double Referral Coupon/Promotion Code - dw3ax

Uber - Double Referral Coupon/Promotion Code - dw3ax

Use the code dw3ax to get double the referral amount.

To Avoid exponential notation for long numbers in excel

<quote>

I had this with list of long numbers, about 14000 entered into one column. I highlighted the column, Data -> Text to Columns -> Fixed length -> Don't create any break lines. Clear any that show up -> Select column data format text -> Finish. Worked like a charm.

</quote>

Source: http://superuser.com/questions/33685/how-can-i-avoid-excel-reformatting-the-scientific-notation-numbers-i-enter

To register multiple dlls or ocx in a folder ... (regsvr32)

to register all dlls in a folder go to the folder and execute the following command:

for %i in (*.dll) do regsvr32 %i

replace *.dll with *.ocx to register ocx files

Solution: Terrible lags/delays when dialing a number on Android phones

Solution: Terrible lags/delays when dialing a number on Android phones

I was fed up with this problem. I tried every possible thing i could thing. Finally what worked out for me was disabling the usb debugging and mock location settings.

Goto Settings->Application->Development

and uncheck usb debugging and mock location settings.

After this dialing has not been a problem.

Outlook 2010 taking forever to download emails from exchange server.

Recently I'd observed an issue where the outlook would take forever to download new mails and just kept saying "Updating this folder.." in the status bar. I never used to get the emails in time and was getting late in responding because they never arrived :(

I tried several methods but the following is what finally worked for me. Give it a try and see if it works for you too.

GOTO:

File -> Account Settings -> Account Settings -> Data Files (tab) -> <Select the mailbox> -> Settings -> Advanced -> Outliik Data File Settings -> Compact Now

SQL SERVER 2008 :: Quick search / Shortcut to search Objects in the database (Tables, Views, Stored Procedures Etc.)

Sometimes we have so many objects in the database (views, tables, stored procs, functions etc) and it gets difficult to look for the required objects when we have to scroll through a drop down showing 1000s of objects.

I've written this simple stored procedure to help make the search easier.

 

CREATE PROCEDURE [dbo].[usp_Search]     

(     

@spname varchar(50)     

)     

AS     

BEGIN     

     

      /************************************************************

      AUTHOR: Viral Patel

      DESC: Quick search for all objects with specified string in

                  their names

      USAGE: Exec usp_Search 'string to search'

      ************************************************************/

 

 

      declare @QUERY varchar(500);   

      -- views 

      SET @QUERY = 'select * from sys.all_objects where type = ''v'' and name like ''%' + @spname +'%''';     

      print @QUERY     

      EXEC SYS.SP_SQLEXEC @QUERY ;     

      -- user tables

      SET @QUERY = 'select * from sys.all_objects where type = ''u'' and name like ''%' + @spname +'%''';     

      print @QUERY     

      EXEC SYS.SP_SQLEXEC @QUERY ;   

      -- stored procedures

      SET @QUERY = 'select * from sys.all_objects where type = ''p'' and name like ''%' + @spname +'%''';     

      print @QUERY     

      EXEC SYS.SP_SQLEXEC @QUERY ;   

     

      -- you can also add other objects type as per your requirement in the stored proc.

      -- Following are the types for various objects

     

      --FN  SQL_SCALAR_FUNCTION

      --IF  SQL_INLINE_TABLE_VALUED_FUNCTION

      --F   FOREIGN_KEY_CONSTRAINT

      --U   USER_TABLE

      --FS  CLR_SCALAR_FUNCTION

      --UQ  UNIQUE_CONSTRAINT

      --SQ  SERVICE_QUEUE

      --D   DEFAULT_CONSTRAINT

      --S   SYSTEM_TABLE

      --AF  AGGREGATE_FUNCTION

      --P   SQL_STORED_PROCEDURE

      --PK  PRIMARY_KEY_CONSTRAINT

      --V   VIEW

      --IT  INTERNAL_TABLE

      --X   EXTENDED_STORED_PROCEDURE

      --PC  CLR_STORED_PROCEDURE

      --TF  SQL_TABLE_VALUED_FUNCTION

END  

You can also create a keyboard shortcut to do the search... I prefer "Ctrl + 3"

Steps to create a short cut in SSMS:

Goto Tools->options->Environment->Keyboard

Scroll down to the desired shortcut you'd like to use and enter the stored proc name there. Few which i have created are here:

All you need to do after creating a shortcut is to select/highlight the parameter to pass in the query window and press the shortcut. Thats it!