Monthly Archives: March 2011

Avoiding Logging

Posted on March 8, 2011 by way0utwest

As I have been studying more about SQL Server internals this year, one of the myths that keeps being debunked is the idea there are operations in SQL Server that are not logged. That’s not true as everything you do … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Avoiding Logging

SQL Server Truncate Table Permissions

Posted on March 7, 2011 by way0utwest

I saw a note recently where someone asked what permissions were needed for a user to execute TRUNCATE TABLE. In previous versions we needed ownership of the table or DBO level permissions. I had thought this was changed in SQL … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Common SQL Server Mistakes

Posted on March 7, 2011 by way0utwest

This presentation is designed to cover some of the basic mistakes that I find people making quite often when working with SQL Server. It is a mix of development and administrative items, designed to help beginners get a grounding in … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Common SQL Server Mistakes

The Wisdom Department

Posted on March 7, 2011 by way0utwest

The more that I work in business, the more that I think that there truly is more to a company just maximizing the amount of money you can make. We often say that a business exists to maximize profit, but … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Wisdom Department