Archive
Archive for September, 2012
What is NoSQL
September 28, 2012
3 comments
Now a days in IT Industry everyone is talking about NoSQL Databases. And most of them are not aware of what exactly NoSQL is where we can implement it. In this article I’m trying to explain about what is NoSQL Databases and how different they are from Relational Databases. In order to understand NoSQL I’ll put some light on Relational Database Model. Read more…
Categories: Big Data, database systems, no sql, NoSQL, nosql database, sql no, what is no sql, what is nosql
big data, for nosql, no sql, nosql database, what is no sql, what is nosql
SELECT * Vs SELECT Column Name in SQL Server Query
September 2, 2012
4 comments
People always keep saying do not use SELECT * exercise SELECT <column names> instead. But no one put more light on this and this becoming myth in SQL Server and other database management systems. Here are couple of reasons why should we avoid SELECT * and go with SELECT <column names>
Categories: SQL, SQL Server, SQL Server 2008, SQL Server 2008 R2
SELECT *, SELECT * Vs Column Names