Gift Peddie (5/8/2009)

---

Datawarehouse more expensive that replication with limited benefit if you don't have dimension modeling expert to use your data for cubes, it also comes with the risk for...

Dean Jones (5/7/2009)

---

Hi All

I am looking for ideas here in terms of implementation, I currently have a live billing database box and the idea is to have a reporting database...

You can do this in the HTML of...

Jan Van der Eecken (5/7/2009)[hr

Samuel, no, I don't put ANDs and ORs at the end of the line. They go where they are most easily visible and comprehensible for the...

This thread reminds me of a first week at a new job I had.

I had to write a bit of C for something (I've been a DB guy since I...

Leading commas looks grammatically wrong

compare...

He'll start an anti leading comma campaign...

A bit of aliasing when quoting other people posts might help extended the life of my scroll wheel 😀

Jan Van der Eecken (5/7/2009)

---

Samuel, I agree with you, but I have to live with the shortcomings that exist, so it would be nice if Intellisense wouldn't force me to...

Jan Van der Eecken (5/7/2009)

---

Sorry to disagree, but I don't see what's wrong with this, unless your collation sequence is case-sensitive, which in most cases is a mistake in the...

Jan Van der Eecken (5/7/2009)

---

Always upper-case by the way, since I make table/view names upper-case as well. Oh, by the way, I hate the imposing behaviour that SQL2K8 (Un-)Intellisense...

Each to their own again... I prefer proper case as personally I find...

It should offer performance benefits over the...

Cross Apply usually results in hidden RBAR so no real benefit over an efficient cursor based procedure

for a simple T-SQL mailing proc the simplest solution is

Insert mailing data into temp...

greatheep (4/29/2009)

---

Unfortunately, it doesn't work out that way - we tried a single set based approach originally, and we almost always had the whole thing roll back due to concurrency...