Hi, thanks fo reply, I donot have rights for SQL Profiler and other way to get that ? thanks in advance
Hi, I am running a stored proc that is using UDFs. When I try to see the statistics by SET STATISTICS ON. It is not giving me the values for tables...
Hi , I have two queries having same output but differ in n the execution plan one using : Merge Join(Concatenation) second : Merge Join (UNION)...
Hi , I have two tables in having one to many relation between them , I want to archive the data of these tables to other Arhived tables having same...
Does SQL Server Express Edition with Advance Services have Integration Services...
Hi , I have got Tables and Columns description from Oracle Database in comma delimited text file as follows Table Column...
Thanks Satya !! Is there any way to tell SQL Server that do not go for FT indexing for documents of some types (e.g.pdf,bmp etc.). 1) One way is...
Hi, I have table with varbinary(MAX) column to store doucment (txt,doc,xls,PDF,Images) . I have created the Full text index on this column. As we...
Thanks Satya for guidance. I am trying for get Hardware configurations , Once i get it i will share it with you. Regards, Avnish Kumar
Hi 1) Application frequently connects the table for data for both ( inserting new data and searching for existing data). 2) hardware info is not...
Hi I am not able to take decision by reading the articles sent by both of you. My Question is what decision you guys would have taken if you faced...
Hi ,I have table that contains near about 40 fields and search is required on all these 40 fields so for the performace perspective what you guys...
Hi all I have data entry form having more than 200 fields. I have to capture and retrieve data frequently. Pls. let me know the best way to design...
Separate names with a comma.