May it be that you are looking at 32-bit in one of the locations, and 64-bit in the other? As far as I remember, the 32-bit and 64-bit client libraries...

I don't remember how the CPU load was, but I once had a scenario where the backup all of a sudden needed more than 24 hours to complete. In my...

If you perform log backups, this will of course allow SQL Server to reuse inactive portions (VLFs) of the log file. What I meant is that smaller transactions alone will...

Just checking: Do I understand you right that you attempt to switch to simple recovery model during this process? Splitting it in several smaller transactions does not have the intended...

First of all, I think the security risk of instant file initialization is a bit misunderstood. Let me try to explain how it works.

On a single instance server, any members...

First of all, I want to thank everyone for the good feedback.

No matter if Lock Pages in Memory is enabled or not, SQL Server will attempt to release memory on...

Winfried Terlinden (2/28/2012)

---

This privilege must be enabled to configure Address Windowing Extensions (AWE). (...) On 32-bit operating systems, setting this privilege when not using AWE can significantly impair system performance....

If I don't recall something wrong: are the two instances running under the same domain account? Have you verified that this account has sufficient permissions?

Thought of that one too, but don't like...

My real life scenario is far more complex than this sample code, whose sole purpose were to demonstrate...

Gail: Don't you ever work? It seems that your response time in this forum is pretty impressive 😀

Thanks both of you. Nice to know the bits and pieces about how things work. I'll have to explicitly create the table then.

Personally, I've never had any problems with having lock pages in memory configured, but I've reduced the paging quite a bit, and thus got improved the performance of the server....

The error message tells you exactly what is wrong: There are NULLs in your column, and the new table definition does not allow nulls. Assign a value the column where...

Is all these steps running in a single transaction? Statistics is not updated within a transaction, so all your statistics is basically saying there is no records in this table,...