EdVassie (1/19/2009)

---

For airport operators to say they cannot cope with security or customs delays is plain incompetance. They work with national governments in many other ways, so these issues...

We have servers with 100+ databases that are low volume, and never have any performance issues. We have other servers with 2 databases for one app (vendor product thsat is...

That's better than a friend who worked for a really cheap company that expected employees to share...

I've been travelling internationally since 1972, when I was 13, and have lived overseas for 11 years of my life, and spent lots of time in other places on business...

GSquared (1/13/2009)

---

Forgetting to highlight the Where clause is just one example.

As a note, he had the production server and the dev server open in Management Studio at the same time,...

All companies should have a clear data retention policy that is enfoced across the board. If the policy is that certain data is kept 5 years then destroyed, a court...

I don't think you are likely to see improvements of this magnitude by performing database maintenance. When we moved from SQL 7 to SQL 2000, we had a process that...

Triggers aren't always bad, it just depends on how they are used. We use triggers to activate interfaces we've built on vendor provided software - without the trigger, we woldl...

So, what happens if you create a table of the employee types with an extra column to mark the ones you want, ie columns EmpType int and InQuery bit, populate...

IceDread (10/24/2008)

---

I do not really have any absolutions. I judge from situation to situation. But there are a few things I try to reach... Never ever use cursors, because if...

Why not just make sure no one has permissions to execute those stored procedures? That's a lot better than running the risk of breaking an important process becuase a vital...

+1 on profiler. I use profiler all th etime to determine what vendor apps are doing. I do recommend doing this on a test server, as it's easier to isolate...

I can't think of a situation where any developer needs to have full access to a production database. Developers should never, under any circumstances, for any reason, have full access...

You may need to specify the columns. The error message indicates you've exceeded the limit of the Jet driver. My guess is that select * from the spreadsheet tries to...

Try this:

Set @sql = 'Select P.ID_no ,zv.ZoneIn from ZonesVisited zv

Join Positions P on zv.PositionID = p.ID

Join Individuals I on I.ID_no = P.ID_no

Where

zv.zoneout is...