Area 51 » Nick Chammas

Notable posts:

• Debunking a persistent SQL Server myth about TRUNCATE.
• Debunking another SQL Server myth about variable declarations causing proc recompiles.
• Understanding how certain SQL Server functions dynamically cast their output.
• Using a recursive CTE to find the first ancestor in a hierarchy to satisfy certain conditions.

I am a Database Developer and Administrator. My specialty is database design and development, and in my spare time at work I like to develop highly specialized visualizations (generally using Processing).