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,...

SD1999 (3/2/2010)

---

SQL is Standard....

Windows 2003 - Enterprise

I have't had any problems applying 'lock pages in memory' and enabling AWE.....

But even if you are right about 'buffer pool only'......2 GB of...

Search web for this word doc: SQL Server 2005 Waits and Queues SQL Server Best Practices Article. It is the Bible for this topic. Also search for...