Hi Gail,...

Hi Gail,

One more question. Can I have more no of partitions then the no of filegroups ? Though my partition scheme says all partition should be in primary filegroup.

Perfect. Changing partition function to just date worked perfect. Thanks a lot Gail.

Hi Jeff, thanks for the explanation. In my table there will be truncate load operation on monthly basis plus only few read operations. I have currently put all the partitions...

I wanted to do the same Matt and as you clarified, I get it that it's not possible. Rather I am taking a new approach now. The whole purpose was...

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...