Hugo Kornelis (4/6/2012)

---

I flipped a coin and ended up lucky. Two answers can both be considered correct.

No, a foreign key constraint can not be created across databases. If you refer...

At my current company call is about every 10 weeks. The only calls I've gotten are for batch processes that aren't automated and have regular problems for which there...

The linke I posted all state that changes in 2005+ make it less necessary to use the trace flag, but that it can still be helpful if you are experiencing...

I'd probably use a script to create the csv.

rudy komacsar - Doctor "X" (4/5/2012)

---

Are you using SQL startup trace flag 1118 ?

If you are not then the additional data files for tempdb are not really buying you any...

I thought that might be the reason, but it still is causing performance issues. Every row in the table has to go through both functions before any filtering can...

Sorry I missed that...

I don't know the answer to #1.

For #2 the answer would be yes, if auto update stats is on or a manual statistics update is run, because updating stats will...

Full-text is probably the way to go, but short of that I'd probably split the string like Andy has suggested, but I'd put it in a temporary table, then I'd...

Lots of things can cause a query to be recompiled even when the query hasn't changed and you can get the same plan. Statistics may have been updated, a...

Duplicate post, please post on this thread, http://www.sqlservercentral.com/Forums/Topic1278748-391-1.aspx

Pretty sure you want to use the .exist() method. Check out his blog post about it: http://www.jasonstrate.com/2010/11/xquery-for-the-non-expert-exist/

It would be much easier to provide a solution if you posted examples of your input file and the output file.

Can you also post the execution plan(s)?

You should also make the computed column PERSISTED and put an index on it.

Is SQLBrowser running?

You may need to specify the port in the connection.