I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again. Let us learn about the different operations about the unions.
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2
“How do I return a few of my resultset rows at the bottom of the entire resultset?” I was previously asked this question and my response was that we can do this by using the CASE statement in the ORDER BY clause and I wrote a blog post describing the…
Read More
SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050
This journey of SQL in Sixty Seconds we started almost a year ago and today we are at very interesting milestone where I am recording 50th episode. Thought I wanted to keep the length of each video to sixty seconds, sometimes it went up by a few seconds. Due to this we are also at very…
Read More
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script
“How do I return a few of my resultset rows at the bottom of the entire resultset?”
SQL SERVER – Discussion – Scale-up vs Scale-out Architectures
Note: NuoDB is a complete re-think of relational databases with innovative support for the Cloud’s dynamic, asynchronous nature. Download NuoDB to experience the Scaling Out scenario discussed in this blog post. Scaling Up There are many different ways of scaling SQL Server to accommodate more transactions and throughput. The general scale-up approach includes:…
Read MoreSQLAuthority News – Webinar SQL Server Locking and Concurrency by Rick Morelan
My book co-author Rick Morelan is giving away SQL Queries Book and DVD set (valued at over $200) in his next webinar. SQL Server is known for handing many requests at once and updating as new data comes in. If concurrency allows many things to happen at once, and locking prevents…
Read MoreSQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013
It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event where we appreciated “Women Power”. We had…
Read More