Comments Off on Cursor Transformation. One of my favorite presentations to give is called, Changing Your Habits to Improve the Performance of Your T-SQL. After giving this presentation in Austin, TX this past January, I had one of my students contact me. He saw in one of my demonstration how bad cursors can perform. He wanted to see if his stored procedure could be written using set theory. The Reason For the Rewrite. What does this have to do with Cursors? .

HTML formatted table for your SQL alerts or reports. Alerts and reports in plain text are the easiest to setup, fastest to render and smallest to send so why should you bother with HTML formatting? When emails look like this, who can ignore them? I scraped some data from Twitter to load a test table and did a quick sum to see who is the top tweeter in a arbitrary span of time.