I am not aware of BIML.

Could you please provide me more information or some links to understand BIML so that I can move further on the same.

Thanks

Yes, I already used that 'Suggest type'.

But I need some way by which I can add column names and their data types from any CSV or tables from database rather...

Thanks John,

I am able to run [ select * from $(tbName) ] by passing parameter using SQLCMD.

Can we pass any path as parameter to SQLCMD, If yes then how to...

thanks for quick response john,

I also tried with sqlcmd and written below query in server.sql file

select * from $(tbname)

Need to know what is the exact way to execute batch file,...

Is writing File from sql server 2005 needed some rights for users,

I am not able to write a text file from Server 2005...

can any better suggestions that might work here

could u plz explain what u r trying to say..

@flame

I want to know how much time each procedure is taking to execute,

for this i have to make entry in .txt file, to track them..

hey guys

I would like to inform u,from now to till monday i'll not able to reply ur post...

but we will back on this performance tuning after monday..(24-10-11)

it will be...

@chris-2

"How long did this one take to run? There are a number of interesting changes in the plan as a result. "

are u talking abt index creation?

or any...

ya sure...u can see

CREATE NONCLUSTERED INDEX [IX_Testing] ON [dbo].[orderlines]

(

[prodline] ASC,

[ordernumber] ASC,

[enterdt] ASC,

[oetype] ASC,

[cono] ASC,

[transtype] ASC,

[operid] ASC,

[slsrepin] ASC,

[whse] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF,...

here is execution plan for covered index

oops........

sorry....by mistake ,i did't see this is warning

i will just place new execution paln here

By executed this I got an error:

Warning: Null value is eliminated by an aggregate or other SET operation.

Chris

I have executed Qry, and it took 71 sec. to execute

U can see EP.

Thanks for Reply Chris

I have executed all the 3 queries

and got these results

1st qry took:1sec

2nd-2 sec

3rd-2 sec

as u were expected ,here is improvement in execution time for 2nd Qry