Your Technical Consultant
Storing and retrieving data as requested by other software applications, either on the same computer or a remote machine, utilizing the client-server model.
Hello Everybody! In this article, we want to discuss how to update a table from another table in SQL Server. Before we get started, if you want to know about format DateTime, please go through the following article: How to […]
Continue reading How to Update a Table from Another Table in SQL Server (With Examples)
Primary key and Unique key are two important concept in relational database, and used to uniquely identify a row in a table. Both primary key and unique key can identify a row uniquely but there are some subtle difference between them which we will see in this article. In fact primary key vs unique is a popular SQL interview questions along with classics like truncate vs delete and How to manage transaction in database, mostly asked to fresher and 2 to 3 years experience guys in any programming language. SQL is not just limited to any DBA or PLSQL developer but its an important skill even for Java programmer and you can expect SQL interview question even in many Java interviews. Some time programmer also confuse between foreign key and unique key, which is primary key of other table in relation.
Continue reading What is difference between Primary Key and Unique Key
I encountered the situation recently where I needed to find the size of the log file, file location. Here is the script, if you remove the WHERE condition you will find the result for all the databases.
Continue reading Check Database Physical File Paths and Sizes in SQL Server – DBA Guide
The SIMPLE recovery model is the simplest among the available models. It supports full, differential, and file-level backups. Transaction log backups are not supported. The log space is reused whenever the SQL Server background process checkpoint operation occurs. The inactive […]
Continue reading How to Enable Simple Recovery Model at SQL Server
Query will return all the tables which has identity column. It will also return the Seed Values, Increment Values and Current Identity Column value of all the tables of a database.
Continue reading Query to find SQL Server IDENTITY related values of all the tables
In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target based on the results of that join
Continue reading Create MERGE statement with variable in SQL Server
In this post, we want to share 6 Useful SQL Server Data Dictionary Queries Every DBA Should Have. Before we get started, if you face problem to activate Microsoft Visual Studio for Product Key, please go through the following article: […]
Continue reading 12 Useful SQL Server Data Dictionary Queries Every DBA Should Have
In this tutorial, we discuss how to easily calculate a running total in SQL Server 2012 or above. Our goal is to calculate the running total that resets whenever the Transaction Date changes. We’ll total the transaction amount. For each […]
In this article, we will discuss the Top 50 SQL Server Interview Questions & Answers that you may be asked during a SQL Server administrator or developer technical job interview. Before we get started, if you want to know about […]
Continue reading SQL Server Interview Questions: Expert Insights & Must-Know Answers
In this post, we want to discuss four examples of PIVOT and UNPIVOT in SQL Server. Before we get started, if you face a large-sized SQL Log file and want to reduce it as soon as possible, please go through […]
Continue reading Master PIVOT and UNPIVOT in SQL Server : Transform Your Data Like a Pro
