You are here:

MS SQL Server/Expert Profile


Ask A Question

Jwalant Natvarlal Soneji

India
Available

Follow me on:
      

Expertise

From general queries about SQL Severs both 2000 and 2005 to advanced features like Integration Services and Reporting Services.

Experience in the area

Experience in the area: I have been working with database triggers, stored procedures, views, function, joins, dts, Query optimization. Education/Credentials: BE IT - 2005 Batch with First Class.

Publications

http://jwalantsoneji.com

Education/Credentials

BE IT, India

Awards and Honors

MCP

What do you like about this subject?

Its changing everyday and so one can get many things to learn.

What do you still hope to achieve/learn in this field?

Data warehousing.

Something interesting about this subject that others may not know:

The pronunciation of the word "SQL" is sequel or S Q L, which is more official?, as Microsoft it self sometimes say sequel, is still a mystery for me.


This expert accepts donations for Sewa International USA Inc.:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Tejus12/10/14 
Rakesh03/11/14101010 
Eduard11/08/13101010Thanks Boss! This phrase was a key .....
katt11/06/13101010Awesome...Thank You
AJ07/27/12101010 

Recent Answers from Jwalant Natvarlal Soneji

2015-06-19 To improve sql query performance:

Dear Karan,    We will need more details to know which component is causing the delay.    It could be something in the frontend before or after database calls.    Please use built in tools in your Internet

2015-04-18 Accessing database without getting noticed.:

HI Rajiv,    These activities are not unnoticed.  In fact, big websites expose their database in controlled manner.  This is mostly done through API.    If u search for API Premier league fantasy, you

2014-10-30 Adding 1 to a NVARCHAR variable:

Dear Tejus,    Apologies for late reply!    Here are some steps to help you get next User ID:  1. Get numeric component of user id such as "0026". RIGHT('BTBST0026', 4) can give that.  2. Convert this

2014-10-21 SQL for deal information:

Dear Matt,    My apologies for late reply!    Well, I believe, all these questions were more of home work....  Below are the queries those should work for you!      ###########  SELECT COUNT(1)  FROM Purchase

2014-06-17 Joining on "Similar" records:

Hi Richard,  The requirement is a tricky one.    The best approach as per my knowledge would have been to create a catalog table which would be the master table for items such as "ABC Bandaid", and then

 

Ask A Question

MS SQL Server

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2016 About.com. All rights reserved.