sqlguy-736318 (12/5/2016)

---

I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a typical SS configuration, what type of response time...

I don't need any stimulus when I'm writing code or troubleshooting. It's the slower mundane days when I need caffeine.

Total response time will depend on the client and network. For a web application, you may have 2 - 3 seconds of user perceived latency on top of a query...

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.