Follow Slashdot blog updates by subscribing to our blog RSS feed


Forgot your password?

Comment: Re:Bring a database down? (Score 2, Informative) 156

by killjoe (#24461765) Attached to: Diagramming Tool For SQL Select Statements

Depends on your database. I know I have been able to bring SQL server down with a query.

Try this...

begin transaction

update rows set a=b where x=y

commit transaction.

On your workstation this could run really fast because you only have ten records. On the production database server this could crush the server if you had a few million records effected.

Dynamically binding, you realize the magic. Statically binding, you see only the hierarchy.