Mohit Nayyar - MS SQL - Databases - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Databases > MS SQL

Expert Profile: Mohit Nayyar

Expertise: Microsoft SQL Server: T-SQL development (stored procedures, triggers, functions), Database optimization, performance tuning, high availability (Clustering, Log Shipping, Mirroring, Replication), scalability, SQL Server migration (Sybase/Oracle to SQL Server 2005), SSIS/DTS, Data Warehousing (SSAS), Reporting Services, database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.

Experience in the area
With over 8 years of experience in Database Administration, Development, Business Intelligence solutions, and managing enterprise level database solutions based on Microsoft SQL Server.
Publications
IT Magazine: ASP, SQL

Education/Credentials
MCA (Masters)

Awards and Honors
Brainbench Certified: RDBMS, MCTS: SQL Server 2005/Business Intelligence, MCITP: DBA/Developer/BI MCDBA

Ask a Question	View Past Answers	View Ratings

Something interesting about this subject that others may not know: http://mohitnayyar.blogspot.com

What do you like about this subject? I just love Microsoft SQL Server

Average Ratings
Prestige Points: 5338
Knowledge	9.80 Best of the best
Clarity of Response	9.70 Best of the best
Timeliness	9.68 Best of the best
Politeness	9.90 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		15
Total Questions (since joining AllExperts)		968

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
8	9	9	9	10/28/08
10	10	10	10	10/01/08
10	10	10	10	09/26/08
10	10	10	10	09/21/08
10	10	10	10	09/05/08

User Comments

thank you mohit for the quick response and i am glad to recieve your advice.
(Asa on 10/28/08)

Thanks Mohit. I was hoping I would not have to copy the the different calculations since they are rather long over again. Thanks for the prompt
(John on 10/01/08)

many thanks excellent as ever
(Oliver on 09/26/08)

Many Thanks for the answer
(Hemalatha R on 09/05/08)

View All Comments

Ask a Question	View Past Answers	View Ratings

Recent Answers from Mohit Nayyar

2008-09-17 Looking for Quiz or any small project related to SQL Server: Hi Sanlen There are multiple ways to do this. 1. Generally every SQL Server book has some quiz at end of each chapter, so try solving that by writing queries, procedures etc. 2. Restore the Northwind...

2008-08-18 triggers: Hi Oliver I didn't understand your question completely, so please check my answer on some basic assumptions. You need to use COLUMNS_UPDATED or UPDATE() to check if the binary column has been updated/inserted...

2008-07-21 ask a answer this question: Hi I didn't understand your question but I think that you need to move your data in text file to SQL Server table. If the above assumption is true then there are many options in SQL Server to do...

2008-07-11 Beginning SQL Server: Hi Charles I made a right decision, there is great future in Business Intelligence related work and Microsoft is doing really good in this field. I request you to brush/migrate your Access SQL Query...

2008-07-04 Default: Hi You can use this query to fetch information about table, columns and associated defaults and then using a cursor can delete the columns.... select object_name (t.object_id) Table_Name, c.Name...