Can you add another file to your transaction log on a different drive and make it the Primary? Given enough space, trying to shrink your database or your data file...

EDIT: Erasing what I just said because it's not related to the question. DOH.

If your growth occurs at a certain point in the day, can't you use profiler to identify...

Craig Farrell (3/15/2011)

---

Folks, if you ever get the chance to let Brandie do a review of one of your pieces, do so. I'm afraid to see what she'd do...

Omens

Also glad you got it working and thanks for posting the solution. That will help others with the same problems.

GSquared (3/15/2011)

---

Brandie Tarvin (3/11/2011)

---

Now that's an interesting solution I never would have thought of.

But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the...

Wow. Just finished beta-reading for Craig.

Wow.

Aren't you guys sad you can't see that article yet and jealous that I got to read it before you did! @=)

WOTD: Disaster

Craig Farrell (3/13/2011)

---

Anyone around willing to take a readability review of an article (though will probably be split in two) I'm in the middle of writing? I need a...

Here's a unique way of doing the special / invisible character search. Your mileage may vary:

DECLARE @y xml;

SET @y=(SELECT MyID, MyColumn

from MyTable where MyColumn=''

FOR XML RAW, ELEMENTS XSINIL);

SELECT convert(varchar(5000),@y);

EDIT: You'll...

Now that's an interesting solution I never would have thought of.

But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the periods). It wouldn't...

Ah. Stefan found the Substring version I was trying to do. I forgot about starting location in CharIndex(). No wonder I couldn't get it to work.

You're welcome, Roy. Glad we...

Here's a brute force solution:

SELECT CASE WHEN Substring(IPAddress,3,1) = '.' AND Substring(IPAddress,6,1) = '.' THEN Substring(IPAddress,1,5)

WHEN Substring(IPAddress,3,1) = '.' AND Substring(IPAddress,7,1) = '.' THEN Substring(IPAddress,1,6)

WHEN Substring(IPAddress,4,1) = '.'...

No, Lowell. Not easy at all. And it's not about price. Approvals have to go through our Corporate office. Applications are rigorously testing to make sure they are compatible with...

Much as I'd love to use one of those two options, we can't use unapproved software or components.

However, I am allowed to write up SSIS components myself... If I had...