Yes.

Not saying how efficient it is but this may work:

declare @TestStr varchar(128) = 'DMV1004/343M.TR3432_PLC089_RIC_9843CL';

select @TestStr where @TestStr like '%[_]%[_]RIC[_]%';

set @TestStr = 'DMV1004/343M.TR3432_PLC089_RIC1_9843CL';

select @TestStr where @TestStr like '%[_]%[_]RIC[_]%';

It was a while ago and I even posted the info here on SSC on another thread where an OP was reporting the same error we had experienced. I...

tim.nyland-jones (3/15/2013)

---

Well, interesting findings over the past few days... it's not whether the file exists, it's all down to HyperBac compression...

HyperBac off: Backups 400GB, 1.25 hours, read speed 100MBps, write...

Me thinks that Gail and your Network admin are thinking the same thing here. Sort of looks familar to when our SAN did not come before some of our...

GilaMonster (3/15/2013)

---

Lynn Pettis (3/15/2013)

---

If I interpret it correctly, looks like all of the VLFs in the log file have open transactions. Until all the transactions are committed or rolled...

For some reason I just didn't catch the CHAR(3) in the question. Even if I had, I would still have picked '0'.

Speaking of Gail, looks like I did interpret it correctly.

If I interpret it correctly, looks like all of the VLFs in the log file have open transactions. Until all the transactions are committed or rolled back, SQL Server...

Haven't had a chance to even look at it yet.

cryovenom (3/15/2013)

---

And less than two minutes later I realize how silly my last post seems.

For anybody finding this thread through google, NUMA (or Non-Uniform Memory Access) definitely has a...

If the (or an) active VLF is at the end of the log file, the file will not shrink. All I can suggest is keep trying after each log...

Lynn Pettis (3/15/2013)

---

I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I am a...

jfogel (3/15/2013)

---

Be with who you like. My initial post in this thread wasn't even directed towards her and that post was a joke. Then she goes on bickering back and...

naveen.pasupuleti (3/15/2013)

---

Thanks Lynn for your response.

The code you shared works for this example but sometimes integer time column or col B can have values like 93000 (9.30am) or 0...