Grant Fritchey (12/18/2009)

---

I ask you, is it realistic to add & drop the same user 15 times in a row? Of course not. However, if you do it, it caused...

Well, to give the classic answer, it depends.

I think that there is some level of skill involved. While you always could be one of the 12,000 monkeys getting lucky early...

Frost

First time I've seen it on the cars in quite some time.

Well I've just added the Harmonix Fender knockoff to my arsenal and worked my way through "All Along the Watchtower (dylan)" last night with my daughter singing. It was great.

I...

I tend to agree with Jay. I think a database is kind of a collection of information, and a file system, as well as card catalog qualify. So what do...

Force, ha! I'm powerful in the ways of the word, or at least keyboard in this universe website.

Broken images came about as we upgraded servers yesterday. Finally, we got the...

I'm not sure I'd agree that SS2K5 was built to sell VS. It was a good product, groundbreaking for SQL Server in terms of growing the product. Adding in Service...

user_name()

suser_sname()

There are a few functions, depends on what you want to capture.

wow, you guys are really splitting hairs. A restart includes a shutdown and startup of the database instance. How could you argue it includes anything else? In line with a...

I had the chance to tour Falling Water in 98, and heard about a number of the issues that came about over time. It is an amazing structure and this...

A restart includes a shutdown and...

I would agree that #2 is a little incomplete. That answer has been edited and points are being awarded back to everyone that has answered to date.

Thanks, and you two are probably two of those "successful" people because of your principles.

Even with this, I'd argue you won't know.

If I update row 12 now and you update row 16 in a minute, we'll only see the last update (row 16)....

Take Grant's suggestion and create a CTE to hold the data and use that in your joins.