ZZartin (10/15/2015)

---

I find it amusing when they start fighting over KB of memory 😛 Or the scene where they map a bios 1 clock cycle at a time by...

maxlezious (10/14/2015)

---

Hi Lowell,

Thank you for your advice.

I agree with you that once i have crossed the 35k mark it will be easier for me to get equivalent or even higher...

Now, does anyone know how to do the equivalent of this on Android and iPhone?

Block unwanted advertisements with /etc/hosts file on Linux

http://www.putorius.net/2012/01/block-unwanted-advertisements-on.html

One option is to identify the domain name of the site hosting the advertisement and block it by adding an entry in your ..\system32\Drivers\Etc\HOSTS file.

The following contains more detailed instructions...

Modify the FOR XML subsquery to contain a DISTINCT clause on the ','+InvNo expression, which also requires adding the same expression to the ORDER BY clause.

SELECT DISTINCT ',' + InvNo

...

Lowell (10/14/2015)

---

My advice would be to take the better paying job right now. no doubt.

once you are at a higher rate, it is very , very doubtful that you would...

Go with whatever job sounds the most promising in terms of your interest, opportunity to learn new things, and where the organization has big plans in the works. That's the...

This guy must have gotten the most laughs of any tech conference presentation. 😛

https://www.youtube.com/watch?v=yL_-1d9OSdk

https://isotropic.org/papers/chicken.pdf

One design consideration for an application event logging table is the acceptable latency between when the event occurs and when the record is available for querying. If we're talking about...

What type of feedback; regarding whether you've modeled right logical architecture (facts, measures, schema, etc.) to support end user's requirements, or whether you've got a solid physical architecture (server hardware,...

Taking your story at face value, assuming it's not all in your head, it sounds like your current and previous job are on the crappy side of the bell curve....

So, you have a table with ~2,000k rows, you're deleting ~750k rows in batches of 50k, it's taking ~10 minutes, and you want to minimize the runtime duration. I'm guessing...

Data Governance is a lot simpler when databases and IT teams are not operating in silos. It helps if there is one application for each line of business, one set...

SQLmansell (10/12/2015)

---

Eric M Russell (10/12/2015)

---

Temporary tables, spools, hashes, etc. are not tied to any specific database. For example, assuming we wanted to have a separate temporary work area for each...

Temporary tables, spools, hashes, etc. are not tied to any specific database. For example, assuming we wanted to have a separate temporary work area for each databases, if you have...