Windowed Functions empowering analytics [#TSQL2sday]
This blog entry is participating in the T-SQL Tuesday #16 for the month of February, hosted by Jes Schultz Borland[…]
Read moreCategory: Database
Migration to 2008 R2. Not as easy as Copy & Paste [Performance]
Better hardware and the latest SQL Server release does not always mean that things will run faster.
Read moreAllow me to sleep and focus on number crunching [#TSQL2sday]
Allowing me to sleep properly and investing time on number crunching.
Read moreWhat’s happening in 2011
So what is happening next year? Many exiting things, with a core focus on HA, DR, Analytics, SharePoint 2010, and VMware on production databases
Read moreTable Structure, Trading Maintenance with Performance [SQL Server]
With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.
Read moreI/O Issues on a newly deployed SQL Server cluster attached to a SAN [Windows 2008 R2]
We executed the migration of stand-alone database servers to an active/active cluster. This was for our enterprise-wide reporting solution which includes a scaled-out deployment of Reporting Services implementing F5 BIGIP as a load balancer.
Read moreDenali, the next release [SQL Server]
SQL Server Codename “Denali” Community Technology Preview 1 released
Read moreSplit a Partition and Expect Locks [SQL Server]
Not in every scenario. But as a rule of thumb, test before you perform a split operation in a production environment.
Read moreMediaWhiz’s BI Solution Goes Live [Analytics]
We presented the solution to the business owners, with multiple sample reports generated by SSMS, Regular Pivot Tables and PowerPivot for Excel. We sliced and diced at the client level, server level and the results were coming back pretty fast. They were extremely happy as they just found a way to slice “everything by everything”. I even heard the statement ”This will be the company’s biggest asset”.
Read moreData Compression before or after loading operations? [SQL Server]
Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.
Read more