I find it interesting...

Or not "fuzzy" enough

SELECT Soundex('philip'),

...

Now I spot the other thread :blush:

http://www.sqlservercentral.com/Forums/Topic952016-338-1.aspx

Simplest method

create table contacts (

EMP_ID int,

Contact_type varchar(20),

Contact_Number varchar(100))

insert into contacts

select 1, 'Home', '92 - 51 - 225478' union all

select 1, 'Cell', '92 - 131 - 225478'...

majorbloodnock (7/14/2010)

---

Many of the first personal computers were used as better type-writers. Still the same old typing pool; just quicker. That was a case of isolating a performance issue...

Here's another story about bosses and optimisation...

A few years ago when I was a still slightly wet behind the ears developer my boss asked me to run a report for...

For me the preference is full featured for a short time which then automatically disables some features and goes into "free" mode or at least "I'm going to irritate you...

Just to concur with some of the other posters, for ETL processes the Except function is very useful for comparing 2 tables with the same structure in different databases and...

Kelsey Thornton (2/19/2010)

---

This article refers to the "English" calendar.

Of course, it should refer to the "American" calendar.

In England, like in most of the rest of Europe, the week is deemed...

Catch all Lookup tables are the bane of my life.

I've lost count of how many times I've had to write queries which join to the same lookup table 10 or...

LogParser is certainly a relatively unknown Gem.

I've used it off and on for a few years now and I'm frequently suprised at how few people I meet have ever heard...

Personally, I find using windows scheduling and invoking the SSIS package from a .bat file to be a lot more dependable.

ian.hadlington (11/13/2009)

---

Well it's a good 5-6 months since I created that script, and it looks as if the project to implement this new software has been delayed until March next...

Currency conversion issue

I'm working in...

Unfortunately only the big consultancies can get away with charging £1000 per day...