Also, what is in ActivityName besides "email sent"

If you can avoid the <>, you can make this run more efficiently.

I think that blog is OK for internal applications, but it doesn't think through the complete issue. While it's true that a port scan or network trace can easily find...

paul.knibbs (3/25/2011)

---

I disagree here. Licensing per core is all well and good, but you might well end up paying to license a feature you don't want and never use! I'd...

A Facebook friend just asked to start an on-line book club with Dan Simmon' Hyperion. Anyone read it? Just started it and not sure about the first 20 pages.

I thought Surface would make a great gaming table as well. I think there are a number of places in some resorts, like Vegas, that have implemented them for bar...

That is strange. I wouldn't think it would matter, but I'm glad it's working. I'll dig in later and see if I can come up with something.

What you want to do is use charindex to find the other pattern. This is all pattern matching, so you can do this:

select

charindex( col2, 'dbname.dbo.'),

...

Is the name of your database read_write_filegroups? Or is this a filegroup backup (typo)?

I think this might help you: http://msdn.microsoft.com/en-us/library/ms190218.aspx

The best solution would be, If I understand your situation correctly,...

A Better reference: http://technet.microsoft.com/en-us/library/cc938485.aspx

Checksum isn't a term I've seen associate with RAID. Almost always things are listed as parity calculations.

Ray K (3/24/2011)

---

Yankees' big question mark is still their starting rotation, although I understand that A.J. Burnett, Ivan Nova, and Bartolo Colon have been looking pretty sharp. Freddy Garcia...

GSquared has great points. Typically a DBA brings value. They tune code, they write new reports, the improve the systems. If you are looking to hire someone that sits...

Have you tried charindex()?

Like:

select

charindex( col2, 'dbname.dbo.'),

substring( col2, charindex( col2, 'dbname.dbo'), 30)

from myTable

It would help if you explained what you are trying to do...

What you wrote isn't clear. Is that what is exactly stored in the column?

It's not clear what you are trying to do?

Rockies look good overall. We'll see how it translates to the season after signing some contracts with the Big 3 here.

Yes, the folks at Red Gate booked it, not realizing we had a DST change recently.

We recorded it and I'll get a link posted as soon as I can