The only issue is if (or when) the dev server is out of sync with production. As the DBA I ask that all changes to table structure, including new databases,...

One of the advantages is that SQL 2000 manages memory without you, or is that a disadvantage...

Patrick

You should manually update the statistics. Auto update statistics does not run immediately after you dump data into the database.

Yes, SQL 2000 may jump in and update the stats but...

Sqlstate=S1002, nativeerror=0

Reading BOL on SQLState it says that this an invalid column number. Check ODBC Error Messages.

Patrick Birch

I have been a developer and a DBA. I had the advantage of mentoring with a DBA while I learned the process.

I depends on the DBA and how available...

Are you sure it's the chip? Have you run Profiler against the new system?

Patrick Birch

It depends on how much time you've spent on SQL Server. These days a certification alone means very little. I would find a position where you could work with a...

Could you post what your bcp command when you tried it?

Patrick Birch

Knowing how a test works does help. Once you have taken a few of the Microsoft tests they are not an ordeal, more of an annoyance.

Having the initials after...

The SQL 7 cert won't hurt you. They should be around until Yukon's (SQL 9) tests become available. Of course, Microsoft is changing how it retires tests.

Patrick Birch

Perception is all. What the certifications may accomplish is to give us a fundamental level to build upon, but they are perceived to be the result.

If you have been...

In a strong wind, even turkeys can fly.

I just had the opposite experience, two grueling technical interviews and a test. The company didn't care about my certifications, they had...

I had the same experience while I was performing technical interviews. I would ask questions like "What is a UNION? What does it do?" and I would hear all sorts...

You are probably right in some cases. I have had bosses who wanted us to pursue certifications so that we could work on projects and then get the experience. I...

Thanks, patilds.

quote:

---

u can give him OLAP Admin rights. The OLAP admins can't change the data from database. They can create cubes...