I know you people are contributing to the forum & we all appreciate that

Thanks for all your reply

I will look into this & if required will post again

Jeff Moden

I myself...

Waiting for reply

Thanks for your reply

You can find execute plan in following link which comes after i write SET SHOWPLAN_ALL ON

http://www.keepandshare.com/doc/view.php?id=159907&da=y

Data are in Sheet1 & Sheet2

I have given you table1 & table2...

Thanks for your reply

My Table Structure

Table1

Field1 - This is my primary key field

Table2

Field1 - Foreign Key

Field2 - Primary Key Field

Field3 - Transaction data

Now when i join above tables with...

Thanks for your reply

Is there any option in Query where i can use Index which is on field2 so i don't have to write order by clause in query &...

Can you tell me what is meant by TEMPDB isn't overloaded ?

(1)

select * from Manish_Mst_item WITH (INDEX =PK_Mst_Item)

INNER join  Manish_Trn_Item ON Sp_Item = It_No

When i run above query...

Thanks to all for your replies

It worked with []

Steve Smith, i need best practices if you can give which can be understand by anybody who looks into it.

Again thanks a...

Thanks for your response

Can u tell me why SQL Server Agent is shutting Down

This is what i got from LOG File

2006-04-06 03:15:04 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86...

Thanks for your reply

can anyone tell me how to start SQL Server Agent manaully i.e.

i want to write some BATCH file to start SQL Server Agent

You can do this way also

CREATE PROCEDURE dbo.Works_Usp_Test

AS

SELECT

 Emp_No

 , Emp_Name

FROM Mst_Employee

GO

CREATE TABLE #Temp

 (EMP_No INT

 , Emp_Name Varchar(100))

INSERT INTO #Temp EXEC dbo.Works_Usp_Test

This way u can insert records in #Temp Table,...

Thanks for your response

Can u give some suggestions on which i should go for Indexing & other issues to get better performance

we have created index & we have around 4...

you said - The optimiser will work out the best way to arrange the joins and should return the best choice for you

It means there is no need to put...

I got solution

instead of setting Parameter as TEXT Datatype for XML Parameter in Stored Procedure, we have changed it to NTEXT & it worked

TEXT datatype doesn't support Special Character while...

It is Very urgent

If i write something in Word File & Insert Bullet Also

& if i copied that in...

Thanks for your response

I have done same way but instead of integer type

i have taken RETURN type as TABLE & by this way i got Multiple Value in a Single...