Percy Reyes

SQL Server 2022 brings a comprehensive suite of features designed to enhance the development experience, improve performance, and strengthen...

It is well known that PIVOT is one of the new features included in SQL Server 2005 which allows to convert rows into columns. But what happ...

At times we do need to carry out some tasks related to figure out certain information about references among some database objects. Today...

It is well known that developing and integrating applications based on different technologies may end up being a huge challenge, especially ...

Beyond all doubt, using old-fashioned ways of manipulating database objects is not only a wasting of time but also boring. Therefore, it is ...

SQL Server 2012 CTP1 is coming up with a new object named SEQUENCE which allows to manage sequence numbers between 2^31 – 1 and 2^31 –1. SEQ...

It is known that ORDER BY clause has been improved in 'Denali' (code name of the upcoming version SQL Server 2012) adding more optio...

Definitely, we were sometimes in a need of a new technique to insert data massively in SQL Server 2005 and previous versions. We used to do ...

Some of the SQL Server 2005 new features are the Ranking functions which are used to analyse data. Among these functions we have, for instan...

With the arrival of SQL Server 2005, we have many new features available to make the most out of it. Today's post is going to be about o...