homebrew01 (8/4/2014)

---

SQLRNNR (7/31/2014)

---

In both cases, you can upgrade from 2000. I might even restore the database onto the 2008R2 box and leave it in compat 80 for a few...

Some of the memory and CPU measurements within a VM become problematic. Again, I'd drill down to the specifics instead of using the average, but you might also want to...

You might just be seeing high PLE, but it could also be related to running on a NUMA architecture[/url]. Instead of just reading the average, get the specific values for...

Same query, but different data sets right? Which means radically different statistics? It helps explain why you might see differences in the plans selected. But, it all comes back to...

jcrawf02 (8/4/2014)

---

Jesus Grant, you throw this one to the OP like it's a "querying for dummies" book or something, and while I cannot disagree that reading it would give you...

MuhammadShafiq (8/4/2014)

---

Grant Fritchey (8/4/2014)

---

You're describing the WHERE clause of a query. You can combine different criteria in the WHERE clause using AND/OR logic to arrive at filtered record sets. There's...

You're describing the WHERE clause of a query. You can combine different criteria in the WHERE clause using AND/OR logic to arrive at filtered record sets. There's nothing you must...

raj.prabhu001 (8/3/2014)

---

Hello,

I have a fact table which has six field now and I have created non clustered index on all fields.

It will also have more fields later with millions of...

Better still, don't use trace and start using extended events. You're running 2012, so the excuse of not having a GUI has been eliminated.

As has been stated, SQL Server will use all the memory you make available to it. In order to understand if you have enough memory, I'd suggest using some of...

There's no magic. The creation of the index requires locks placed on the table that are going to prevent inserts. You'll have to finish the creation of the index prior...

Completely guessing, your database is in FULL recovery and you don't run log backups? Is the drive where the log files live full?

2gb is a very small environment. 2012 has a lot more functionality built in than 2000 does. It's entirely possible that 2000 runs faster in such a tiny environment as...

jarupan (7/18/2014)

---

Hi Grant,

This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I...

cdm33.com (7/31/2014)

---

Janson, Grant and Ed,

After poking around and reading what you had to say about what I wanted to do, I think I'm off to a good start. It's...