Avalin (5/18/2016)

---

I have a select-query using the WITH(NOLOCK) hint to ignore locks. The problem is that when the query is executed it get timed out because it's waiting for a...

I'll be at SQL Saturday Atlanta this weekend.

ColumnStore is another feature that has matured between 2012, 2014, and 2016. For example, only in 2016 do ColumnStore tables support primary keys.

Aside from comparing the execution plan generated by the two scripts, the following can be used to return usage stats (pages inserted/update, last update time, row counts, etc.) at the...

Here is the concept behind AD authentication: Users should belong to AD groups depending on what broad level of access they need to database servers (ie: MyCorp\Developers, MyCorp\QA, MyCorp\DBA). Within...

Steve Jones - SSC Editor (5/16/2016)

---

Eric M Russell (5/13/2016)

---

Personally, I don't like it when a recruiter or agency wants to make all the arrangements without me having a face to...

Personally, I don't like it when a recruiter or agency wants to make all the arrangements without me having a face to face with the employer. I also don't like...

It seems that sometimes the same spam gets posted days or weeks later. If a distinct message was previously delisted, then it should be auto-delisted if it turns up again.

In my last two jobs, which covers a span of ten years, we've used AD domain group authentication. For example MYCORP\DBA_Production, MYCORP\StoreOpsQA, MYCORP\MarketingBI. As employees are hired (or switched between...

sestell1 (5/12/2016)

---

Eric M Russell (5/12/2016)

---

There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to...

Sean Lange (5/12/2016)

---

I am clearly in the minority here. For me the IT world IS my second career. I spent a decade as a chef prior to going back to...

There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally occur in a...

It's standard practice in a star schema modeled data warehouse, where rows are versioned in what's called a 'slowly changing dimension' or 'shapshot' fashion, to have a column indicating (ie:...

Arjun Sivadasan (5/11/2016)

---

Thanks for asking Abrar. Let me start by apologizing for not answering any sooner.

The last couple of months were tumultuous. My teammates quit and I'm the only dev...

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

TheSQLGuru (5/11/2016)

---

Eric M Russell (5/11/2016)

---

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and...