SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2014

Keep it simple.... you know.

Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as ExpressProfiler itself - you should always keep things as simple as you can.

Should be balance.
On one hand you have nothing that requires nothing and does nothing -…

Read more

0 comments, 480 reads

Posted in SQL Code Guard on 22 July 2014

[BP017] DELETE statement without WHERE clause

Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d inner join #ids i on d.id = i.id
As you can see, rows to be deleted are limited by joining with temporary table named #ids which apparently contains a list…

Read more

0 comments, 568 reads

Posted in SQL Code Guard on 7 July 2014