I wonder if something funky with NUMA may not be at play then. There have been several NUMA-related hotfixes rolled out since your way-back-when-patch-date too! 😎

Is it the secondary or primary mirror copy that is having problems?

Are you all patched up? I seem to recall a patch in a CU that may help with this issue. Start reviewing all the SP/CUs you don't have...

rkrpat (1/31/2015)

---

Hi All,

I would like to know is it a good practice to have a SQL Server Agent Job for each database with below Steps

1. DBCC Checkdb

2. SP_Updatestats

3. Backup_Database_full

4....

Then your primary responsibility is to adjust their expectations so they will be happy with the...

I had a client GO OUT OF BUSINESS because of this exact flaw (triggers that don't handle more than one row)!!! And I TOLD THEM IT WOULD HAPPEN before...

lilywhites (1/29/2015)

---

thanks

i could tune most of the reports....i would never let a report run on live for more than 5 minutes anyway if i can avoid it

the business doesnt want...

lilywhites (1/29/2015)

---

thanks kevin

the reason log shipping is now becoming unusable is the want to drop the restore window to 15mins. it could take 5 mins to restore the log and...

Replication is a big can of worms. I would personally avoid it for a number of reasons.

AO readable secondaries have HUGE issues, including modifying PRIMARY data structures to add...

bjames60689 (1/28/2015)

---

I understand what you are saying. Do you feel the same way when it is more exact, such as millisecond (2000-06-11 23:59:59.990)?

Basically I want to make it so...

Are you aware that using a scalar UDF does or can do the following:

1) void the use of parallelism, leading to disastrously bad performance and potentially concurrency issues

2) prevents accurate...

That's Entity Framework generated TSQL - your developers will REALLY have no clue what's going on!! :w00t:

Serializable and it's range locking is likely at least part of the issue. GUIDs...

Then you simply reissue the DML activity against the linked-server object inside the trigger. Note I have not tried to do this as a proof that it is actually...

jcosley (1/27/2015)

---

Prod database "Mother" Copy of database "Father"

Here's my scenario I need help with: I have a database that has a table called User_Group table on our Production db "mother"....

Sample create table statements, sample data and expected output please. Then we can help you more efficiently and with less chance of error.