You are here:

MS SQL/Experts

Expert	Average Ratings	Expertise
Mohit Nayyar U.S. Available View Profile Ask A Question View Past Answers	Knowledgeability 9.81 Clarity of Response 9.71 Timeliness 9.70 Politeness 9.91 Total Questions 1013	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 (SSAS), Reporting Services (SSRS), database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.
Jwalant Natvarlal Soneji India Available View Profile Ask A Question View Past Answers	Knowledgeability 9.84 Clarity of Response 9.92 Timeliness 9.60 Politeness 9.92 Total Questions 144	Questions related to query optimization, finding complex results.
Manoj Rajshekar Available View Profile Ask A Question View Past Answers	Knowledgeability 9.70 Clarity of Response 9.70 Timeliness 9.68 Politeness 9.91 Total Questions 482	Anything on MSSQL Server 2005, 2000, 7.0 and 6.x. Anything on MYSQL,MSAccess, DB2 UDB Anything on Database Programming/Scripting.

Expert

Average Ratings

Expertise

Mohit Nayyar

U.S.

Available

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 (SSAS), Reporting Services (SSRS), database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.

Jwalant Natvarlal Soneji

India

Available

Questions related to query optimization, finding complex results.

Manoj Rajshekar

Available

Anything on MSSQL Server 2005, 2000, 7.0 and 6.x. Anything on MYSQL,MSAccess, DB2 UDB Anything on Database Programming/Scripting.

Volunteer to be an expert in this category

Recent Answers

2009-11-06 Reporting Services Query:

Hi Can you please check the "Report Services Configuration Option" and make sure that the user trying to access has required permissions and everything is setup over there. Can you also explain the

2009-10-26 Connection:

Hi Rashid It looks like that the machine doesn't have the required provider. Try changing the provider to SQLOLEDB and see if works. Its good to use Native SQL Client if you are going to use the

2009-10-07 Capturing Search String entered in UI:

Dear Arun, Sorry for very late reply. It depends on the UI architecture how you can grab the search strings. You may grab the string user entered and store in the XML for a while and then pop them

2009-10-07 unmatched queries:

Hi Ken Apologies for delay in response. You have to use IN or OR operators and can use the same in Case statement to get YES/NO type results. SELECT CASE WHEN Id = Group1 THEN 'Yes' AS Group1

Answers by Expert:

Browse Answers: