Sean Lange (4/15/2015)

---

Eirikur Eiriksson (4/14/2015)

---

Sean Lange (4/14/2015)

---

Eirikur Eiriksson (4/14/2015)

---

ztoddw (4/14/2015)

---

This way is probably more efficient-

declare @STRING varchar(1000);set @STRING='100010111100010001';

select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))

from (select n=number, sub=substring(@STRING,number,len(@STRING))

from master.dbo.spt_values where type='P'

and (number between...

Forensics

ztoddw (4/14/2015)

---

I admit I don't know for sure that it's more efficient- it just seems like your solution was doing more work than it needed to- although I'm not sure...

Dodge

Just ran your code on a multi instance box (10 running and 4 not running), all showing up in the results, could this be a permission issue?

😎

BTW: the services not...

paul.connors 70350 (4/15/2015)

---

Thanks for the swift reply, I'm thinking along the same lines myself, unfortunately the cursory scan of the event logs etc revealed not much detail at all and...

tarr94 (4/15/2015)

---

Hi,

I'm a bit puzzled. I have a stored procedure with a cursor and while loop. I have two update statements that update the same table. If...

paul.connors 70350 (4/15/2015)

---

Hi

I'm just looking for a little feedback from out there in the wilderness, here's my situation.

5 months ago added locally attached SSD storage

•741148-B21 - HP 200GB 12G SAS...

without any parameters it only lists the services, should be...

Quick thought, how about cmd net start and parse the output?

😎

NOLOCK

Others

Further on...

Sean Lange (4/14/2015)

---

Eirikur Eiriksson (4/14/2015)

---

ztoddw (4/14/2015)

---

This way is probably more efficient-

declare @STRING varchar(1000);set @STRING='100010111100010001';

select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))

from (select n=number, sub=substring(@STRING,number,len(@STRING))

from master.dbo.spt_values where type='P'

and (number between 1 and len(@STRING))) t

where...

Even