Perfect Article 🙂

Thanks Gail:-)

Thanks for reply.

I am just designing a new database. At the time of index creating, above mentioned points came into my mind that what should be deciding factor for this...

How does fragmentation causes slow updates of a large table? Could you please put light on this? As far as I know, scanning/seeking of index becomes slow due to fragmentation...

Yes. I'm agreed with John.

Thanks,

Vivek

Please specify about output you are expecting.

Thanks

MedianYearMonth

315.500000 2014-10

191.0000002014-11

311.0000002014-12

284.5000002015-01

618.0000002015-02

303.0000002015-03

458.0000002015-04

185.0000002015-05

290.0000002015-06

391.0000002015-07

208.0000002015-08

328.0000002015-09

DECLARE @Cols NVARCHAR(MAX)

DECLARE @sql AS NVARCHAR(MAX)

SET @Cols = STUFF((SELECT ',' + QUOTENAME(descr) FROM #Job FOR XML PATH(''),TYPE).value('.','NVARCHAR(MAX)'),1,1,'')

SET @sql = 'SELECT * FROM

(SELECT P.id , P.name , J.descr, PJ.startDate

FROM #Person...

Expected 5 😎

You didn't accept 5 :w00t:

You OLE DB Source is trying to insert two duplicate id with same value 126 in OLE DB Destination (table incident).

Need to look into source component.