Archive for

Batch Large Deletes

A common issue with large DML operations, like deletes, is the impact on system resources especially tempdb. Even in simple mode large delete operations can have a significant impact on your database & tempdb resources. I often use the following code to batch my delete operations utilizing the t-sql windowing function capabilities (You could always … Continue reading

SQL Server numeric, float and decimals

In general use the float or real data types only if the precision provided by decimal (up to 38 digits) is insufficient so generally because the precision provided by decimal is [10E38 ~ 38 digits] if your number can fit in it, do not look at float. some more Geekologie… numeric = decimal (5 to … Continue reading

A stored procedure "best practices" checklist

When developing stored procedures, there seems to be a lot of emphasis on “get it done fast.” Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window. Personally, I would rather front-load my development time; I think that the costs I pay in initial development far … Continue reading

T-SQL performance anti-patterns. Part 1 – Data Types

What you don’t know could hurt your query performance. I will present a seven part series on the most common T-SQL performance anti-patterns. Part 1 – Data Types, Part 2 – Using Functions, Part 3 – Multi-Statement UDFs, Part 4 – Dirty Reads, Part 5 – Query Hints, Part 6 – The Dreaded Cursor, Part … Continue reading