Daily Archives: May 12, 2011

Clean Code is Easier to Read – SQL Prompt

I saw a post recently that had query that looked like this: select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = ‘INSERT’ and b.grantee_principal_id = a.principal_id   Ugly to read, at least to me, and in a poorly … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Learn to Use Filegroups

In SQL Server, filegroups are a management technique that I don’t see many people using. It’s amazing how many people ask questions about filegroups on the discussion forums, often unsure of how they fit into a well architected SQL Server. … Continue reading

Posted in Editorial | Tagged ,