Just understand, you're not adding indexes to a view. A view is nothing but a query. You're creating a new object, a materialized view, that is working within a set...

A couple of possible suggestions...

I have a friend who works for a clothing company. They do most of the design work in the US, the marketing in US, Europe, India,...

sk-458789 (7/20/2010)

---

You can get the requested resultset in many ways.. here is one simple way...

Select Distinct TBL_1.EmpID, TBL_1.Name, TBL_2.UpdateTime from EmpMst TBL_1 With (Nolock)

Left Outer Join EmpMst TBL_2 With (Nolock)...

There's a new post coming up on my blog on Friday that's an introduction to statistics as part of SQL University's Index Week. Keep an eye out for it. It...

It really kind of depends on your business and your systems. For example, I work for an insurance company. We don't do umpty-gazillion transactions per/second, so measuring just transactions per...

"Dirty data" doesn't have a precise definition. One definition of it is data inside the system in an uncommitted state. It's in the middle of a transaction and therefore, dirty....

Well, no more replies anyway... :w00t:

"Dirty data" doesn't have a precise definition. One definition of it is data inside the system in an uncommitted state. It's in the middle of a transaction and therefore, dirty....

We use both SCOM and Idera's Diagnostic Manager. They monitor different stuff in different ways.

I'd say no. Your issue is that the procs are not in the cache, but it's not necessarily a memory problem. It's much more likely to be a coding issue....

But even the management data warehouse has to be enabled and the data kept in order to go back in time to retrieve it.

Basically, the answer is, unless you've...

Jack Corbett (7/19/2010)

---

If you mean volunteer for the Summit, there is usually...

He submitted, yeah. Saw that on Twitter.

Steve Jones - Editor (7/19/2010)

---

Grant Fritchey (7/19/2010)

---

Jack Corbett (7/19/2010)

---

Thanks all for your confidence, but don't commit your votes until I make it past the nominating committee AND you find out...

Jack Corbett (7/19/2010)

---

Grant Fritchey (7/19/2010)

---

Jack Corbett (7/19/2010)

---

Thanks all for your confidence, but don't commit your votes until I make it past the nominating committee AND you find out what I...