I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries, you can just add them in...

You're describing Change Data Capture.

Since no one else pointed it out, I sure will:

WHERE (dbo.CLI.CLITYPE LIKE '%A%') AND (dbo.SVAC.PROGNO LIKE '%286%' OR

dbo.SVAC.PROGNO LIKE '%288%' OR

dbo.SVAC.PROGNO LIKE '%289%')

That is going to lead to some...

No. Unable to connect to server suggests that you're trying to connect to the wrong server, are running the Upgrade Advisor from a login that doesn't have permission to the...

There's not enough here. These are part of a greater process. That other process has other statements. You need to determine the order in which these statements are occurring. This...

There are simple references for normalization all over the place online. Just do a search and you'll find one.

As to a guide on database design, I'm not aware of a...

Brandie Tarvin (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Grant Fritchey (4/10/2015)

---

Brandie Tarvin (4/10/2015)

---

Not that I've ever...

Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but I'm putting...

Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

Lynn Pettis (4/10/2015)

---

Grant Fritchey (4/10/2015)

---

Lynn Pettis (4/10/2015)

---

RonKyle (4/10/2015)

---

assuming the table is not a heap (which it shouldn't be, right?), why would it...

Lynn Pettis (4/10/2015)

---

RonKyle (4/10/2015)

---

assuming the table is not a heap (which it shouldn't be, right?), why would it (at least as a...

RonKyle (4/10/2015)

---

If I can add two include columns to an index and get a query that runs 10 times a second down from 400ms to 10ms, you bet I'm going...

RonKyle (4/10/2015)

---

Interesting. I haven't personally made much use of include indexes since they do make the indexes bigger and I'm not convinced the performance gains are significant. I...

Pretty sure this is not needed for a normal connection:AttachDbFilename=C:\path\App_Data\db.mdf

You want to use the information_schema views to look for that type of information. Here's an article[/url] telling all about how they work.