adrian.buzila (9/23/2014)

---

I have the same problem with SQL2012 (11.0.5058.0) on many tables.

I checked for reseed and set identity_insert. It's not the case.

If there is a unique constraint insert fails. It...

If the drive got full is because you had an open transaction. Like it was said before, open transactions, like temp tables DMLs, can fill your tempdb. It grows until...

Yep!!!

It fixed the issue! 😛

I deployed on one of my production servers few days ago. Later this week I will set on remaining ones.

So for anyone experiencing this...

Eric M Russell (8/14/2014)

---

sql-lover (8/14/2014)

---

-- Another UPDATE ---

After testing on my Dev box I finally deployed the trace flag on two of our live servers. So far so good. And...

-- Another UPDATE ---

After testing on my Dev box I finally deployed the trace flag on two of our live servers. So far so good. And crossing fingers, it seems...

SQLnbe (8/8/2014)

---

Hey guys, sorry I'm a bit late on this but I had a question in regards the Online re-indexing in Enterprise. Does the ONLINE=ON completely eliminate the possibility of...

SQLnbe (8/8/2014)

---

Hi,

We're currently on SQL 2012 SP1 + CU3. If i wanted to install SP2 + CU1 do I have to install SP1 CU11 first which I do believe is...

Like2SQL (7/31/2014)

---

We have a SQL Server located in India; We need to move all the DB's on that server to a server residing locally for various legal reasons. The Server...

senthil kumar d (7/30/2014)

---

Hi All

We have a large Datawarehouse and the size is 50TB.. The tables are placed in filegroups based on the schema like fact, dimensions, raw data each...

Eric M Russell (8/8/2014)

---

sql-lover (8/8/2014)

---

We're about to try trace flag T272 as a startup parameter on one of our SQL servers. This trace flag brings the Identity key generator to...

sqlfriends (8/8/2014)

---

Thanks, realized it when I tried to do.

Another question, if we don't need the feature of the service pack, is it necessary to do service pack?

I found in...

We're about to try trace flag T272 as a startup parameter on one of our SQL servers. This trace flag brings the Identity key generator to its previous SQL2008 behaviour,...

UPDATE

I applied SP2 on one of my SQL 2012 servers and unfortunately, did not fix the issue.

... and after you finish "digesting" all the good posts you just read on this thread, please vist Ola's website He provides a maintenance solution that takes care of that,...

Steve Q-426954 (7/8/2014)

---

All,

I was updating (CU) a node of an AG, this was an Asnc copy in a different subnet than my production copy. SQL 2012 SP1 EE.

I tried upgrading...