I have seen both sides, and its fair to say the answer is in the middle. And as many have said, the real key is to understand both your...

Either way has pros and cons, and I have seen both. I don't have a problem with developers having a local copy to work with and test against. ...

agree, take a look at soundex and full text search. Both have some value and may match your needs.

Thanks, but just for the record, the load on the tempdb comes from snapshot isolation and nasty cursors used by the Java developers. It's a long road, but working...

Points for writing and posting the article. And a good start.

For smallist, in-house corp applications tuning seems to be ignored or overlooked. And even with externally...

This should work, if I followed your example correctly:

select t.CodClient,t.Name, (t.Address2 + t.Address3) AS Address

from CUSTOMERS t

...

I agree, set it for simple

Agree that functions have some limits, but the use here is to simply repackage.

Thanks for the tip. Always looking for new approaches.

But what I am really starting to look is a way to have an application pass in an XML value, and...

If you cannot use a second column, when you do the match, have the numeric value on the left side of the where conditional:

where mynumeric = myformatlogic(my string...

Agree, default on the table is the most efficient for the initial createdate. However, if you are concerned that the development code will put in an incorrect value, then a...

Have you used the XML Task?

And you should be using the File not the Flat File data source.

Start with the XML Task, and then use that to make...

Good point on the INCLUDE. In this case you would need to include all columns as part of the index. My oversight.

here is a good example, and btw, this function is very useful. It converts strings to a table

-----------------------------------

-- call it

declare @strPermissionName nvarchar(4000)

select @strPermissionName = N'dkljdflaj,kdkkd,dkjajlf,'

select * from dbo.fnNStringToArray(@strPermissionName,...

an index works as well, but try to keep it narrow and put some of the lesser values in an include. you want to keep it as narrow as possible...