1) How do you KNOW it is firing twice?

2) Is anyone using MERGE? That can cause what you are seeing.

3) Any other triggers floating around?

Brandie Tarvin (2/25/2016)

---

TheSQLGuru (2/25/2016)

---

1) Make sure you configure linked servers optimally for your server scenario

2) Review the object accesses. Some linked-server queries can be refactored for HUGE perf gains depending...

Downtime as in some (should be very short) locked system objects and operations on table yes.

1) Make sure you configure linked servers optimally for your server scenario

2) Review the object accesses. Some linked-server queries can be refactored for HUGE perf gains depending on if it...

In addition to DDL or DML trigger (I am betting the latter), you should NOT send an email from the trigger!! Set up and use SQL Server Service Broker for...

1) Why do you think it should be reduced further? CPUs do BILLIONS of things per second. I LOVE it when they are actually doing work for my client's queries...

This is a very odd situation!! It is troubling on numerous levels (different values on restores, non-null column with NULL value). Please pass this off to Microsoft as first blush...

meajaykr (2/24/2016)

---

We ran the checkDB on all the databases. There were 2 user databases which has index corruption.

We moved 2 databases 2 some other servers and issue is resolved.

But we...

1) Please provide create table statements, sample data via INSERT statements and expected output cases to back up what you are asking. I can't make heads or tails of it.

2)...

Do a web search for sql server gaps and island and review what you find. I would focus on Itzik Ben-Gan's stuff probably (and note he wrote a chapter in...

1) find out what happens at the 30 minute frequency

2) Anything in SQL error log before the crash?

3) trend various counters and utilizations (especially various memory buckets) from restart to...

You are NOT the first to do something with SQL Server without really understanding what you are doing or why. As a SQL Server consultant I make a lot of...

I ALWAYS provision a new SQL Server to the most recent build that the databases/applications it will house can accept, with ONE caveat: I like to wait a few weeks...

techtnt-630432 (2/23/2016)

---

Hi all,

I've been presented with the challenge of handing a migration from our current SQL 2012 Web edition to our new 2014 Enterprise running an AlwaysOn Availability Group. ...

kevaburg (2/20/2016)

---

Hi Folks,

we are doing a database Migration that involves a conversion of non-Unicode data to Unicode. The process involves the conversion of every non-Unicode table in the database...