SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Friday, December 28, 2012
SQL Server: Choose the Right Data Types
An oldie but a goldie from Aaron Bertrand: “Bad habits to kick : choosing the wrong data type”
Sunday, December 23, 2012
Several Reasons Why Coding is Hard!
I was looking up something Unicode related and I came across Jon Skeet’s talk on why coding is hard: why do fundamental datatypes such as floating point, strings and DateTime cause so many problems. The slide deck and transcript is here.
The only thing I’d add is that arithmetic might be easier if we had 12 digits rather than 10, rather than the 8 mentioned, but that’s another story…
Saturday, December 22, 2012
SQL Server: Can a stored procedure cause a memory leak?
Yes, a memory leak is possible if you forget to call sp_xml_removedocument (for each matching
DECLARE @xml_text VARCHAR(4000), @i INT
Another form of memory leak is forgetting to both close and deallocate a cursor:
DECLARE c CURSOR
Just for the record, even though I always like to see an explicit CLOSE and DEALLOCATE for cursors:
[Note: I rarely use cursors. Wherever possible and appropriate, I always try to do it the set-based way]
MSN, Email: mitch døt wheat at gmail.com