GilaMonster (2/16/2012)

---

So tell me then, how do you (not the database engine)...

If you have a need to improve the performance and you are not overly restricted in your environment, this would be a great place to use CLR. The longer...

I had a situation a few months ago in which a search proc with a bunch of messy conditional logic was replaced with fully parameterized dynamic sql. The proc...

Never use dynamic sql like that. Use sp_executesql and correctly parameterize all variable input. Right now, the way you have it, you have an open invitation to perform...

Two separate queries with a UNION ALL would be another option.

In doing this assignment, take the opportunity to learn what's going on instead of just picking the first 'solution' that...

update dbo.messages

set ContentMessage = replace(ContentMessage, 'this is debt collecor.', '');

go

Very good question.

Something important to understand about SQL Server's full text indexing is that not every word gets indexed. There are words that are intentionally filtered out because they...

Not sure that I'm missing something, but I'm not seeing your solution to the problem that you say you don't like. I know I don't really want to code...

Would be helpful to know what the value for content is for a record that is causing the error.

While Celko may be rude and he comes across as though he's never left the ivory tower to do real work, there is a small point in what he says....

Oooh, looks like a homework assignment!

Normally I don't help with those, but since you put forth an effort with what you think it might be, I'll at least give you...

Especially for really broad questions, the website Google.com can be a handy place to start.

A content management system is a potentially extremely complex application that would store its data in...

Sean Lange (1/18/2012)

---

I second the opinion of not doing dynamic sql like this. Your whole query is only a single simple select statement. Even if this is "internal" only you...

I cannot overstate how ill advised your dynamic sql strategy is. You are asking someone to hijack your system with sql injection and you are ruining any chance for...

I use to do a bit with an Avaya dialer system that sat on Oracle but my interaction was limited to simple queries. Those are $1M systems and the...