Yes, Thats what I call the Comparison...

It's Really Informative.

Thank you,

Cheer!

Sandy.

"Excellent Script By Chris Kinley".

A Special Thanks goes to Steve & SQL Guru like {Gail, Jeff & others} for posting this kind of article in the forum which specify the...

Seenu,

Happy Valentine's Day 2 you too..

Love,

Sandy.

Bob Hovious (2/11/2009)

--------------------------------------------------------------------------------When a single address is joined to multiple tables, and belongs to multiple entities, you can't just update a record. If someone is listed as...

Hi,

You can check this code.

Run this query with Execution Plan and Check..

Cheers!

Sandy.

Grant Fritchey (2/11/2009)

--------------------------------------------------------------------------------

I would go with a single Address table and then join tables to the different entities that use it. This allows you to have a single source for...

Ninja's_RGR'us ,

Are you asking me or replying to my topic..

I am asking about the maximum number of users can connect to reporting server catalog at the same time.can you please...

smeet.seena,

Please check this.

declare @Sal decimal (16,2), @tsql varchar(4000)

set @tsql = 'select @Sal = salary from employee'

EXEC Sp_Executesql @tql, N'@sal decimal (16,2) OUTPUT',

@Sal=@sal...

[font="Comic Sans MS"]

Subha,:)

I really surprised what type of approval:D you need from your TL/PL for this...It's funny....:):P;):D:):w00t::cool::hehe:

Anyway, Subha, if you are really facing issue on your query and run sp_updatestats...

[font="Comic Sans MS"]

Subha,:)

Is it your local system or are you working on remote server??

and as Gail said how many rows it will return approximately and what is your machine configuration??

Cheers!

Sandy.

[/font]

Thanks.

Cheers!

Sandy.

I can't clear you up on my first part. A kajillion things means a LOT of them, many of which interplay with each other too. You simply cannot...

Chris, It is a very nice query but when i am trying to executed in SQL 2005 its working fine except the DB which is restored from SQL 2000 DB.

When...

Yeah Jeff,

Thanks .....I will check this..I will try to come up with new idea...

Cheers!

Sandy.

Hi All, Sorry for late reply...

Jeff, Thanks for your advice and The_SQL_DBA. Can you please suggest for some other idea also. I appreciate the idea given by you both really....