I can't see anything about a meal in this code. What am I missing?

I'd definitely check into the possibility of hardware issues and also concurrency issues. Does it time out when there's a heavy load on one or more of the servers...

Jeff Moden (5/6/2008)

---

GSquared (5/6/2008)

---

Dateadd lists of datetimes. For example, if you need a second-by-second list of all times in a month, or a quarter. (10,000 seconds is a...

Are you saying that the search has to match ALL words in the search string, as opposed to matching ANY word in the search string?

So, if the description contains word1,...

It means that two or more foreign keys might result in a loop of mutual deleting. SQL Server can't deal with that (no computer can), so it prevents it...

If you change the * to / in the math, that might do what you need.

(As an aside, "square hectares" is kind of redundant, since hectares is directly a measure...

onlybemine (5/6/2008)

---

Since movign to stored proc is another big investment because of size of work.. which i couldn't do this stage....

Also

How to stop SQL Injection via webforms i am...

You might try parsing the log to find out which account is doing the updates. It's always possible someone is directly connecting to the database and doing the updates...

If you're moving data from 1 table with 10 fields, and all that data is going into 1 table in SQL, then using the Import Wizard from Mangement Studio is...

Assuming the prices are in the Excel spreadsheet, you...

You can create a "synonym" for a linked server, but it's not the same thing as the synonyms created by "create synonym". (It's the English language definition of "synonym",...

Actually, the query as written isn't all that bad. How well it works will depend on your indexes (assuming the temp tables have indexes created on them, or that...

I'm not clear on what you're trying to update. I see that you have items and prices, but I don't see what you're changing them from/to. Can you...

Most of the time, SQL Server picks the number of threads pretty intelligently. It may vary the number based on how busy the CPU is, how likely the query...

When you say you had an upgrade, do you mean you upgraded from SQL 2000 to SQL 2005, or do you mean something else?

There are a lot of reasons for...