Help me understand this scenario... I'm trying to TEST a fix for Implicit conversion on a single update...

sample 1 would be doing a int to nvarchar(255)

sample 2 I try to...

Thx,

Do we pay any performance hit when the script reports back that it's seeing:

Table - Design

Column - design

Convertfrom - nvarchar

convertfromlength - 40

converttolength - 240

I do have another question as I'm digging into this further to help uncover code needing fixed. When I ran the provided query to uncover IMPLICIT_CONVERSION query's(thx) I started looking...

Thanks ... thats the plan of attack.

Hope I caught all replies, I'm going with having ORM fix code as suggested..

It looks like someone is generating ORM code but doing it incorrectly. ORM tools can use the...

Memory - 32gig

MAXDOP, cost threshold  -- Default

Index and stats are current...

It's a VM with backend SAN and no issues with latency..

They did throw is at me...  what Indexes could be applied to help..

They did throw hardware at it.. which is the wrong approach.. and it only slightly improved overall response..

correct not in house generated code..

Solutions\fixes that could be applied?

Thanks for responses..

another piece of info there is a non-clustered Index on:

design

version

class

object

Thanks again.

Michael L John,

Thanks for script.... help me understand output versus table layout and why slowness is occurring

Script output:

Table - Design

Column - design

Convertfrom - nvarchar

convertfromlength - 40

converttolength - 240

I have attached...

Table layout...

CREATE TABLE [dbo].[designerror](
[design] [nvarchar](40) NOT NULL,
[layercode] [int] NOT NULL,
[position] [int] NOT NULL,
[operation] [int] NOT NULL,
[description] [nvarchar](1000) NULL,
[seq] [int] NOT NULL,
[designAlternative] [int] NOT NULL,
[subDesign] [nvarchar](120) NOT NULL,
[subDesignAlternative]...

The designError table is small and there are no keys or indexes. I can't see the code that's issuing the call for the delete(package software) .. I can't change any...

could you show script ?

Thx.

I agree on complexity..

I ended up with something like this. Do you see any issues I would run into?

Thx for comments...

IF (OBJECT_ID('tempdb..#col') IS NOT NULL) DROP TABLE #col
SELECT  IDENTITY(INT,...