by andrew novick | Aug 31, 2014 | Past Events, Presentations, SQL Performance, Talks and Seminars, Videos, Webinars
This webinar is now available for viewing online at any time. (About 60 Minutes) http://www.mssqltips.com/sql-server-video/332/proving-sql-server-performance-by-writing-faster-tsql-code/ Some of the concepts we will cover include: Ways to find code that’s slow:...
by nsadmin | Aug 13, 2014 | Problems Solved
Problem: Level 16 Errors Can’t always be handled by User Code The Books-OnLine (BOL) is wrong. It says that errors with Level 16 and below can be handled by user code. In particular by examining @@Error. Unfortunately, level 16 errors can not always be...
by andrew novick | Dec 15, 2020 | SQL coding
I responded to a posted question about the EOMONTH() function, which was: if there’s an EOMONTH function, why isn’t there a start of month function. The reason is that DATEFROMPARTS does the trick. It was added in SQL 2012 along with EOMONTH and...
by Ian Bachman-Sanders | Dec 10, 2020 | SQL coding
This article continues where the last one left off. If you’d like and go back and read that one you can find it here. In that article, an updatable view was created to replace an existing table. The table had been named myData and was renamed myDataBaseTable....
by andrew novick | Dec 9, 2020 | SQL coding, SQL Performance
I attended a webinar on Microsoft Databricks yesterday. The only link I have is a zoom registration so you’ll have to search. I’m sure they’ll run it again. The hands-on-lab made it very worthwhile. The rest was marketing fluff. They did a good...