Steve Jones - Editor (3/5/2009)

---

If a manager doesn't appreciate what you've done, re-examine it and be sure that you have gone above and beyond. Talk to someone else you trust...

You need to enable advanced options first

exec sys.sp_configure 'show advanced options', 1

reconfigure

That shouldn't cause a problem for inserts. Large range-scan reads yes, but not singleton inserts.

jparker2 (3/5/2009)

---

If you want to prove this with a test, ask them to append the output of each loop to a local text file instead of creating a DB record....

I'm asking if it's permitted by company/department policies. That's not something that a script can check.

mhaskins (3/5/2009)

---

The point just was - that you can try to create your own brand, and list your accomplishments for the company, but you need to have a decent boss...

50% fill factor is low. It means that half of each page is empty which means your table will take twice the space it needs and queries will do twice...

DBMail's probably the easiest. I think Jack knows more about it than I do, so I'll defer to him.

Are you the DBA? If not, can you ask the DBA...

Great. One last thing. How is the email going to be sent? Are you suing DBMail? Do you have a mailing program? Or is there nothing set up at the...

musheik (3/5/2009)

---

I checked with java developers, its difficult for them to modify the code in short time. as we are at the verge of release.

Any thing need to be done...

Edit: Misread the question. Nevermind......

Can you move the data and log files elsewhere? Detach the DB, move the files, reattach from a new location.

musheik (3/5/2009)

---

I need to insert 200000 records into a table .

When I insert 200000 records at a time it is taking 13 seconds to insert.

The same 200000 records if I...

Can you post the SQL error log from the beginning until that database is online and available?

I've never seen profiler reporting false durations. You sure there's no blocking in the prod database that could be making the insert wait?