Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.

Optimising “Ends With” searches with REVERSE

A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text

Search for a Table in all databases

This Script can be used for searching a Table in SQL server 2005

not like?

RE: How to retrieve row level data from Mainframe VSAM files Into SQL Server

If you are accessing native VSAM, as opposed to VSAM used for IMS or DB2 databases, you need a VSAM ODBC driver installed on the mainframe.  Talk to your mainframe support people about this. 

RE: Primary Key and duplicate values

Be aware that you are violating one of the basics of relational tables - a key is a value or a combination of values that is unique for every row. If you have an OLAP database, then having a unique row may not be as important, but in an OLTP database destroying your primary key […]

RE: Query to Post Results to View

You'd need a union for each column. ie:CREATE VIEW [dbo].[NiceChildren] As, SELECT [ID], Child1 FROM [dbo].[Children] UNION ALL SELECT [ID], Child2 FROM [dbo].[Children] UNION ALL SELECT [ID], Child3 FROM [dbo].[Children] UNION ALL SELECT [ID], Child4 FROM [dbo].[Children]

RE: ActiveX Script Problem

I can't tell you what's wrong wit your script... but I can give you another way of doing this which would be much faster than ado.. I assume you can use this to do an inner join to do your updates and a left join to find to missing lines and then insert them ( […]

RE: SQL 7 --> 2000 upgrade plan recommendation

Naaah.  I'll load it in due time (and probably sooner than I'd like in production if my boss has his way), but for now, I wanna sleep nights:-)

RE: Problem viewing linked server items

You should check to see, within the linkedserver security settings, if you are mapping logins to remote logins. You might be attempting to pass through the account you are logging onto the server with, which doesn't work.