The problem is that you are converting the date to DD/MM/YYYY format, and that doesn't work properly with range logic. You need to use YYYY/MM/DD format or don't convert at...

On a medium powered OLTP database server, I would consider 100,000 rows or less to be a small amount of data. However, to understand the potential for blocking and duration...

Robin35 (12/9/2016)

---

Eric M Russell (12/9/2016)

---

Where I work, we use Octopus and Chef for automated deployments. If what you need is an account that can create a database, create objects within...

Where I work, we use Octopus and Chef for automated deployments. If what you need is an account that can create a database, create objects within that, and then assign...

Adding all these features to Standard Edition is great.

But having these new features like encryption, data masking, and compression in Express Edition also presents some interesting opportunities. We have...

Hi Jim,

Most DBAs live lives of quiet desperation and go to the grave having never called folks out on their bull$hit.

Keep us posted on your story and good luck...

Gary Varga (12/9/2016)

---

Eric M Russell (12/8/2016)

---

Regardless of whether we're interviewing for a DBA or a developer who will code SQL, one question I ask is:

"For the next 15 minutes, explain...

Regardless of whether we're interviewing for a DBA or a developer who will code SQL, one question I ask is:

"For the next 15 minutes, explain everything you know about locking,...

That comes...

I try not to be too stingy when it comes to reserving memory for Windows OS. Even if there are no other major services like SSIS running in the background,...

Ooops, Friday is coming up. You know what happens on Friday's in corporate America, especially when the screws have been tightened on access security ...

jim.powers (12/8/2016)

---

It is a tiny little database that has absolutely no impact. It will hardly be noticed and again, I even had permission from his junior network admin whom he...

Maybe stretching into Amazon or GoDaddy is an option?

... If you stretch a sales database, say a 100GB database and want to move 60GB of that data away, you're going to pay at least US$930/month for the compute...

Jeff Moden (12/7/2016)

---

Eric M Russell (12/7/2016)

---

alex.sqldba (12/7/2016)

---

Hi Eric,

Whilst it is not a heap, there is a clustered index on a datetime field, I am curious as to how one would...