Daily Archives: February 18, 2014

TSQL2012 – Less frequently used features – Revision 01

I have started revising TSQL2012 book, thought of capturing few less frequently used features/clauses: * WITH TIES * PERCENT * OFFSET-FETCH Filter — To eliminate first x rows in the result set * Window Functions – rownumber() over PARTITION * … Continue reading

Posted in Uncategorized | 1 Comment

MPP Viewer – Link

I had to open .mpp file but I do not have Microsoft project. http://sourceforge.net/projects/mppviewer/ was handy, helped me to view details.

Posted in Referene, Useful Link | Tagged , , , , , | Leave a comment

Microsoft product lifecycle information

http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=&Filter=FilterNO This link helps to find Microsoft product Lifecycle Start date, Support end date, and Extended Support end date Difference between Main stream and extended support: https://support.microsoft.com/en-us/help/14085 Lifecycle Policy FAQ: https://support.microsoft.com/en-us/help/17140/lifecycle-faq-general-policy-questions

Posted in Referene, Useful Link | Tagged , , , , , | Leave a comment