Brakes

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...

Greyhound

The use of TRUNC on a suspected numeric column makes me suspect Oracle. The archive: in your FROM clause tells me I have no clue.

The first step is to...

Grumpy DBA (2/23/2016)

---

^ It goes back to the old proverb I threw out in another thread... Give a man a fish, he eats for a day. Teach a man...

Jeff Moden (2/22/2016)

---

Greg Edwards-268690 (2/22/2016)

---

Jeff Moden (2/22/2016)

---

No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows...

Nice question. Check constraints are a way of enforcing data integrity by design that I wish more people used. Thanks.

I've helped several people at work where they just couldn't figure out why something so simple wasn't working and it turned out that they used varchar variables with the default...

Rune Bivrin (2/18/2016)

---

Yeah, well I read it a bit too quickly, and couldn't quite accept the idea of...

I thought it was a good, straightforward question. Thanks.

A simple one to help get my brain engaged after a very welcome vacation. Thanks.

Bichon

This likely means you have a...

Lowell (2/22/2016)

---

I've seen something similar, where a csv file was renamed to have an xls extension...so the file was not truely xls, so it could not be opened.

find the original...

If you want to have code react to an update of a table, a trigger will handle that. A procedure can read from the audit table directly and return...