Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should support. Locking by...

Gianluca Sartori (12/28/2011)

---

NOLOCK? :sick:

With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?

As far as the dangers is concerned, you could read...

Joe Johnson-482549 (12/28/2011)

---

I agree with you Steve. This was a communications blunder that is going to wipe out that company. The uproar would never have gotten so bad...

I had a stored procedure once that updated plenty of tables that would have created a mess when executed concurrently by different users / processes.

So I encased the entire procedure...

lrutkowski (12/20/2011)

---

I actually prefer my model database to be in Simple mode. If I need full recovery, I change it, when I create a new database, then I change...

In my experience, SQL Server doesn't enforce unique column...

opc.three (10/25/2011)

---

patrickmcginnis59 (10/25/2011)

---

opc.three (10/25/2011)

---

So far there are 43 responses to the poll with a breakdown as follows:

60.47% of responses were I do too. There are so many different ways to...

opc.three (10/25/2011)

---

So far there are 43 responses to the poll with a breakdown as follows:

60.47% of responses were I do too. There are so many different ways to get things...

opc.three (10/24/2011)

---

patrickmcginnis59 (10/24/2011)

---

This discussion is pretty good except that I'm not really understanding the actual attack surface issue itself. The closest I could find on the web is that an...

This discussion is pretty good except that I'm not really understanding the actual attack surface issue itself. The closest I could find on the web is that an attacker could...

I've done this with the dreaded xp_cmdshell driving putty's ssh and scp, putty is so good at running unix shell scripts and copying files, I've pretty much decided that samba...

Mad-Dog (10/18/2011)

---

Hi,

how i can write a case statement or any other solution from this example that will show me only one row from colb if colb are the same?

THX

create table...

Often I'll test the criteria with a select statement before running an update statement with the same criteria. Obviously done outside of a transaction this isn't foolproof as other updates...

Well I'm sorry, it seems you actually did discuss the quote. So my apologies for that.

Evil Kraig F (10/13/2011)

---

VBA has much better syntax and a more sophisticated parser. T-SQL's main...

Evil Kraig F (10/13/2011)

---

Must admit, that's kind of funny, considering your later comment about things being common on the...