I think we're in close agreement here for the most part. In a business context or other organizational/decision recommendation context, I do think some knowledge is needed.

My original piece was...

I agree on normalizing. In other words, store each mark as a separate row.

Student Mark

--------- ------

Bill 88.5

Bill...

What other columns are in the table? Any identity or key values you store?

First, understand the SQL Management Studio is a client application. It doesn't do anything on a server, even if it's running on the host that the SQL Server instance is...

Is there a domain of values at the end? Meaning, do you know the possibilities? Or is it a large set of possible values?

The way to do this is use...

Haven't seen anything like that.

broke

I agree you need to know something, but what is that bar? Can I analyze college spending? I think I can, though there are probably things I don't realize about...

For now. Might be PB soon.

Jeff Moden (8/11/2015)

---

Despicable types that are inhouse might like to cover their tracks by altering logs. External hackers might also try if they got in with good enough control...

Brandie Tarvin (8/11/2015)

---

Steve Jones - SSC Editor (8/10/2015)

---

I think the design of many of these auditing products is to log and detect issues, not prevent them. Nor should they be...

Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.

Charps (8/10/2015)

---

I guess one could bcp data after a schema deploy and it would all look the same, but that's also very time consuming. If we had source data (not...

Eric M Russell (8/11/2015)

---

Disk space truely is cheap. Yes, we can get a lot more storage space for our money today, but the I/O speed hasn't kept up at the...

Jeff Moden (8/11/2015)

---

Everyone I know keeps saying that "Disk space is cheap". I know better but it's still cheaper than having to work within ridiculously small confines on an...