T-SQL Technical Debt
Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but… Read More »T-SQL Technical Debt
TEXT
Big One Time Use Queries – Revisited
Just the same query that I posted months ago, but this time it is wrapped in a stored proc. I use this one often enough… Read More »Big One Time Use Queries – Revisited
Big One Time Use Queries
There is a newer version of this posting, click here. Part of my regular database maintenance or tuning routine is to look for the queries… Read More »Big One Time Use Queries
varchar(max) and varbinary(max) Questions and Answers
The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2… Read More »varchar(max) and varbinary(max) Questions and Answers