Super_Grover (10/23/2016)

---

Hi all,

I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...

It appears that first...

This is why corporations hire their own staff lawyers and scientists; they don't want to know how best to do things; they just want to know how close to the...

When we speak of no-schema databases and analytical tools, I assume we're referring to a data store essentially intended for staging and exploration. It truly is a bucket of 1s...

I'm not too concerned about how masking or hashing of demographic data in development skews data statistics and performance testing. When coding SQL or designing indexes, it's best not to...

In addition to using a version control system like Git or TFS, where a copy of working code is committed both locally and on the server, it also helps if...

scarr030 (10/21/2016)

---

Hey all,

I actually just got promoted to our DBA position, which has been vacant for quite a while. There is very little documentation on our set up and what...

Ed Wagner (10/21/2016)

---

Phil Parkin (10/21/2016)

---

chocthree (10/21/2016)

---

All, I thank you for each of your responses. Much appreciated.

Ok, here is the deal. I'm a little long in the tooth and have done...

Yes, checklists are essential for database administrators, and even experienced DBAs are not in the habit.

However, it's not exactly a ground breaking idea.

Brad’s Sure DBA Checklist

https://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/

Brent Ozar's SQL Server...

The next phone I get, I'm just going to snatch one out of the recycle bin at the grocery store. Considering the way so many folks upgrade every time a...

Arriving home around 6pm, after cooking and eating dinner, helping kids with homework, having some one-on-one time with the wife, and then an hour of exercise or household chores, there...

So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints on each of these...

ZZartin (10/20/2016)

---

Eric M Russell (10/18/2016)

---

One thing that can be said for single tier development tools like MS Access and FoxPro, they allow a developer to quickly stove pipe a complete...

samuel.shollenberger (10/20/2016)

---

While I agree that much of the "codswallop" could be done away with tomorrow, there is a certain amount of "irreducible minimum" that is needed to be sure it's...

Grant Fritchey (10/19/2016)

---

The best way to do this is to give each developer their own local instance and their own local copy of the database. For this to work well,...

You can do something like this. What it does is delete all rows where there are matching rows having the same key columns but a greater DateAdded. You'll need to...