Not sure, but maybe put the SET ROWCOUNT inside the dynamic SQL.

Or on SQL 2005, SELECT min(login_time) FROM sys.dm_exec_sessions

Unless he knows enough about SQL to start it in single user mode.

schep021 (4/25/2008)

---

The plan is to set the max server memory to 6.5GB and min server memory to 1GB. I think all we need for switches is /3GB since the...

Yes, and it works even if the server's in windows authentication only mode.

It's so that an admin cannot accidentally...

If we give you the answer, do we get the job?

I'll give you a hint, but that's all. The database in question still thinks it's replicated.

No.

A snapshot is just the old version of pages from the source DB that have changed since the snapshot was created. Removed from the source DB, it's meaningless as it...

Can you post the schema of the table please?

Irfan (4/29/2008)

---

I am sorry i am not clear with your answere. do you mean if i have both switches enabled i will get a problem? you mean we should enable...

No. You should have either /3GB or /PAE enabled. Having them both on on a server with 16+GB memory is asking for problems.

The database master key is used to encrypt other keys in the DB. It's not there to stop the DB being attached/restored onto another server.

Currently, the way to ensure that...

That just means that the SPID that reported the condition is sleeping (waiting) until the mini-dump that's created has been written to the drive. You'll see that every time SQL...

A index is either unique or it's not unique. To do what you want, you'll probably need a trigger, and it will hurt your insert/update performance.

Hans Lindgren (4/29/2008)

---

No, it's not. The cost is based on the CPU usage, the...

Jim Russell (4/29/2008)

---

Toni - Until you pointed out that QUERY_GOVERNOR_COST_LIMIT had to be set in the query, it had not occurred to me. If the new Resource Governor falls...