Well at least I “passed” (4 out of 5). Hint: read the questions CAREFULLY. Most SQL users flunk performance test | ITworld.
An interesting example using a CLR aggregate function to perform linear regression. I’ve done a linear regression within an SSRS custom chart component (to draw a trend line), and I have done text string concatenation using a CLR aggregate, but I never thought of doing this. I don’t know that … Continue reading →
Script Table Data – I have used other tools to do this for ages. I can’t believe that I never knew that it existed in SQL Server Management Studio. Script Table Data In SQL Server Management Studio.