Thanks.............that was what i wanted.

Just changed to 23 to the length of the field.

declare @data_nv nvarchar(500)

declare @data_numeric DECIMAL(15,2)

SET @data_nv = '2.0018430861853059e-005'

select CONVERT(decimal(15,14),convert(float ,substring(@data_nv, 1,len(@data_nv)) )) -- resulta...

Thinking.

Perhaps i have to do a function to pass in value and output the correct value.

Got 130 columns to do this on.

Sometimes it be a e-006 or even...

You done great in identifying it and yes i would be on the phone too.....after all you pay support they fix it.

Changing code on vendor software sometimes make it unsupportable...so...

I would determine what your IOPS is on the system. Permon physical disk read sec and disk write sec.

Then determine what RAID Group this is 1, 5, 10

1DISK_READ_SEC...

No...i needed a nudge to help me get my head around it. Cheers.........

I take a look, i only wanted the command not the entire program 🙂

i will look at that counter too.

Is doing the following with the two counters Physical Disk Reads / Sec and Physical Disk Writes/Sec

Then i have all disks information...

Thanks but i want the IOPS as we only got 420 IOPS and i want to be sure we not reaching these limits.

Cheers

The column name is [\PhysicalDisk(1 T:)\Disk Reads/sec] not the data value.

The data itself will be 7 or 45 etc

So that didn't work.

Was the column added after the setting up replication. I would stop replication and rebuild the subscription and replication again....

Oh the CTXPACKET you fix by changing the COST OF PARALLELISM from 5 to say 25 and MAX

DEGREE OF PARAMLLEISM to 4 (for 4 cpu as right now it...

Read the link nothing in there for fixes hmmm

Error '0x80070003' occurred during full-text index population for table or indexed view '[CyberRecruiter].[dbo].[Applicant]' (table or indexed view ID '1029578706', database ID '11'),...

Got the defaults here. Cost thershold for paralleisum 5 and max degree of paralleisum 0, max worker threads 0

Processors 8 CPU

processor affinity ...

When doing the testing make sure you drop the buffers on TEST Server

DBCC cleanDROPBUFFERS

So run your statement get your times etc.

Then tweak program and do dbcc dropbuffers and run again.

DBCC...

Cost of Threshold for Parallelism to 75 where did you set this in the GUI..and why 75 how to determine if need to change this?

So if you got 8 CPU...