Great articles Gail linked to. I'd tend to do this monthly, but YMMV.

You can use PATINDEX or CHARINDEX to do this. Here's a sample: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

paul.knibbs (2/27/2013)

---

Being serious about this, it's not like the first time Microsoft has flailed around trying to find the current zeitgeist in order to follow it and then dominate it--remember...

About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.

School cancelled.

I think...

GRE (Gethyn Ellis) (2/27/2013)

---

I read an interesting piece a while - It was posted on Twitter (I can't find the link). It called for Ballmer to go basically saying he...

mark.fisher (2/27/2013)

---

Given the current state of the economy can you blame them for having a more business orientated focus. MS have been concentrating on core products, probably with a...

Nothing against Win 8. To me, it's really Win 7 with...

Are you inserting to a remote table and trying to log it locally?

My fault. Frazzled from a week in Seattle and a bunch of deadlines on my plate. Since I...

Carla Wilson-484785 (2/22/2013)

---

LOL! Does anyone remember APL, "A Programming Language"? That's what hooked me in 1975, because it was an interactive terminal (keyboard, no CRT) back when all...

I'm actually not sure. We have a few editors, and I haven't commissioned one, but I sent a note around to find out.

I should try to gen a billion rows for giggles. I got a new workstation, Win 8, 24GB ram, quad core, 4TB. Might be interesting.

This might help: http://www.sqlskills.com/blogs/paul/page-life-expectancy-isnt-what-you-think/

However it's an average of all pages, not any particular page. You have to use it as a thumbnail guide in that sense, and look at it...

If I Recall Correctly