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

If all you want to do is trace delete operations on the table that match specific criteria, that is resolving the root cause of some issue caused by a user...

I'm holding out for R#.

My understanding is that you want to trace what application, login, session, statement, etc. is issueing specific types of DELETE operations against a table. You can do this using an...