see mcsebraindumps.com. Lots of good discussion and helpful folks there. i took and passed it.

I found mcsebraindumps.com helpful. And the price was very right.

ISBN 1861007418

I'm loving it!

For free questions (answers are suspect though) check out mcsebraindumps.com. I use them to help fine tune study topics but don't trust a single answer I don't personally verify.

Nothing beats OJT! Bring in a consultant after you've set up SS and run it for a couple of weeks. You'll get more than any class.

Certification, like knowledge, is neither good nor evil in and of itself. I value my certs because they helped me in my job. I learned alot going through...

For cheap, you can get a 120-day FREE trial of SQL server. If you run out of your 120 days, format your hard drive and reinstall it (no kidding)...

quote:

---

Is it possible to import a single binary/text file into an image field, and more importantly export it...

IBM Packed data stores numeric data by setting each 4-bytes to a number from 0-9. You get an exact number this way, no estimates, no abouts and it takes...

We have saying where I come from: "You can't put 10 pounds of S**T into a 5 pound bag."

Processing 50Gb of data is going to take some time, no...

Try importing all rows into a staging table, do your validation on the data base table, then only import the rows that passed. Should still be fast and you...

Be sure you have the latest SQL Server service pack. DTS is constantly undergoing change due to numerous bugs. As you noted, you control this on the 'advanced'...

There are many reason a job could timeout. You will need to investigate those and see what happenedn.

backups running long

deadlocked tasks

long running process

looping function

When you create your task, you can just hard code your dates in the query. If this is a monthly task, it has the drawback of needing to be...

See prior post.

Errors can be trapped and ignored in SQL Server. Also, if possible, avoid the cursor altogether.