Thursday, October 28, 2010

Dimension has no attributes…Can I make it as Degenerated Dimension?

›
One of my friends recently came up with an interesting topic where he has faced an issue with his Data Warehouse design related to Insurance...
2 comments:
Tuesday, October 26, 2010

Is Microsoft's SQL Server really cheaper than Oracle?

›
Sean McCown has written an article on “ http://www.networkworld.com/community/node/63390 ”. Good article, worth to read. Do not forget to ...
Monday, October 25, 2010

SSIS Error: Named Pipes Provider: The specified network name is no longer available.

›
A perfectly working package suddenly throws an error; “ [Lookup for - Pending Duration [7825]] Error: SSIS Error Code DTS_E_OLEDBERROR.  A...
1 comment:

Plan Caching in SQL Server 2008

›
I got many questions on the post I published “ Do we need to recompile Stored Procedures when an index is added or parameter value is vary g...
Thursday, October 21, 2010

Do we need to recompile Stored Procedures when an index is added or parameter value is vary greatly?

›
While Preethi was presenting his presentation on Query Plans at the SQL Server Sri Lanka User Group meeting, he showed a situation where que...
5 comments:

TechInsights – Malaysia – Session Ratings

›
I just received ratings for sessions I delivered in Malaysia, glad to see that the sessions have been useful and valuable for participants. ...
2 comments:
Wednesday, October 20, 2010

Understanding Ownership Chaining and Impersonation

›
Being a DBA or DBE, understanding how Ownership Chains work and how impersonate another principal for changing the execution context are rea...
1 comment: