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).

Just as a side note:

I don't know on what RDMS you learned SQL, but at least in Oracle, NULL and empty string '' are evaluated as equivalent. Also, by default...

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 a requirement for any table,...

This should give you what you want. What we need to do is simply sum the total months of service for each employee who is still active (has one record...