Category Archives: SQL SERVER

No Thumbnail

SQL SERVER – How to Fix Error : ‘System.OutOfMemoryException’ was thrown. (mscorlib) while executing script

In this article, we will learn how to solve System.OutOfMemoryException error while executing scripts in SQL Server Management Studio. Issue : It is ok to execute average size of the script using SQL Server Management Studio but If you want to execute a large SQL

SQL SERVER – How to Fix Error : Database diagram support objects cannot be installed

What is a Database Diagram Support in SQL SERVER SQL Server management studio(Any versions) allows you to create Database Diagrams to use graphically and show the complete structure of the database. Additionally, you can create and modify tables, columns, relationships, Indexes and constraints there. Error: Database

SQL Server Interview Questions and Answers Day – 3

Before going through SQL Server Interview Questions and Answers Day – 3,  I would like to recommend you to go through previous article : SQL Server Interview Questions and Answers Day – 1 SQL Server Interview Question and Answers Day -2 What is View ?

SQL Server Interview Questions and Answers Day -2

Before going through SQL Server Interview Questions and Answers Day – 2,  I would like to recommend you to go through previous article : SQL Server Interview Questions and Answers Day – 1 What is SQL command? SQL are a set of instructions which is

SQL Server Interview Questions and Answers Day 1

Day 1 – SQL Server Interview Questions and Answers What is SQL? SQL is the internationally recognized standard language for dealing with data in relational database. SQL is a language specifically and solely designed to create, operate on, and manage relational database. SQL isn’t a