Tag Archives: Common SQL Server Mistakes

Common SQL Server Mistakes – Multi Row DML Triggers

Posted on September 23, 2010 by way0utwest

How often have you seen someone write a DML trigger like this: create trigger mytrigger on Mytable for insert as declare @id intselect @id = id from inserted update xx set yyy = zzwhere id = @id return There seems … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Common SQL Server Mistakes – Multi Row DML Triggers

Common SQL Server Mistakes – Shrinking Databases

Posted on September 14, 2010 by way0utwest

I don’t like there being an easy command to shrink databases, and I especially don’t like seeing the shrink option as a part of the default maintenance plans.However it seems that this technique for managing sizes is used quite often, … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Common SQL Server Mistakes – Shrinking Databases

Common SQL Server Mistakes – SELECT *

Posted on September 1, 2010 by way0utwest

I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I go to events. One of the topics that I think has some value, especially for .NET and sysadmin groups, is … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Common SQL Server Mistakes – SELECT *