I have very large table .I have to show the information from table to user in pages.
after filtering the data through where clause.suppose based on...
Which driver is best in performance to use with sql server from java
web application (servlet , jsp)
I have table which contains city as one column.This table get lot of select
query statement and each select contain city column (in where clause)....
Which is better using the inner join outer join etc. clause or performing the
same operation with where clause
In Query Analyzer when i set the option of showing trace using Query menu.It shows
only the one event sp:completed .I want to get the other events...
I have stored procedure which has if else block .
I want to know whether if else causes recompilation of procedure.
Thanks in advance
Separate names with a comma.