We have a similar system here referred to as KIX (Keys and Indexes) and another for permissions. The reference tables contain what should be the case.

The foreign keys, table indexes...

I agree with this. A deployment script should always take a database to a known destination state, irrespective of what was there before. Just as an aside, OBJECT_ID can take...

PHYData DBA (3/9/2015)

---

cookie SQL (3/9/2015)

---

I would look at the active portions of the log 'DBCC LogInfo' , check that its viable to shrink or it will just fail.

The other thing...

cookie SQL (3/9/2015)

---

I would look at the active portions of the log 'DBCC LogInfo' , check that its viable to shrink or it will just fail.

The other thing not mentioned...

kevaburg (3/9/2015)

---

Good morning!

This is certainly an interesting topic because in our firm we have two DWHs in place to facilitate a cut-over from one system to the second. The...

I'd agree. It's using a sledgehammer to crack a nut. You already have two technologies that can perform the colour calculation fairly simply: SQL or SSRS. Doesn't need another. On...

I would have loved to have seen a shuttle launch. The UK is a bit far off. Maybe I can go and watch one of Elon Musk's little toys blast...

I log my life on a spreadsheet, weird as it sounds with a row/day from birth. I'm currently on row 15-thousand-and-something. I have columns for things like:

- where I slept...