When we are using DISTINCT we can’t use ORDER BY as we want. If you are going to use DISTINCT when you have ORDER BY, all ORDER BY attributes should be in the SELECT phrase.USE AdventureWorks2012;-- Works fineSELECT BusinessEntityIDFROM HumanResources.EmployeeORDER BY BirthDate;-- FailsSELECT DISTINCTBusinessEntityIDFROM HumanResources.EmployeeORDER BY BirthDate;-- If you are going to sort with distinct result should consist attribute that ...
When we are using DISTINCT we can’t use ORDER BY as we want. If you are going to use DISTINCT when you have ORDER BY, all ORDER BY attributes should be in the SELECT phrase.USE AdventureWorks2012;-- Works fineSELECT BusinessEntityIDFROM HumanResources.EmployeeORDER BY BirthDate;-- FailsSELECT DISTINCTBusinessEntityIDFROM HumanResources.EmployeeORDER BY BirthDate;-- If you are going to sort with distinct result should consist attribute that ...
I wrote about Programming SQL Server 2012 book before few months. But that book was not for beginners, it was little bit advance and not easy to catch the things from scratch. But Querying Microsoft SQL Server 2012 book is a good book for a beginner. I was waiting for this book’s release. Because I wanted to know the things ...
I wrote about Programming SQL Server 2012 book before few months. But that book was not for beginners, it was a little bit advanced and not easy to catch the things from scratch. But Querying Microsoft SQL Server 2012 book is a good book for a beginner. I was waiting for this book’s release. Because I wanted to know the ...
I wrote about Programming SQL Server 2012 book before few months. But that book was not for beginners, it was a little bit advanced and not easy to catch the things from scratch. But Querying Microsoft SQL Server 2012 book is a good book for a beginner. I was waiting for this book’s release. Because I wanted to know the ...
Everybody talks about how to handle big data? and What are the technologies we are going to go with? What are the technologies that we are going to drop when we move towards the big data? What are the concepts that we put away when we move to big data? I even had such problems in my mind. And I ...
Everybody talks how to handle big data? and What are the technologies we are going to go with? What are the technologies that we are going to drop when we move towards the big data? What are the concepts that we put away when we move to big data? I even had such a problems in my mind. And ...
Everybody talks about how to handle big data? and What are the technologies we are going to go with? What are the technologies that we are going to drop when we move towards the big data? What are the concepts that we put away when we move to big data? I even had such problems in my mind. And ...
In a previous blog post about Titan, I mentioned about Titan supports three different storage back ends. For this, you need Titan and Cassandra both.Download Cassandra HereDownload Titan HereThen extract Cassandra and Titan both into a folder and take a terminal or a command prompt. Go to Cassandra bin and run cassandra.bat or Cassandra. Before this, you have to set ...
In a previous blog post about Titan I mentioned about Titan supports three different storage back ends. For this you need Titan and Cassandra both. Download Cassandra Here Download Titan Here Then extract Cassandra and Titan both into a folder and take a terminal or a command prompt. Go to Cassandra bin and run cassandra.bat or cassandra. Before this you ...
In a previous blog post about Titan, I mentioned about Titan supports three different storage back ends. For this, you need Titan and Cassandra both.Download Cassandra HereDownload Titan HereThen extract Cassandra and Titan both into a folder and take a terminal or a command prompt. Go to Cassandra bin and run cassandra.bat or Cassandra. Before this, you have to set ...
I have used Neo4J as my first graph database. And it had web console which makes more easier to handle. But this time I'm not going to tell you how to getting started with Neo4J. This time we are going to work with Titan which is an open source project which is held by Aurelius. This database is more scalable ...
I have used Neo4J as my first graph database. And it had web console which makes easier to handle. But this time I'm not going to tell you how to get started with Neo4J. This time we are going to work with Titan which is an open source project which is held by Aurelius.This database is more scalable graph database. ...
I have used Neo4J as my first graph database. And it had web console which makes easier to handle. But this time I'm not going to tell you how to get started with Neo4J. This time we are going to work with Titan which is an open source project which is held by Aurelius.This database is more scalable graph database. ...
I posted blog posts about Windows 8 Developer Preview and Consumer Preview. And now I'm using Windows 8 Enterprise Edition on my sweet heart laptop. Not like Windows 7, Windows 8 is light weight. And easy to use for me because I used Windows 8 from Developer Preview onwards. But some of new users get lost with Metro-UI. Although some ...
Every year I'm having a problem with host or domain or anything related to my blog. Some times I changed my domain. Sometimes I changed the style of blogging. So many new things happened to my blog. But most of them make it more cool. Now I'm only blogging on IT things. And most of the times they are related to Database and this time I hope this change will last for long time! Enjoy my blogging!!!
I really suffered while using MongoDB Shell because auto completing was not there. I was very hard to type collection and database names correctly. I wished IntelliSense to get into there. I'm tough Microsoft User. Because of that I love IntelliSense a lot. ;) And there was no any other solution to me to make done MongoDB things easier. Because ...
I have seen in many video tutorials they have different tabs for Editor, Results, Messages and Execution Plans. And they are streched over complete screen. Most of the times need to resize the result area to see our results. Actually its annoying me. Then I noticed in on of Paul Randal’s video he uses Separate tabs for Results editor and ...
Yesterday I wrote a post with same title. In that post I mentioned using char(1) is also same like using one bit column in table. But it is from the perspective of storage space. But using numbers is less burden to Database engine. It means using 1 and 0 is better than using ‘Y’ and ‘N’. Also in comparing data ...
