GSquared (5/15/2008)

---

I think this may be a case of "mashed potatoes statistics". Lots of just about any demographic group are musicians, or at least want to be and play...

satz (5/15/2008)

---

I did not think about this till now but most of the people on the motorcycle forums i visit are all IT guys. I ride with a big group...

John Reid (5/15/2008)

---

It might of interest some readers to know that current professional music creation software now often uses SQL database technology, e.g. Sony's ACID Pro has used MSDE/SQL Server...

First of all, I want to say thank you everyone who has/is responded/responding, and thank you to Steve who decided to post this editorial.

tracey.cadwall (5/15/2008)

---

Violinist here. Started playing when...

Jeff Moden (5/11/2008)

---

Actually, the method you've shown won't work either... the INTO is in the wrong place. 😉 As a sidebar, you really shouldn't use global temp tables... to...

In re: to the two most common "excuses" not to write:

1) "I am not a good writer," and

2) "I don't have anything original."

Firstly, we IT people don't get paid to...

@Lynn, but you are already a prolific writer, as evidenced by your contribution to this forum! 😀

I just want to say this to all the people who are worried that their contributions would be useless because they aren't "experts."

First of all, who is an expert? Are...

Erich Brinker (5/9/2008)

---

I would agree with Jane. I have been a DBA for almost 4 years. For me the hard thing is to transition from the person...

Jane Matheson (5/9/2008)

---

I've thought about writing and even saved information I was working on for topics that I thought would be interesting. Why haven't I actually submitted an article?...

I love to write. As many others have already commented, writing is one of the most, if not the most, cathartic activity once can partake in to enhance clarity of...

Ah, you are right. You can add an IDENTITY column to the table after the SELECT INTO, which will act as the index. But by this time you might be...

If the data set is large, and there are no FKs defined on the table, a faster method might be to SELECT INTO a physical table (which will create the...