How To View Database Diagram In SQL Server

How To View Database Diagram In SQL Server

Viewing database diagrams in SQL Server is essential. In this article, I will walk you through all the approaches to do this. How To View Database Diagram In SQL Server Let us discuss all the approaches individually. Approach-1: Using SQL Server Management Studio (SSMS) To view database diagram in SQL server, follow the below steps. … Read more >>

How To Find Database Name In SQL Server

How To Find Database Name In SQL Server

Finding database name in SQL servers is a daily task for an SQL developer. In this article, I will guide you through multiple ways to find a database name in SQL server with some real-time examples. How To Find Database Name In SQL Server Let us discuss all those approaches individually. Approach-1: Using sys.databases To … Read more >>

How To Enable Filestream In SQL Server

How To Enable Filestream In SQL Server

Recently, I got a requirement to enable the file stream for my SQL server. I have analyzed and identified the approaches mentioned in this article. In this article, I will walk you through all those approaches individually. How To Enable Filestream In SQL Server Let us discuss each approach individually. Approach-1: Using SQL Server Management … Read more >>

How To Check DB Size In SQL Server

How To Check DB Size In SQL Server

Recently, I got the requirement to check the size of my SQL server database. I have identified a few simple and quick approaches to achieve that. In this article, I will guide you through all those approaches to check the size of the DB in an SQL server. How To Check DB Size In SQL … Read more >>

How to Find Stored Procedure in SQL Server

Could not find stored procedure in sql server

As a database developer, I reviewed many tables in my organization with stored procedures, views, etc. Sometimes, finding the exact name of the stored procedure I want to work with is difficult. It will throw a message like Could not find stored procedure in SQL Server even though I’m sure it is available. In this SQL Server tutorial, … Read more >>

How to Use EQUI JOIN in SQL Server

How to use EQUI JOIN in SQL Server

While working with relational databases, I was required to combine rows with multiple tables based on related columns. I will use the commonly used EQUI JOIN in SQL Server for that. An EQUI JOIN is a specific type of INNER JOIN that links tables based on an equality condition between two columns. In this post, … Read more >>

How to Use Select Statement Without Join

Sql server select a join without join sample example

I am currently working on the Employee Leave Management System in SQL Server. I have a requirement to use the SELECT statement without the JOIN clause to retrieve records from two tables by query. This tutorial will teach how to use SQL Server SELECT statements without using the JOIN clause on the query’s table. SQL Server Select a Join … Read more >>

What is SELF JOIN in SQL Server?

Sql server self join image

While I am working on the table, I need to compare the rows inside the same table. In these cases, SQL Server’s SELF JOIN will be helpful. I used SELF JOIN to compare the data to the one where I got the exact output that I wanted. In this post, I will explain a self-join, … Read more >>

How to Export Data from SQL Server to Excel

Import to Excel Choose Destination

As a developer, exporting data from SQL Server is a common task. In the organization, I also need to keep the data in Excel for my reference. I tried exporting, but I faced some difficulties. Later, I found a method to export data from SQL Server to Excel. Instead of manually entering every data set … Read more >>

How to View SQL Server Error Logs

View SQL Server error logs

As a developer, working with SQL Server debugging can be quite challenging. Monitoring and troubleshooting are important for maintaining a proper database environment. One of the main features is the SQL Server Error Log, which records basic things like startup and shutdown processes, errors, and warnings. How to View SQL Server Error Logs In this … Read more >>

Top 200 SQL Server Interview Questions and Answers

Free PDF On Top 200 SQL Server Interview Questions And Answers

Download A 40 pages PDF And Learn Now.