Maybe, but there is a large, very active SQL Server community on twitter and we use it daily to bond, teach, learn, and build relationships.

There's...

Two...

Gary Varga (2/2/2012)

---

Rod at work (2/2/2012)

---

Semicolons will at some point be required in T-SQL? Really? I've seen it used in some cases, but am completely uncertain as to...

Gary Varga (2/2/2012)

---

It was when I looked at the side-by-side stored procedures example that it became clear. Literally!!!

I shall be using the = syntax moving forward. My reasoning? The intention...

paul s-306273 (2/2/2012)

---

I've used the SELECT 1 x; format for years. (Oracle background).

I've never found it confusing - I don't now discard that format just because somebody else finds it...

We'll see. I...

Points were awarded back.

I cut / paste the wrong way. I can't change the answer once people have answered, so I was looking to move answers around.

It's becoming too hard to track all the T-SQL between all versions, so I left this off. SQL 2005 is out of...

My apologies. I think I selected the wrong answer when reworking things. The original answers weren't quite clear, so I altered them.

I have fixed things, and awarded back points.

life is more of an issue with writes than reads. If you are using these mostly for reads, I wouldn't be as worried as if you use them with lots...

I tend to agree with TheSQLGuru, make sure you get enterprise grade SSDs.

TDE encrypts the data at rest, on disk, and the backups. There is CPU overhead for this.

Encrypting the data, so that a DBA or unauthorized user who accesses the database,...

I'm not a replication expert, but all subscribers? Or certain ones?

If I make changes to rows at the publisher with "red", "green" and "blue" values. Does the (or all) subscribers...

I'm slightly confused. You are using a lot of pronouns, and using "replica" a lot and it's not clear what you mean. I assume you mean an individual node...

GSquared (2/1/2012)

---

Looks...