GilaMonster (12/14/2016)

---

Hey. Long time no see. How's things going?

I'm going to recommend against that. I'm busy (trying to) fix...

ScottPletcher (12/13/2016)

---

I see some strong advantages to the combined-bits approach.

To distinguish NULL values, I think you'd need another column of the same int type, with bits in it to indicate...

Hugo Kornelis (12/13/2016)

---

Sioban Krzywicki (12/13/2016)

---

I want to use a bitwise column because there may be more columns added in the future. With a bitwise column, you just add a new...

Jack Corbett (12/13/2016)

---

Hey, long-time no hear from.

Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe...

I want to use a bitwise column because there may be more columns added in the future. With a bitwise column, you just add a new value. With bit columns...

TheSQLGuru (11/17/2016)

---

Sioban Krzywicki (11/17/2016)

---

TheSQLGuru (11/17/2016)

---

Need quite a bit more detail here to help.

Anytime code works sometime and not others you need to take a REALLY close look at the...

TheSQLGuru (11/17/2016)

---

Need quite a bit more detail here to help.

Anytime code works sometime and not others you need to take a REALLY close look at the logic and especially...

Nope

Please see this MS reply. This is a known problem with 2008 & will not be fixed. This thread gives a workaround.

intermittent NULL failure

j-1064772 (6/15/2016)

---

"... I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all...

wojciech.muszynski (5/9/2016)

---

Sioban Krzywicki (5/9/2016)

---

I believe I saw Jeff Moden of these forums post a simple, truly random generator.

SELECT (ABS(CHECKSUM(NEWID())) %20) + 1

This generates random numbers between 1 and 20. To...

I believe I saw Jeff Moden of these forums post a simple, truly random generator.

SELECT (ABS(CHECKSUM(NEWID())) %20) + 1

This generates random numbers between 1 and 20. To have a different...

Eric M Russell (4/29/2016)

---

If you really want, you can also model an entire database containing objects with only spaces for names.

create database [ ];

GO

use [ ];

GO

create schema [...

There is a Details file, but it is massive. Thanks for pointing me to it. I'm going to pass it on to the IT team and see if they can...

Grant Fritchey (4/29/2016)

---

Sioban Krzywicki (4/29/2016)

---

John Mitchell-245523 (4/29/2016)

---

Sergiy (4/28/2016)

---

There is nothing wrong with objects or columns named Number, Version, Join, etc.

The names don't affect performance or quality of the code anyway.

It's...