The domains that the user is a member of, have any of these domains been granted a login? Also, if this user is a member of IT in any capacity...

Jason A. Long (10/31/2015)

---

I think that's an over generalized...

In an OLTP database, you want to minimize recompiles, so you don't want to leave RECOMPILE hint in production. However, in a DW database where tables are bulk loaded, statistics...

When executing a distributed select between two SQL Server instances, especially of the same version, the optimizer has some smarts about whether joins are performed locally or remotely for best...

mwpowellhtx (10/30/2015)

---

Brandie Tarvin (10/30/2015)

---

Eric M Russell (10/29/2015)

---

Maybe I'm missing something, but the table appears to lack a unique index on the natural key, which would allow duplicates. This would normally...

On the server running SSIS, have you installed the Microsoft.Jet.OLEDB provider (.XLS) or Microsoft.ACE.OLEDB provider (.XLSX) ?

http://microsoft-ssis.blogspot.com/2014/02/connecting-to-excel-xlsx-in-ssis.html

Also, I'm not sure if the proxy account SQLAgent is running under needs some...

Andrew..Peterson (10/30/2015)

---

True not just for developers, but really anyone who creates. I'd suspect that interrupting a writer would have the same effect. Same for an artist, architect, etc....

There have been occasions where the door to the development team room got accidentally locked, and we all just sat there in the zone for hours without hearing the knocking....

Brandie Tarvin (10/30/2015)

---

Eric M Russell (10/29/2015)

---

Maybe I'm missing something, but the table appears to lack a unique index on the natural key, which would allow duplicates. This would normally be...

Jeff Moden (10/29/2015)

---

What's "interesting" is that it would appear (I may have misread it) that they're putting the backups on the same system as the database and that...

Are the WRITELOG waits occurring throughout the day during normal operation of application or intermittedly during something like a batch load /delete or re-index?

Ed Wagner (10/29/2015)

---

Eric M Russell (10/29/2015)

---

Check what domain groups or local Windows admin role may have been granted login and access, and then check if this user is a member...

william-700725 (10/29/2015)

---

Eric M Russell (10/29/2015)

---

william-700725 (10/28/2015)

---

WHERE? Those are the ones I want but can never find. I always get...

Check what domain groups or local Windows admin role may have been granted login and access, and then check if this user is a member of that domain group. Users...

Some audit tables are WORN (Write Once - Read Never).