The only way I know to do this is with a trigger. When there's an update, check to see if there are NULL values and 1s.

CREATE TABLE MyTable2

(id INT IDENTITY(1,1)

,...

david.irvine 7489 (12/18/2015)

---

My suspicions are raised as soon as I hear 'USB found on the street'. How likely is that? A few years ago there was a rash...

Ed Wagner (12/17/2015)

---

I was shopping at Wal Mart a few months back. The machine was messing up - 3 customers in a row. While I was in line,...

Xavon (12/18/2015)

---

Trying to figure out what the question had to do with a computed column had me stymied for a few minutes. I kept going back over it, trying...

I often remember this quote from you. It's a good one.

Aaron N. Cutshall (12/18/2015)

---

I saw a quote from Richard Branson the other day on LinkedIn that summarizes my feelings: "Clients do not come first. Employees come first. If...

samot-dwarf (12/18/2015)

---

Regarding extra money vs. free time for extra hours:

I think it depends on many factors. I by myself have to work not many extra hours. On the other hand,...

Sean Lange (12/18/2015)

---

Back from Disney and bringing you a song in the holiday spirit...

C’mon, sing it with me! Oooooooooohhhhhhhh……

He's making a database

He's sorting it twice

SELECT * from contacts...

Tempdb grows to the size needed based on your workload. However the space is re-used in tempdb. If it continues to grow, your workload is too large for your tempdb...

You need to check logs for issues, mainly that you don't have 823/824/825 errors or high severity errors.

IF the database seems to be going slower, likely you have indexing issues...

I'd have a login for each app, or each logical separation of activity in an app. That way a change in the password doesn't break the app.

Would I allow this...

You can query sys.procedures as well.

kmpa (12/17/2015)

---

I'm not so sure about the article's assertion that the credit card companies are suffering losses. In my experience, it is the business that accepted the fraudulent card...

Sean Redmond (12/17/2015)

---

It is the over-compartmentalisation that does it. I was a year into a job as a DBA and I had gotten a grip on what was to be...

roger.plowman (12/17/2015)

---

I simply can't pile on optional extras I'm not going to need right now (data warehousing and all the specialization that goes with that). My plate is full with...