Sibeesh Passion

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 for Polybase” failed. You may get this error when you try to install SQL Server. I wast trying to install SQL Server 2016 Release Candidate 1, and I got […]

Read More

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 result will give you all the insert query with other queries so that the data also will get inserted in your new database. We are going to use the […]

Read More

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 Microsoft SQL server. The error message will be “Saving changes is not permitted,The changes you have made require the following table to be dropped and re-created. You have either […]

Read More

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 Injections are hijacks. But still if you pass those parameters in the right way, you will face lots of problems. In this article I am going to share you […]

Read More

Find Out the Missing Indexes in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         This code helps you to find out the missing Indexes in SQL

Read More

Find the Relationship Difference Between Two DB

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Find the relationship difference between two DB.

Read More

Find Relationships Between Tables in SQL Server 2008

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         find the relationships between tables in SQL Server 2008

Read More

Creating Linked Server in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Creating Linked Server: Here you need to replace with your server name.

Read More

Find Which Are All Table has Set Identity

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Find which are all table has set identity.

Read More

Get the Count of Entries in Each Table in a DB in SQL

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

         Hi All, This code will helps you to get the count of entries in each table in a DB in SQL: OR [/sql] SELECT sum(sysindexes.Rows),GETDATE() FROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.id WHERE type = ‘U’ AND sysindexes.IndId < 2 [/sql] Kindest Regards

Read More
Footer With Address And Phones