Matt Miller (#4) (1/8/2016)

---

Eric M Russell (1/7/2016)

---

... I saw was of a press conference where the upper management of VW seems to indicate that the software developers on the project...

After successfully logging in, check the SQL Server Logs for any out of the ordinary events ocurring around the same time as your initial slow login. Also, consider using SQL...

Two common and simple patterns for inserting rows into TableA from TableB where the rows don't already exist in TableA.

INSERT INTO TableA ( id, a, b, c )

SELECT id, a,...

We also use PSExec using either Execute Process task or a WScript. However, I would suggest avoiding any workflow that involves running remote processes, because it's a weak point of...

The best tool for creating tables from a logical model is an experiened database developer who knows what a clustered index and foreign key are and how to use them....

When deleting or updating a set of rows based on IDs derived from other related tables, it can be helpful, for both performance and readability reasons, to first select the...

Are the newer, digital, internet enabled back boxes really more "advanced" ?

My assertion is that the older analog devices are probably more reliable and less prone to data hacking,...

Yes, data buffers allocated by SSIS during execution consume memory separate from that reserved by SQL Server, which is why it's reccomended that SSIS be installed on a separate server.

Here you appear to be selecting TOP X rows without an explicit sort order. I'm assuming that ORDER BY (SELECT NULL) is essentially nullifying the sort order, which could potentially...

No, you don't bring THAT up in an interview....

Querying and managing XML data is a topic for which I don't get exposure to in my day to day job, and it's a bit of a struggle to switch...

swoozie (1/7/2016)

---

This is so laughable. We all know, developers only do what they are told, and only do it with the least amount of work to accomplish the task....

If I were on that VW software team, I'd approach the CEO without an appointment, turn in my resignation, and then demand a special $500,000 severance package... with the agreement...

There...

neomerdien (1/6/2016)

---

we dont issue direct deletes, that's the thing. we have proper cleaners (SPs) based on criteria, the problem is that somehow a rogue process somehow manages to delete rows...