SQL Server
Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed
In this article we will are going to see how we can fix the error Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required ...TagIt Control With Data From Database Using Angular JS In MVC Web API
In this article we will learn how to load the tags from database in MVC Web API using Angular JS. Here we are going to use ...Generate Database Scripts With Data In SQL Server
In this post we will discuss about how we can generate SQL Server scripts of our database with existing data, once we generate the script, the ...Export MDX Result As Excel
In this post we will see how we can export mdx query result. Here we are going to use MVC with the help of jQuery Ajax. ...SQL Interview Questions And Answers
In this article we will discuss about the most asked SQL interview questions and answers. If you need to know other interview questions and answers, I ...Solution for saving changes not permitted error in SQL
Introduction Hi All, How are you today? In this article we will see a solution for a fix that we usually encounter when you work in ...SqlDateTime Overflow, Must be between Error
Introduction Hi All, I hope you are fine. We all are using SQL parameter in our application right?Yeah it is a good way to restrict the ...Find Out the Missing Indexes in SQL
This code helps you to find out the missing Indexes in SQL SELECT d.[object_id], s = OBJECT_SCHEMA_NAME(d.[object_id]), o = OBJECT_NAME(d.[object_id]), d.equality_columns, d.inequality_columns, d.included_columns, s.unique_compiles, s.user_seeks, s.last_user_seek, ...Find the Relationship Difference Between Two DB
Find the relationship difference between two DB. SELECT f.name AS ForeignKey FROM sys.foreign_keys AS f where f.name not in (SELECT f.name AS ForeignKey FROM inova.sys.foreign_keys AS ...Find Relationships Between Tables in SQL Server 2008
find the relationships between tables in SQL Server 2008 SELECT f.name AS ForeignKey, SCHEMA_NAME(f.SCHEMA_ID) SchemaName, OBJECT_NAME(f.parent_object_id) AS TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName, SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName, OBJECT_NAME (f.referenced_object_id) AS ...
