It is really interest to know about query plans, perticularly about realworld situations. I am also facing similar situations so many times in my production enviorment.

-Madhu.

Hi,

Can U provide some sampe data...so that I can build a query.

Madhu

SQL Service version in my system is

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

Dec 17 2002 14:22:05

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows NT 5.0 (Build...

Hi,

What Jonathan given is quite intellegible solution to the topic. I really learn a lot from those queries.

Thanks Jonathan...,

Madhu

Yes, QA is best one or you can use it as code programatically using VB etc.,

let us assume you want to update price field in table A with ColX in...

Hi,

I have 4+ years experience, but staying in India. Does it ok for you if the person from outside of America...

Madhu

There is a way to change it. But we need to write script as per my knowledge.

Madhu

Hi,

I am sure, 'width' column would have allowed null values when it's datatype is INT. So, if you remove NOT NULL from your ALTER statement. It works.

Just check it once.

Madhu

Hi,

I hopw this link may help you.

http://www.sybase.com/detail?id=1012153

Madhu

I hope U get what U want from Execution palns. We can set it from QA(QueryAnalyser). Just go to Query option in QA and select Show execution plan. or

Other...

I executed same commands on my server, but I got result like this

Volume in drive C has no label. ...

What is the recovery model of your database??.

madhusudannaidugundapaneni

Is there log file. If it exists, rename log file and just use attach mdf file by using sp_attach_db. It works, automatically it creates new log file. Be remember log...

As it is part of a stored procedure. My procedure displays contents of a text file which is in C drive. If I view those contents in text mode, I...

Thanks for your replies. As I already specified, I want it with the help of t-sql commands.

madhusudannaidugundapaneni