kenambrose (2/26/2016)

---

it's actually pretty easy to work with an absolute ban.

You just take any column where you would otherwise need nulls, and make a related table for it and ...

Bull Run

hlsc1983 (2/23/2016)

---

K now i am getting it. Thank u . But one doubt.

please elaborate how the trigger is to be used and what it's supposed to look like.....

Where you stick the minimum/maximum marks would probably depend on whether or not all grade types will have the same marks values for all subjects.

So yes one option would be to add 8 more columns to the subject table and that table is simple enough that might make more sense.

The theoretical best approach would...

GilaMonster (2/23/2016)

---

Anyone? http://www.sqlservercentral.com/Forums/Topic1763388-2799-1.aspx

It's not SQL Server (the UNIQUE gives that away at the least). I don't know what it is, and the OP keeps posting questions here that turn out...

Schnauzer

This reminds me of my last job which was a smallish company, they didn't want to pay for proper cooling and ventilation of the server room which happened to be...

Driver

It's also worth mentioning that each index has its own set of pages that are not the table's data pages(other than the clustered index). the only data on those...

I'm not very familiar with Australian geography but I would advise being willing to move and look for opportunities accordingly, there can be some surprisingly good opportunities in unlikely places....

What exactly is the application using the database for? Is this a data warehouse/reporting system or is it processing transactions?

If it's a reporting system then views could be a...

ChrisM@Work (2/16/2016)

---

Lynn Pettis (2/16/2016)

---

The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of...

TUellner (2/12/2016)

---

Tony++ (2/12/2016)

---

You said April 12, 2016 as a date to be out of compliance, but didn't give any details on what makes that date important.

Can you share more info...

LightVader (2/12/2016)

---

Tony++ (2/12/2016)

---

Is the implication that being on an unsupported platform is out of compliance? Is that written fact by a government or standards body, or a common interpretation...