I learn about CUBE and ROLLUP function today and I found it really usefull for generating reports. Let me give you one example where we can use ROLLUP and CUBE. Lets say you are developing the E-Commerce application and administrator wants the report which shows products purchased by all user group by product and buyer. You [...]
You may receive “Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc” while connection to database. I got the error when I tried to connect to SQL Server 2005 from Visual studio 2008 using server explorer. The exact error is,
Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot [...]
