INTEL GRAPHICS DOWNLOAD LINK

https://downloadcenter.intel.com/download/26228/Intel-Graphics-Driver-for-Windows-10-and-Windows-7-8-1-15-40-

Unable to connect Mi4i to Laptop via USB

Solution taken from  http://en.miui.com/thread-121129-1-1.html
First go to About phone in Settings, then tap continuously on MIUI version, it will now say a message, you are now a developer, something like that, then go to Additional setting in Settings, look for Developer options, then enter it and search for USB debugging and enable it and connect your mobile to PC afterwards.

Lose Weight Advice

1) 900 calories per day Diet Plan https://www.youtube.com/watch?v=08b10HacTyE   
       https://www.youtube.com/watch?v=KFuBiGxeH90


Inspiration Video  https://www.youtube.com/watch?v=S_dlkjwVItA

Data Grid View Property

1) If you want to change Column Header Colour in DataGridView then first you have to change Property "EnableHeaderVisualStyle" from True to False and then set back colour from property "ColumnHeadersDefaultCellStyle"

2) If you want to column width as per content then set property "AutoSizeColumnsMode" and "AutoSizeRowsMode" to AllCells

3) If you want to change Column Header Height then first change property "ColumnHeadersHeightSizeMode" from AutoSize to EnableResizing.

4) If you want to change row colour alternate then first set the Back colour from property "DefaultCellStyle" and then set the Back colour from property "AlternatingRowsDefaultCellStyle".

IFSC Code Database

Download from here https://www.rbi.org.in/scripts/neft.aspx

Click on "List of NEFT enabled bank branches (Consolidated IFS Codes)"

Note: May be name change of link where to download IFSC Code List of all banks in different sheets of a excel

Database Search Performance Improvement

Source : https://synametrics.com/SynametricsWebApp/WPTop10Tips.jsp

SQL optimizer heavily depends on indexes defined for a particular table. Indexes are double-edged sword: no index will degrade performance of your SELECT statements and too many indexes will slow down your DML (INSERT, UPDATE, and DELETE) queries. Therefore, it is important to have a right balance of index on tables. Besides the number of indexes, fields that are involved and their order is also very important.

Tip 1 - Avoid functions on RHS of the operator

Often developers use functions or method with their SQL queries. Consider the following example.
select *
from Customer
where YEAR(AccountCreatedOn) == 2005
and  MONTH(AccountCreatedOn) = 6
Note that even though AccountCreatedOn has an index, the above query changes the where clause such a way that this index cannot be used anymore.
Rewriting the query in the following way will increase the performance tremendously.
Select *
From Customer
Where AccountCreatedOn between '6/1/2005'

Note: Why indexes have a negative impact on DML queries - When an index is created, the data for indexed columns is stored on the disk. When new rows of data are inserted into the table or the values in the indexed columns are changed, the database may have to reorganize the storage of the data to make room for the new rows. This reorganization can take additional toll on DML queries. However, if you expect new rows on a regular basis in any table, you can specify the expected growth for an index.

Tip  - Drop indexes before inserting data

Consider dropping the indexes on a table before loading a large batch of data. This makes the insert statement run faster. Once the inserts are completed, you can recreate the index again.
If you are inserting thousands of rows in an online system, use a temporary table to load data. Ensure that this temporary table does not have any index. Since moving data from one table to another is much faster than loading from an external source, you can now drop indexes on your primary table, move data from temporary to final table, and finally recreate the indexes.

 

Nashik, Aurangabad, Indore and Ujjain Darshan

Home to Nashik

18th Nov 2015

Nashik railway station to Trimbakeshwar Temple upto 42KM
Take the bath on  Trimbakeshwar Kund

Note: 1) Reach before 8 AM in Trimbakeshwar 2) Take only Water and Milk for Pooja 3) Dont Purchase Prasad from Outside before Pooja

Visit Places in Nashik like Mukhtidham (4KM), Pandavleni Caves (12KM), Kalaram Temple (8KM) etc.

Nashik to Shirdi upto 90KM

Note: 1) Take only Flower for Pooja 2) Dont Purchase Prasad from Outside before Pooja

19th Nov 2015

Shirdi to Shani shignapur upto 73KM (By Tempo: Rs.80 per person)

Note: 1) Take only Tel and teel for Pooja 2) Dont Purchase Prasad from Outside before Pooja 3) Purchase prasad from Temple Counter

Shani shignapur to Aurangabad upto 81KM (By Bus: Rs.90 per person)

Aurangabad to Ghushmeshwar Temple upto 30KM (By Bus: Rs.35 per person)

Note: 1) Take only Water and Milk for Pooja

Aurangabad to Indore upto 411KM (By Bus: Rs.400 per person)

Note: Aurangabad to Omkareshwar Temple upto 342KM

20th Nov 2015

Indore to Omkareshwar Temple upto 80KM (By Bus: Rs.80 per person)

Note: 1)  Take only Water and Milk for Pooja 2) Stay at Gajanan Aashram (3 bed in Rs.475)

21st Nov 2015

Omkareshwar to Indore Sarwate Bus Stand (By Bus: Rs.80 per person)

Visit Places in Indore like 1. Khajrana Ganesh Mandir (4KM) -> 2. ISKON (7KM) -> 3. Rajwara (11KM) -> 4. Gomatti (12KM) -> 5. Ganesh Mandir (9KM) -> 6. Ranjeet Hanuman Mandir also have Nav Shani God (5KM) -> 7. Annpurna Mandir also have Ved God (2KM) -> 8. Vaishno Dham (2KM) -> 9. Lalbag Palace (2KM) -> 10. Kanch Mandir (2KM) (By Auto: Rs.800 Avg Total Distance:70KM)

Indore to Ujjain upto 57KM (By Bus: Rs.55 per person)

Ujjain to Mahakaleshwar Temple upto 4 KM (By Auto)

Note: Stay at Krishna Hotel very near to Mahakaleshwar Temple (3 bed in Rs.800)

22nd Nov 2015

Mahakaleshwar Temple Darshan

Visit Places in Ujjain like 1. Jantar Mantar 2. Mahavir Tapo Bhumi 3. Navgrah Shani Mandir 4. Shandipani Aashram 5. Mangalnath Temple 6. SiddhNath  7. Kaal Bhairav Mandir 8. Krishan Mitravrinda Dham 9. Vishnu Chatustika 10. Sthirman Ganpati 11. Gadhkalika Mandir 12. Bhrithari Gufa 13. Ramghat 14. Harsidhi Shakti Pith 15. Bade Ganesh (By Bus: Rs.60 per person)

23rd Nov 2015

Bashm Arti in Mahakaleshwar Temple

Note: 1) Come in line before 2:00 AM if you want pooja (jal chadana) before Bashm Arti. After Bham Arti, you can do pooja also. 2) In Bhasm Arti, Gents should be in Dhoti and Ladies in Sari with Lota.

ISCON Visit

Back to Home.