1 million entities with 40 columns - 6 of the columns are address information and half of the entities have two addresses - 1 column is a phone number and...

Here are two options. The first is just using left joins and is relatively simple. Because your LIKE starts with a wildcard, you will end up with table...

Making one table per session is probably going to cause more performance problems and other issues than it will solve.

You should have no issues with a header / detail table...

I think you want to use a transaction save point:

[font="Courier New"]Create Table #BPTest(id int)

begin try

begin tran OuterTran

Insert into #BPTest values (1)

...

I tend to use backup / restore rather than snapshot replication.

Since the backups are already happening (assuming you are using SQL backups) there is little or no additional load on...

Don't use a trigger for this.

If you post the DDL or even some sample DDL, we can help you qith the query.

I don't think you need a union, you probably...

I meant you should actually change the collation setting for your column - if the sort and sensitivity change will not break anything else.

If you do what you are suggesting,...

If you use views as suggested, you could give access only to the views. If you create a SQL login for just this process and give the login only...

Specify an accent insensitive collation:

[font="Courier New"]CREATE TABLE #tmp (c varchar(30) COLLATE SQL_Latin1_General_CP1_CI_AI NULL)

INSERT #tmp VALUES ('The Coleg Sir Gâr')

SELECT * FROM #tmp WHERE c like '%gar%'[/font]

You can give permissions (add a login to your server) through SQL Logins, or through NT Authenticated logins. An NT Authenticated login can be a user or a group...

You will need to give the logins access to both databases.

It is still worth handling multiple rows. You have the necessary code. If you don't do it now, when you have a process that inserts multiple records you...

I think the last post hit it. I think you used expressions on your container and set the variable name to be the file path. I would suggest...

I'm basically just lazy.

I even have a good idea today - I wish I were a bit more motivated.

Don't underestimate the value of simple eye-candy.

I once had a bunch of users complaining about the time it took an ETL process to run (it was about 3 minutes). ...