HI , please tell me some inbuilt tools to tune T-Sql in SqlServer-2005 apart from execution plan analsys?? Rohit Kochar MCP .Net(Web and SqlServer)...
thanks to all...i think link table is the best solution to my problem.. Rohit Kochar MCP .Net(Web and SqlServer) Company : TCS ,Noida
HI , What is the best way to implement many to many relationhip in sql server?? Suppose i have two tables teachers and class . A class can have many...
Fine i will go through derived tables ....one non technical qs <img src='/community/emoticons/emotion-1.gif' alt=':-)' />...<br />what does this 5...
Well , As I read and experienced table variables are faster than temporaray table but in case where original table you used to populate table...
Hi Adriaan , Right sql query analyzer is picking it from cache....But I am confused whether it has to do something with TempDB or not ?? I m using...
HI , I have tuned a sproc...initially it took 2 minutes ( 12381 rows ) to run but second time it took about 45 seconds ....and on production server...
Hi , The problem is solved...There is a option in SSIS package "Edit command line manually". I have set the password in the command arguments...
Hi , Surprised dint get any response...anyways i choose package protection level option as 'encrypt all data with password ' . I am not getting any...
Hi , I have created a SSIS package while running it . I am getting errors while package execution is in progress : 1) [OLE DB Destination [21]]...
Dear Mohammedu , I have applied the approach of SSIS package. It is working fine now . Now i want to run my SSIS package 'newpackage1' from commond...
Hi , I am running export - Import wizard to transfer data from tables from one Dataabse to other Database on the same server . I want to generate...
I agree with you Adriaan...Execution plan was also very similar... just filter search percentage was different and that too with a very less...
HI all , I have three version of a query that returns the same result . Query used in , like and = operator for searching ... I ran the three query...
Thanks kallis... I tried creating a NonClstrdIndex on Temp table and it dint throw any error.... But how can I be sure that this NonClstrdIndex is...
It is not possible to post sproc code here...as it is very very long... I just want the concept and i hope the questions are pretty clear.. Rohit...
Thanks Madhivanan for your reply and links . But these are very conceptual qs...u wont get this on normal Sql tutorials as I have gome through many...
hey that was so funny Kalis <img src='/community/emoticons/emotion-1.gif' alt=':-)' /> .....<br />I did not went for any interview..I was tuning a...
1) I am running query select * from <sometable>. Table has a clustered index and non clustered index. Will running above query result in table...
Separate names with a comma.
