You could put in a new step one and use the On success and On failure actions of the new step to govern what the job does next. That...

SELECT ID

FROM #John

WHERE

CASE

WHEN ID NOT LIKE '%[A-Z]' THEN RIGHT('0000'+ID,5)

ELSE RIGHT('0000'+ID,6+LEN(ID)-PATINDEX('%[A-Z]%',ID))

END < '00020'

If you're going to use it like this, you need to make sure you understand exactly how it works,...

You're on the right track. This should work:

CREATE TABLE #John (ID varchar(4)); -- if your column is char instead of varchar, this won't work

-- Constraint to check numeric characters...

Since they're cumulative since SQL Server started, you'll...

Good. Is that normal? In other words, do you see those WRITELOG waits all the time, or only while the system is running slow?

John

It could be, but until you capture the wait stats, you're just speculating. Also, see whether you can capture sys.dm_os_waiting_tasks during that single second of slowness. If you...

You might want to capture wait stats as well. Since they're cumulative since SQL Server started, you'll need to subtract one set of figures from the next in order...

If you want the trigger to update those columns regardless of which columns are updated, just remove the IF clause altogether.

John

What is the data type of the Acc column? If it's not varchar(20), there may be some conversion going on. Please will you post the execution plans?

John

Does this happen every time, even after you clear the plan cache (don't do that on a production server, though)? Have you compared the execution plans for the two...

pbo71465 (4/1/2016)

---

...as long as I didn't go beyond a certain range of Prime Numbers, the sum of these numbers would always be different.

The only problem was there is the possibility...

Eamon

Is there not an option in the Flat File Connection Manager in SSIS to overlook any delimiters that are enclosed in quotes? If not, I can't think of any...

I don't know whether this is the most efficient way, but you could use bitmasks. In a separate table, assign a power of two to each action, for example...

The clustering key is the column, or set of columns, on which you choose to create your clustered index.

Where did you read the term "heap index"? A table without...

If you just want to find rows where query_plan contains those terms, convert to varchar(max) and use LIKE, CHARINDEX or PATINDEX. If you want to know where in the...