>>We are facing severe performance probs on one of our prod servers.

I never understand posters who make statements like that and then hunt and peck on a forum for days...

If you know the database, user or application or even table for your critical stuff you can query various DMVs to see executing queries and the amount of effort (CPU,...

I would check to see if the VM is limiting memory of the machine.

If you can't get more than 3GB allocated to the VM, turn off /3GB and/or AWE if...

I prefer SQL 2000 because I can get more money as a consultant from clients with that platform because not as much information is exposed and thus I can know...

Robert Davis (3/4/2010)

---

Are you saying that the procedure cache...

Actually you didn't need to read this forum to gain knowledge. That stuff you watched has been on the web...

Robert, that is not true at all, at least not since...

simple answer: having time with your PK will ALWAYS leave you at risk for PK violations.

Tara, there are about a kajillion things that could be at issue here. Some of the most likely include: missing indexes, data skew, parameter sniffing, blocking, IO config of...

You can also use vbscripting, powershell, the DOS FORFILES command, etc.

dakshinamurthy-655138 (3/3/2010)

---

Sorry,

for not replying to the thread, as i was not feeling well i was off from the office.

The reason why i need this is, one of my client need...

Looks like this might be a dead thread now Jeff...

What is the precision of Datetime.Now??

mansshah (3/3/2010)

---

My table has combined Primary key of (Composite key of ID and date Time). It seems SQLBULKCOPY throws exception bcs it is not checking for millisecond interval precision, it...

There are a kajillion things that could be at issue here, and I bet there are many things at play causing problems. Just a quick list: missing indexes,...