In MongoDB course one of my colleague has run a query with two occurrences of same key. Then I thought query will fail on validation. But the way that MongoDB behaves is different on this scenario.> > db.test.insert ({name:1})> db.test.insert ({name:2})> db.test.insert ({name:3})> db.test.insert ({name:4})> > db.test.find({name:1,name:2}){ "_id" : ObjectId("518342a1f193f1de8aef117e"), "name" : 2 }> > db.test.find({name:3,name:1}){ "_id" : ObjectId("5183429ef193f1de8aef117d"), "nam
In MongoDB course one of my colleague has run a query with two occurrences of same key. Then I thought query will fail on validation. But the way that MongoDB behaves is different on this scenario.> > db.test.insert ({name:1})> db.test.insert ({name:2})> db.test.insert ({name:3})> db.test.insert ({name:4})> > db.test.find({name:1,name:2}){ "_id" : ObjectId("518342a1f193f1de8aef117e"), "name" : 2 }> > db.test.find({name:3,name:1}){ "_id" : ObjectId("5183429ef193f1de8aef117d"), "nam
When I was writing previous post, I was thinking about single line statement to disable all the triggers in SQL Server instance. But after that I found a way to how to do this. Those queries may looks like confusing. Below query will print all the names of tables in all the databases of SQL Server instance.EXEC sp_MSforeachdb 'USE [?] ...
When I was writing the previous post, I was thinking about a single line statement to disable all the triggers in SQL Server instance. But after that, I found a way to how to do this. Those queries may look confusing.Below query will print all the names of tables in all the databases of SQL Server instance.EXEC sp_MSforeachdb 'USE [?] ...
When I was writing the previous post, I was thinking about a single line statement to disable all the triggers in SQL Server instance. But after that, I found a way to how to do this. Those queries may look confusing.Below query will print all the names of tables in all the databases of SQL Server instance.EXEC sp_MSforeachdb 'USE [?] ...
In some cases, people need to run some queries against all the databases in their SQL Server instance. Something very very useful for administrators. Let's say somebody wants to give read permission on all tables he can use this sp_MSforeachdb stored procedure.But what I’m going to tell in this post is not about it. I’m going to talk about sp_MSforeachtable. ...
In some cases people need to run some queries against all the databases in their SQL Server instance. Something very very useful for administrators. Lets say somebody want to give read permission on all tables he can use this sp_MSforeachdb stored procedure. But what I’m going to tell in this post is not about it. I’m going to talk about ...
In some cases, people need to run some queries against all the databases in their SQL Server instance. Something very very useful for administrators. Let's say somebody wants to give read permission on all tables he can use this sp_MSforeachdb stored procedure.But what I’m going to tell in this post is not about it. I’m going to talk about sp_MSforeachtable. ...
Hey, Do you like to get to know about Graph Database? Then this is for you. Neo4J is giving a Graph Database Book for free. This is a very good opportunity for people who wants to learn about Graph databases. Please don’t miss this!http://www.neo4j.com/learn/Enjoy your graph database book!!!
Hey, Do you like to get to know about Graph Database? Then this is for you. Neo4J is giving a Graph Database Book for free. This is a very good opportunity for people who wants to learn about Graph databases. Please don’t miss this!http://www.neo4j.com/learn/Enjoy your graph database book!!!
Hey, Do you like to get to know about Graph Database. Then this is for you. Neo4J is giving a Graph Database Book for free. This is a very good opportunity to people who wants to learn about Graph databases. Please don’t miss this! http://www.neo4j.com/learn/ Enjoy your graph database book!!!
I’m using MongoDB for about 6 months. And some guys asked about an IDE. (Basically a GUI tool for MongoDB) At that time there was only one usable GUI Tool. And it is MongoVUE. It is also a painful one. So I gave it up. And now I’m used to MongoDB shell. And I can do everything in MongoDB shell. ...
I’m using MongoDB for about 6 months. And some guys asked about a IDE. (Basically a GUI tool for MongoDB) At that time there was only one usable GUI Tool. And it is MongoVUE. It is also painful one. So I gave it up. And now I’m used to MongoDB shell. And I can do everything in MongoDB shell. But ...
I’m using MongoDB for about 6 months. And some guys asked about an IDE. (Basically a GUI tool for MongoDB) At that time there was only one usable GUI Tool. And it is MongoVUE. It is also a painful one. So I gave it up. And now I’m used to MongoDB shell. And I can do everything in MongoDB shell. ...
I tried to create an Index on View. Then SQL Server said I have to alter that index as a schema-bound view. Then I created a Schema Bound View.USE AdventureWorks2012GOCREATE VIEW [dbo].[vHR] WITH SCHEMABINDING AS SELECT BusinessEntityID AS A, NationalIDNumber AS B, LoginID AS C FROM HumanResources.EmployeeGOThen I created Index on that View.CREATE UNIQUE CLUSTERED INDEX UCI_vHR ON vHR(A,B)GOThen after ...
I tried to create an Index on View. Then SQL Server said I have to alter that index as a schema-bound view. Then I created a Schema Bound View.USE AdventureWorks2012GOCREATE VIEW [dbo].[vHR] WITH SCHEMABINDING AS SELECT BusinessEntityID AS A, NationalIDNumber AS B, LoginID AS C FROM HumanResources.EmployeeGOThen I created Index on that View.CREATE UNIQUE CLUSTERED INDEX UCI_vHR ON vHR(A,B)GOThen after ...
I tried to create a Index on View. Then SQL Server said I have to alter that index as a schema bound view. Then I created Schema Bound View.USE AdventureWorks2012GOCREATE VIEW [dbo].[vHR] WITH SCHEMABINDING AS SELECT BusinessEntityID AS A, NationalIDNumber AS B, LoginID AS C FROM HumanResources.EmployeeGOThen I created Index on that View.CREATE UNIQUE CLUSTERED INDEX UCI_vHR ON vHR(A,B)GOThen after ...
