A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
6,536 reads
John Ryle
Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
2011-10-18
6,977 reads
Blogs
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Steps for a Successful Data Migration Session at Microsoft Ignite
By kleegeek
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...
Daily Coping 2 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Using mode() in R
Comments posted to this topic are about the item Using mode() in R
Machine Learning Services on Database Server verses R Lang Execution on Laptop
We are running SQL Server 2017 (RTM) on Windows. The question came up, if...
Stored Procedure "Caching"
I'm having an issue with a database that I recently moved from SQL 2014...
Ask SSC