Today I ran into a performance/scalability problem with a group of stored procs I’d written earlier this week. All the procs passed basic unit-testing, but once I increased the load from processing 100 records to 100,000 records…you know, to make sure it scales and stuff…the test went from < 3 seconds to over 35 minutes!! […]
Author: Bill Anton
One of the major benefits associated with ColumnStore indexes is increased I/O performance. Below are two of the more common explanations for this bump in I/O performance… ColumnStores only retrieve data (from storage) necessary to satisfy the query This notion is inherent in the column-oriented architecture…data pages in column-oriented storage only contain data from a single […]
For the vast majority of SQL Server professionals, it wasn’t until earlier this year, with the release of SQL Server 2012, that concept of “ColumnStore” (as opposed to RowStore) popped up on the radar. And now, as part of the research for a current project, I’m trying to find details on Microsoft’s implementation of the ColumnStore index…but since […]
Currently, I’m working with a client to develop a custom database application that will be used for tracking and reporting on account receivables. We have estimated between 2-3 billion transactions per year and need to maintain 3 years of history…so it will be a fairly large database. But more interesting that the sheer size of […]
This morning while coding a stored procedure for a SQL Server 2012 SSDT project in Visual Studio, I noticed an interesting little blue squiggly under one of the column references in the WHERE-clause of the statement I was working on. Curiously, I hovered the mouse over it and was pleasantly surprised to see the following […]
Categories
Robert Frost and Pie Charts
Earlier this year, Microsoft released an incredible self-service reporting and presentation tool called Power View (with SQL Server 2012). It’s highly interactive, has excellent visualizations, and I could go on and on about the value it adds to businesses currently leveraging the Microsoft BI stack. Instead, I’d like to point out the huge statement Microsoft made […]
byoBI.com 