Create a job which will be recording status of xp_cmdshell into a table, say, every minute and enable it after each recording.

Analysing the records you may be able to figure...

cunningham (3/28/2016)

---

Well I have all but ruled out resource contention on account of the differing number of reads, as well as some comparisons I have made re resource usage. Pretty...

ram302 (4/26/2016)

---

I will never need to decrypt the SSN, but I will need to add/remove ones as personnel are hired/terminated. Also, the table itself may contain multiple entries for one...

Jeffery,

I made the following script from the pieces you've posted:

DECLARE @BatchIDas int

,@PreparedStatementas varchar(8000)

,@SourceServerName NVARCHAR (128)

,@SourceDBName NVARCHAR (128)

,@SourceSchemaName NVARCHAR (128)

,@PKTableName NVARCHAR (128)

,@Alias NVARCHAR (128)

, @PKColumnName NVARCHAR (128)

,@FKColumnName NVARCHAR (128)

,@ETLMappingIDAS int

,@SQL1as...

Sorry, cannot see where did you answered this:

Does PRINT LEN (@preparedStatement) return >4000 ever?

Do you actually submit lengthy string to the UPDATE?

As you said,...

Considering, ORDER BY clause is not the place where we fix bugs (if you cannot rely on quality of the code, a...

Jeffery Williams (4/26/2016)

---

In morning i can get to it. But count on the following

Set @preparedStatement = @preparedStatement + ' ' + @sql1...

Can you post the full UPDATE statement?

Conversion could be caused by anything:

CASE, ISNULL, concatenation with NVARCHAR, etc.

Actually, inspect the execution plan - you may find where implicit conversion is...

Logically - can UpdateDt be possibly less than AddDt?

Rod at work (4/26/2016)

---

We've got to capture the history of a record, when its updated or deleted. If this were a C#/VB.NET app then we could iterate using a FOREACH...

Grant Fritchey (4/26/2016)

---

One point on that, I have found that even with small data sets (10s of thousands of rows), columnstore can benefit aggregate queries in a marvelous way. Giant...

davidlester.home (4/25/2016)

---

I have not been able to get an execution plan out of the query now that it is slow, 11+ hour run time is making it difficult to say...

I once saw a configuration data table which was occupying > 6GB...

Thanks for posting the script.

You may not need many views from the same table.

Will a view like this work for you?

CREATE VIEW dbo.PersonProfile

AS

SELECT t.PersonID, 'Degree', t.Degree

FROM dbo. t

WHERE t.Degree...