Another good reason to be replaceable is that you should be able to "hand off" to a coworker so you can advance within the organization. If you've built yourself...

Robert.Sterbal (11/21/2012)

---

I wish I could get the developers here to log some of the baseline data into the database. I often baseline information from tables that have large numbers rows...

I am looking forward to the rest of this series. You write well, so large paragraphs are not a problem at all - but if you'd like to put...

Why is this called "T-SQL Powers" if the topic is bitwise xor ?

I was a little confused since the notation 2^3 = 8 is fairly common. When I didn't...

cfradenburg (11/9/2012)

---

paul.knibbs (11/9/2012)

---

It's difficult to think of a situation where this would arise...is it actually possible to get an untyped NULL via any means other than just typing NULL into...

While it is an interesting exploitation of an edge case, when does this situation happen in real code?

Does this example illustrate a Fail in the implementation/execution of coalesce()? I...

Michael Valentine Jones (10/5/2007)

---

This works well for me

1. Set delivery date

2. Do some programming

3. Test

4. If test is good, go live, else go live

5. Define requirements

6. Repeat 1 through 5...

Toreador (10/3/2012)

---

As usual the lesson is not to rely on the defaults.

I'd have expected a near 100% success rate given the number of similar questions we've had in recent months,...

I'm not sure why anyone would think/talk about identity_insert this way. I understood this command was useful in the hopefully rare case where rows are restored to a table...

This article is missing some article. I was surprised that such would be...

Jeff Moden (9/23/2012)

---

By the same token, there are also many myths that need...

I don't understand why "holes" in the identity values should be considered a problem.

Can you provide more of the backstory as introduction to the script?

Steve Jones - SSC Editor (8/16/2012)

I think Assembler is too hard. The concepts there are unlike anything else, but lots of stuff builds on C. I started with BASIC and...

Eric M Russell (8/15/2012)

---

If I had to teach all college graduates one language, it would be SQL. It's more practical than C. Most all developers these days write at least...

CELKO (8/7/2012)

---

Why not use a Calendar table with whatever fiscal or reporting years you use? The GAAP had 250+ the last time I looked. SQL is not a computional ...