That's why you always have an open position available for a great developer. If one is available, and they rarely are, you hire them if they want to work for...

N/A is a character value, you cant mix types within same column, so you must CONVERT() the date to character.

umailedit (5/27/2016)

---

Why is this not possible?

Candidates can be placed in front of a terminal in another room (so you don't know if they...

I myself am a middle-aged white man. My fellow DBA team members consist of: a middle-aged Nigerian-American man, a younger Nigerian-American woman, a younger Tanzanian-American man, two middle-aged Indian-American men...

Rod at work (5/27/2016)

---

Recombinant (5/27/2016)

---

For a long time I have disagreed with bosses and organisations in some jobs but then got on OK in other jobs. Things came to a...

peter.row (5/26/2016)

---

Eric M Russell (5/23/2016)

---

If you're deleting a total of 100 million rows, then deleting in batches of 10,000 would be too small, because there will be 10,000 iterations of...

Below is a bulk delete script a wrote a couple of years ago. At the time, I had database recovery model set to SIMPLE (truncate log on checkpoint). It also...

If you're deleting a total of 100 million rows, then deleting in batches of 10,000 would be too small, because there will be 10,000 iterations of the loop. Each loop...

There are some conversational style SQL Server related podcasts where the host interviews a different professional in each show.

http://www.sqldownunder.com/Podcasts

http://www.sqlserverradio.com/

Stuff by...

Also if you are forced to comply with an unreasonable request, then give them the bare minimum required. For example, keep in mind that the 'SA' account and SYSADMIN are...

When dealing with unreasonable requests coming from a position of higher authority, your first response should be to object. But remember to do it in a friendly and helpful way,...

Properly commenting code blocks that were modified in a branch is essential. All of my comments will contain a change tracking number, so it even if my one sentence explanation...

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.