THANK YOU MY DEAR FRIEND

I MEAN ANY QUERY TO INDICATE THAT THERE IS MULTIPLE DATA FILES FOR SINGLE DB.....

sql query to find out Tempdb data file is on its own disk volume?

thanx

thanxs

tempdb per processor cores configuration.

is there any relation in

"number of processor core " = "number of tempdb files"?

i mean check whether 'Instant file initialization' is enabled or not?

hi

i using sql server r2 and the corresponding native client also installed

i have the following:

Stored Procedure 1 calls Query 1

Stored Procedure 2 calls Query 2

i would like to have:

Stored Procedure 3 calling Query 1 and Query 2 and then combine results.

Query...

Update Target

Set Address2=Source.Col_Addr2

From Table1 Target

JOIN Table2 Source on Target.Address=Source.Col_Addr1

Where

Target.Address2!=Source.Col_Addr2

AND Target.Address2 IS NOT NULL

AND Target.TIME >= Source .TIME

is this right?

the condtions to update 'TARGET' table are

1. Target.Address2 is null

2. Target.TIME...

If i want to add more condtion where i put the condtion

Update Target

Set Address2=Source.Col_Addr2

From Table1 Target

JOIN Table2 Source on Target.Address=Source.Col_Addr1

Where

Target.Address2!=Source.Col_Addr2

AND Target.Address2 IS...

ie,

Update Target

Set Address2=Source.Col_Addr2

From Table1 Target

JOIN Table2 Sourceon Target.Address=Source.Col_Addr1

Where

Target.Address2!=Source.Col_Addr2

AND

Target.Address2 IS NOT NULL

AND

is it?

if i want to add more condition , can i put...

but the problem is that i dont want to update 'Target.Address ' , if it is not

NULL .

the checking is actually done on TARGET TABLE not in SOURCE...

Update Target

Set Address2=Source.Col_Addr2

From Table1 Target

JOIN Table2 Source on Target.Address=Source.Col_Addr1

AND Target.Address...

i hv interest in both T-SQL developer and DBA .