Hi Jessie and Jeff...thanks for taking the time...I might have not explained the scenario correctly and I apologise...

Here is how things go on:

The BOBJ developers design a "Universe" that contains...

Not sure if I know the answer to the question of sp_prepare being "required" by the driver. But that is how the queries are being called.

I am looking for the...

Mark and Chris...thank you for your input. I havent yet got a chance to test them; but they do look promising.

1. Technically, it is not an indexed view until you create an Clustered Unique Index on the view. So you do need atleast the Clustered Unique index to call it...

First thing I would look into is to move the EXEC out of the loop. Make your @sqlstatement to be the complete update string...dont execute for each iteration....just build the...

There are certain conditions and requirements to create and use indexed views; each of which can result in certain advantages and disadvantages....The following may not be an exhaustive list, refer...

Thank You Sean....I have currently implemented it by relying on the constraints. For now, we have decided to go with this as it seemed more elegant.

Lynn...since D is not present in the parent table, none of A, B, D should be inserted even though A and B are present in the parent table.

The overarching question...

Ken,

Since BusinessEntityId is the Clustered Key, the data is sorted in the table is physically stored in its order. And since BusinessEntityId is being used in the join condition, it...

So you are recommending to do the check in the proc itself, rather than relying on the table definition to drive the logic?

Hi Sean,

Prehaps I am not being clear. Kindly excuse my explanation skills.

The reason I am doing a left join is this. Lets say the parent table has string_vals 'AAA', 'BBB',...

Also look at Microsoft SQL Server Analysis Services Unleashed for more information and a different perspective. It is written by the actual developers building SSAS. I am currently going through...

You would write a two step Select...the first select being a Subquery/CTE that uses either Window Functions or the min(price) grouped by product name. Then the second select would be...

Thank you very much. Excellent book and taught me quite a few things.

I kind of answered my question...Run this code...I am on SQL Server 2012

IF EXISTS(SELECT NULL FROM sys.objects WHERE name = 'CatchBlockErrorTest')

DROP TABLE dbo.CatchBlockErrorTest

GO

CREATE TABLE dbo.CatchBlockErrorTest(id INT, val varchar(10))

GO

---1st part of...