sqlguy-736318 (12/6/2016)

---

I'm trying to understand relative sizing for design conversation purposes. For example, in this context, would it be reasonable to state that?:

* Selecting 1 row from 1 table...

krishnaroopa (12/6/2016)

---

Hi all

I have a table "test" in my "testdb" database. There is a user "user1"

The user has access to all tables in the database.

For this particular table...

This has actually been a recurring theme in my career, and my nature is a multi-phased blend of all three mentioned approaches: passive, then systemic, and finally nuclear. The first...

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...