SQL-Articles

Data Engineering – Learn from the experts

  • Pagination in Result Set – OFFSET \ FETCH – SQL Server 2012

    Today I’m going to discuss another new feature in SQL Server 2012. Pagination in result set is a new feature in SQL Server 2012. ORDER BY clause in SQL Server 2012 is enhanced with additional parameters that is OFFSET and FETCH. Using this parameter allows you to fetch data from a particular page from result…

  • SPARSE Column

    Happy New Year My dear Friends It’s  been a long this feature has been released however I just got an opportunity to check it out. This feature is released in SQL Server 2008 version. Sparse columns are normal columns which will store NULL values in a optimized storage which means no storage space is taken…

  • Script to Retrieve Security Information – SQL Server 2012 (Denali) and above

    SQL Server 2012 codenamed SQL Server Denali is on the way to market by 2012. As you all know SQL Server 2012 has new features related to security, we have contained database where you are allowed to create contained users and the next feature is server level roles, other security features are not related to…

  • Contained Database – SQL Server 2012

    In SQL Server Denali we have new feature called contained database that will let you move your database easily. Understood? Whatever I said is a very simple meaning of contained database, let’s see what it’s going to do and how it’s going to help us.

  • Conversion Functions – SQL Server Denali

    Microsoft released 3 new conversion function in SQL Server Denali. In which two functions will tell you whether the action is possible the third one will give you the result. Below are the three  conversion functions Try_Convert Parse Try_Parse

Got any recommendations?

Get In Touch