You are here:

MS SQL/Expert Profile

Mohit Nayyar

U.S.

Available

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), SSIS/DTS, Data Warehousing (Kimball Methodology), ETL (SSIS), Cube (SSAS), Reporting Services (SSRS), database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.

Experience in the area

With over 10 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

Publications

IT Magazine: ASP, SQL
SQLServerCentral.com

Education/Credentials

MCA (Masters)

Awards and Honors

Brainbench Certified: RDBMS
MCTS: DBA/Developer/BI for SQL Server 2005/SQL Server 2008
MCITP: DBA/Developer/BI for SQL Server 2005/SQL Server 2008
MCDBA: SQL Server 2000
MCP: SQL Server 6.5

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
olayemi	03/22/12	6	6	6	Am not understand the answer
debbie	02/01/12	10	10	10	Thank you ~ very nice resources.
Dmitriy	01/12/12	10	10	10	Thank you!
Dmitriy	08/19/11	10	10	10	Thank you.
Sher	07/30/11	8	9	10	Your blog is last time updated on .....

Recent Answers from Mohit Nayyar

2011-09-07 Select Match Problem:

Hi Alp I have 2 options to resolve this... --Option 1 select t1.member, t1.Status, t2.Status from Members t1 INNER JOIN Members t2 ON t1.member = t2.member WHERE t1.Status = 1 AND t2.Status =

2011-08-29 Return an integer:

Hi Alp There are various ways, but you can use IF EXISTS or @@ROWCOUNT to start with... SELECT Name FROM Customers WHERE CustomerID=3000 SELECT @@ROWCOUNT AS TotalCount The above query will return

2011-07-22 Using DSN to access Database:

Hi Tyler I am not very well familiar with MFC. I am little confused here. You are refering to DSN and Connection string. And why DSN in the database. DSNs are system specific or file based. So

2011-05-15 Group By:

Hi JD, please use the ROW_NUMBER function to get the same. Please run this script to get the results. CREATE TABLE #temp ( Name VARCHAR(5), State CHAR(2), Sales SMALLINT ) GO INSERT INTO #temp

2011-03-30 Full table scans ignoring index:

Hi Bill Selection of non-clustered index depends upon the uniqueness of the data and in your case it doesn't seem to be the case. Also, I might need to look at the execution plan to come up with

MS SQL

Answers by Expert:

Browse Answers: