Well, I can not RDP the server. And I am not sure how the SSMS on client was installed as it is an old machine and is given to me...

I just went rhu the article. Thaks all... it was a new learning for me....

The answer to clustered index is surprising to me. I was under impression that query will always return sorted data, if we have clustered index.

I even tried it practically, and...

ok, but i am sure, clustered index always gets sorted data on key columns, without adding ORDER BY, Always.

Gail, I have gone thru your series on Index basics. That is...

yeah, transcenders will be a big help. they usually have a big set of questions, you know....

good luck to you.....

I am too looking for my upgrade, 70-453 somewhere in august...

Training kits are a good help. I did MCITP for 2005 and they were helpful. But i'll say , they alone are not sufficient. My perception is that as long...

Thanks ALZDBA. I'll run the advisor. Previous level was 90.I too hope that 100 should not be a trouble either. Moreover it is Dev and QA environment, so not a...

Sorry, I confused with PK. I actually have a unique clustered index on view. So its PK in one way.

Now another question coming my mind:

My view has three tables(say a.b,c)...

But in the view, there is no PK. So when indexed view will be updated for data, then only way to find that data to be updated is thru indexes....

ya, thats true as now sql server has to maintiain index as well. but the fear is that if i miss an index and an update happens on that column,...

The answer to first 2 questions is - No

For third, there are indirect ways like using a batch file to execute it, but practially they are not great ways to...

dear kumar..

i knew the basics in SQL. what i m asking is some example for executing sql query which is passed thru another function like follows:

select dbo.test('select colname from table')

so...

Here is an example:

ALTER FUNCTION [dbo].[fn_abc]

(

@a int = 0

, @b-2 int = -1

)

RETURNS int

AS

BEGIN

DECLARE @Result int

SELECT @Result = col1

FROM dbo.tab1

WHERE Col2 = @A

AND Col3=@b

-- Return the result of the...

at top level, you can say Insert,update,delete are not allowed in funtion.

Use stored proc instead.

Thanks for trying it. Actually the variable @test-2 you have used, is actually a very long select clause in my case (100 lines to be precise). So every time I...