@Br. Kenneth,

. yes you are correct and I am thinking in...

Hi,

. wow..nice script...:-)...very true.....I am having the same scenario. And index maintenance become a very crucial in this situation. I am using more or less same script to...

Thanks to all.. 🙂

Actually when we perform "TOP" for table having very large

row set (50000 or More) ;than "TOP" gives performance issue. It happens because according to sql architecture "TOP...

nice crish...

I am agreed with @vultar.

for more details follow this link

Thanks and Nice Quote ghanshyam 🙂 but

1.) Don't want to use id column

2.) Those technique I already used but that is not having less logical count.

Thank you very much Lowell...

Its help me a lot.. thanks again... :Wow:

thank you friends ,

I were just seeking for architecture of UDF.

ohh.. sorry my mistake .. I mean DDL TOO...

Thank you Jason. But can you put more focus on it.

like wise some time we have to do Complex query such...

Okay that was funny ....

I just want share one problem faced by me. this morning....

last night I were playing with network options and today I got one error while establishing...

select a.object_id

,SCHEMA_NAME(schema_id) as [SCHEMA]

,a.name as [Procedure]

,type

...

check for authentication mode

Nice Trick 🙂

Yes sir, I did it so but I were searching for that option.

Thank you sir :-),

but how could i do that.If my procedure...