You can assign a new name for a derived column in the SELECT statement which is also known as an alias name. But you need to understand how column alias are assigned and its scope
SQL SERVER – Download SQL Server 2014 Developer Edition at USD 59.59
Since the release of the SQL Server 2014 earlier this year, lots of people have been asking if people can download the full version of SQL Server 2014. SQL Server 2014 full version is not available for FREE. You have to either get standard version or enterprise version. You can…
Read MoreSQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
Have you ever needed WAIT or DELAY function in SQL Server? Well, I personally have never needed it but I see lots of people asking for the same. It seems the need of the function is when developers are working with asynchronous applications or programs. When they are working with…
Read MoreSQL – Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREE
In the new database world there are so many different solutions, vendors and options available that it is super hard to figure out which database is the right solution for us. First of all the world of the big data itself is very confusing. It is so hard to figure…
Read MoreSQL SERVER – Maximize Database Performance with DB Optimizer – SQL in Sixty Seconds #054
Performance tuning is an interesting concept and everybody evaluates it differently. Every developer and DBA have different opinion about how one can do performance tuning. I personally believe performance tuning is a three step process Understanding the Query Identifying the Bottleneck Implementing the Fix While, we are working with large…
Read MoreSQL SERVER – NuoDB in Sixty Seconds – SQL in Sixty Seconds #053
Earlier this week, I have done five part blog series on NuoDB and it was very well received by audience. NuoDB is an elastically scalable SQL database that can run on local host, datacenter and cloud-based resources. t is an operational NewSQL database built on a patented emergent architecture with full support for SQL and ACID…
Read MoreSQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…
Read More