Gary Varga (12/5/2016)

---

Eric M Russell (12/5/2016)

---

corey lawson (12/2/2016)

---

Hmm... like rebuilding an accidentally dropped table or managing to recover horked data in prod while using elevated permissions there and not telling...

Consider containing your staging tables in a separate database or file group, so they can the shrunk down without impacting your other application tables. It also prevents you from including...

If it's the data file that's gorwing, then I would next run a query like the following to get allocation details on every table and index in the database.

declare @object_name...

First, is it the data file (type = ROWS) or the log file (type = LOG) that's grown in size?

If it's the LOG file that's ballooned, then some large data...

corey lawson (12/2/2016)

---

Hmm... like rebuilding an accidentally dropped table or managing to recover horked data in prod while using elevated permissions there and not telling anyone I screwed it up...

Where I work, I've recently suggested to management that we have weekly "lunch and learn" sessions. We will block off a couple of hours on a Friday for to DBA...

Phil Parkin (12/2/2016)

---

drew.allen (12/2/2016)

---

Phil Parkin (12/2/2016)

---

Just having a mind warp on how to insert into the address table and get that unique int value and put it into the correct...

Sean Lange (12/2/2016)

---

Eric M Russell (12/2/2016)

---

Another issue is what to do when the Address already exists. Address is a separate entity from Employee, and it would break proper normalization to...

We don't need a Job Description Language, jobs can already be scripted out to T-SQL stored procedure commands. Likewise no need for a special Server Description Language; there are stored...

Assuming that AddressUno is an IDENTITY column this will be a lot easier to manage.

First insert the Address table for home address, business address, etc. and for each use the...

jonathan.d.myers (12/2/2016)

---

@ Eric: EXACTLY... It's the simple database objects that get the most attention because they're the simplest for a 3rd party tool to handle. They exist as actual OBJECTS...

Speaking of which, I've found that practically all database comparison / synchronization tools don't cover server level objects like jobs, logins, credentials, SSIS packages, or server options.

Jeff Moden (12/1/2016)

---

Eric M Russell (12/1/2016)

---

Jeff Moden (12/1/2016)

---

Benki Chendu (11/29/2016)

---

Friends,

I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I...

Jeff Moden (12/1/2016)

---

Benki Chendu (11/29/2016)

---

Friends,

I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I am using a tool called...

Area Man Uses This Simple Trick To Double His Income (AND SO CAN YOU!!)

:rolleyes: