sqlenthu 89358 (8/23/2016)

I was going through the concept of service broker but little confused. Can I make insert into table using following code:

DECLARE @SBDialog uniqueidentifier

DECLARE @Message NVARCHAR(128)

BEGIN DIALOG CONVERSATION @SBDialog

FROM...

Does it work parallel as well ? I mean if I write it as...

Does it work parallel as well ? I mean if I write it as...

Hi,

I was going through the concept of service broker but little confused. Can I make insert into table using following code:

DECLARE @SBDialog uniqueidentifier

DECLARE @Message NVARCHAR(128)

BEGIN DIALOG CONVERSATION @SBDialog

FROM SERVICE SBSendService

TO...

Can we achieve it using service broker ? sp_executesql works in sequential order only.

Hi Jeff, is there any article or link which gives insight of the parallel inserts in a table ? I am curious to test and implement it.

Part of table into different spindles means partitioned tables ?

HI Sergiey, These tables get populated every few mins. Though there are no updates and deletes. Will that be impacted if clustered indexes are built on them ?

That is typo from my end. Everything is fine syntax wise.

Actually this query shows RID lookup with a seek predicate on table table2. This RID lookup takes 98 % of...

Mainly I see the substring condition in the where clause and the aggregate function in select condition using case statement. The query takes little more time than what I am...

Yes. There is a DBA team.

Jeff, I would be thankful if you can tell me any links proving performance tuning and optimization in OLTP environment.

Thank you guys. i'll certainly take help of his proc. Also I've till now worked on OLAP environment and this will be first time i'll be working on OLTP. Is...