You are here:

MS SQL Server/Expert Profile

Jwalant Natvarlal Soneji

Canada

Available

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://jnsoneji.blogpost.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.

Average Ratings

Recent Reviews from Users

User	Date	K	C	P
John	03/14/12	10	10	10
John	03/14/12	10	10	10
Mike	03/13/12	10	10	10
John	03/13/12	10	10	10
Dmitriy	08/29/11	10	10	10

Recent Answers from Jwalant Natvarlal Soneji

2012-03-19 MS Access/SQL Server:

Dear Betsy, Thanks for coming back! Yes, you can link an access file to SQL Server and it will not slowdown. The link given in the previous reply has the same information of linking an access file

2012-03-01 MS Access/SQL Server:

Hi Betsy, It can be tricky to control performance of the combined database usage as per your requirement. Could you please suggest what syntax are you using to fetch data from MS Access? Also

2012-02-12 Difficult Query:

Hi Richard, Apologies for late reply... Well, there will be some good SQL clauses which you can use to roll-up, though as a simple way, the query below might help. Let me know.. #################

2012-01-21 sql query:

Dear Rakesh, It seems that you want only 4 records out of whichever has price=2000. So, if there are 10 records which has price=2000, you want to get only 4 records from those; correct? In that

2012-01-12 sql query:

Dear Rakesh, I think you mean that total 15 records have price more (or less) than 2000. It should be a fairly simple query using WHERE clause by putting all filter criteria in it. Like---

MS SQL Server

Answers by Expert:

Browse Answers: