Understanding this, and what it means for recovery, can be a database by database decision...

Grant Fritchey (3/11/2014)

---

First blush, no, I wouldn't say it's a "bad" design.

But, if I see varchar as a primary key, I'm assuming natural keys. There are good reasons for this...

Jeff Moden (3/11/2014)

---

Greg Edwards-268690 (3/11/2014)

---

And 5 or 6 lines of MDX likely solves the whole thing if you build a cube.

Or use PowerPivot in Excel to let the user play...

I see nothing wrong with a 3 author article.

Or at least send it to a couple of others for comments / feedback at this point.

dwain.c (3/11/2014)

---

Jeff Moden (3/11/2014)

---

Greg Edwards-268690 (3/10/2014)

---

Luis Cazares (3/10/2014)

---

Lynn Pettis (3/10/2014)

---

If any one has some free time this person could use some help. I don't have the free time at...

Koen Verbeeck (3/11/2014)

---

GilaMonster (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

Grant Fritchey (3/11/2014)

---

By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just a...

Luis Cazares (3/10/2014)

---

I've wasted a lot...

Pretty sad when they want someone to just do their homework.

Almost makes a person want to...

J Livingston SQL (3/10/2014)

---

maybe of some use

with cte_names as

(

SELECT StudentID, MAX(StudentName) AS StudentName

FROM lcdscores

GROUP BY StudentID

)

SELECT lcdscores.StudentID

...

bsmith 63193 (3/10/2014)

---

IT wasn't notified of the project until last minute. An excel spreadsheet was already distributed out to teachers to submit their scores with. It's not the ideal situation,...

Many factors come into play, it is not just the number of rows.

How the data is being queried, indexes, etc. play a part.

You need to see and understand what is...

I see the Cursor word.

Getting to the core of the locks might be best.

Skipping over locked records, unless you get back to them, you likely did not do what you...

In SSMS, go to Help... View Help.

This will pull up Books On Line.

Typing Average in the upper right search box will bring up relevant topics.

If time is of one of...

Sometimes...

So you were running the TSQL query from a 3rd machine as outlined in the original post?

That is where the double hop comes in.

Generally, with SSAS, you have some cube...