Skip to main content

Posts

Showing posts from May, 2017

TOP 10 facts You need to Know about India

Famous and Historic Places to visit In India

1. The Red Fort, Delhi 2. The Taj Mahal, Agra 3. Pangong Lake, Ladakh 4. Valley of Flowers, Nainital 5. Jaisalmer Fort, Jaisalmer 6. Ruins of Hampi, Karnataka 7. Ghats at Varanasi, Uttar Pradesh 8. Backwaters, Kerala 9. Old Goa, Goa 10. Umaid Bhavan Palace, Jodhpur 11. Jama Masjid, Delhi 12. Akshardham Temple, Delhi 13. Old Bombay, Mumbai 14. Ajanta and Ellora Caves, Aurangabad 15. The Golden Temple, Amritsar 16. Charminar, Hyderabad 17. Amber Fort, Jaipur 18. Rashtrapati Bhavan, Delhi 19. Mahabodhi Temple, Bodh Gaya 20. Meenakshi Amman Temple, Madurai 21. Khajuraho Temples, Chattarpur 22. Elephanta Caves, Mumbai 23. City Palace, Udaipur 24. Havelock Island, Andamans 25. Tirupati, Chittoor 26. Tawang Monastery, Tawang 27. Kaziranga National Park, Assam 28. Kesaria Stupa, Kesaria 29. Palitana Temples, Bhavnagar 30. City Palace, Jaipur 31. Sun Temple, Konark 32. Rani Ki Vav, Patan 33. Chaturbhuj Temple, Orchha 34. Cellular Jail, Port Blair 35. Borra Cav

SQL Server Tips for Memory usage,replication,CU updates etc

1. To check which user is taking maximum memory usage in SQL 2014 You can try below command select * from sys.sysprocesses sp_who2active 2. How to rename a column in subscription table in replication You have to remove from replication: Rename. and then re-add to replication 3. Clear cache in SQL for TempDb. RUN THIS COMMAND ON TEMPDB  DATABASE ONLY DBCC FREEPROCACHE  4. How to install the Service pack 3 on server,This is my recommendations . Server: SQL server 2012 standard edition having sp1 and you want to install the SP3 and CU 7 at a time ? Then you can install SP3 and check if that covers CU 7 as well, if not then you can install CU 7 after the SP3 Successfully installed. But make sure to take the DB Backups prior to proceed 5. Resolve Authentication Error for Mailbox in SQL Error is Mailbox unavailable. The server response was: Authentication is required for relay in SMTP server If You are providing the server address like Server ip without login