SQL Server - IT Tutorial

4 Common Indicators That Signal Database Performance Issues

Kevin Kline — Thu, 30 Jun 2022 10:01:16 +0000

Dealing with database performance issues has to be a priority, regardless of the scope or scale of your server infrastructure. Of course, if you don’t know what to look for, you might not appreciate that performance is suboptimal in the first place. To avoid this scenario persists, here are some thoughts on how your database …

The post 4 Common Indicators That Signal Database Performance Issues first appeared on IT Tutorial.

How to Avoid Activity Monitor Hurting Your SQL Server’s Performance

Kevin Kline — Mon, 22 Nov 2021 12:59:14 +0000

There is no question that monitoring the performance of your SQL Server deployment is an important part of any DBA’s maintenance and troubleshooting responsibilities. However, the integrated tool provided by Microsoft to achieve this, unambiguously known as Activity Monitor, could actually be the culprit in causing performance dips. Here is a look at why this …

The post How to Avoid Activity Monitor Hurting Your SQL Server’s Performance first appeared on IT Tutorial.

Random value for DATETIME column

M A A Mehedi Hasan — Mon, 30 Aug 2021 18:40:46 +0000

Today, I am going to describe how to generate random value for DATETIME field within a given range. This is very useful specially for generating test data. For this, we will use couple of built-in functions like: DATEDIFF DATEADD RAND ROUND Random DATETIME Value DECLARE @startDate DATETIME -- start date DECLARE @endDate DATETIME -- end …

The post Random value for DATETIME column first appeared on IT Tutorial.

Free Methods to Repair SQL Server Index Corruption

Rajan Singh — Thu, 29 Jul 2021 07:42:32 +0000

This article shares the importance of indexes in a SQL database. Also, it provides a brief overview of the clustered and nonclustered indexes. Further, the article discusses reasons for SQL Server index corruption, factors to identify any corrupted index, and methods to fix it. Indexes in SQL Server help speed up the process of retrieving …

The post Free Methods to Repair SQL Server Index Corruption first appeared on IT Tutorial.

Fill In Missing Dates for SQL Server Query Output using CTE

M A A Mehedi Hasan — Thu, 24 Jun 2021 20:38:33 +0000

Last week one of my colleagues requested me to help him write a query to fill in missing dates in query output. I came across couple of solutions, neither seemed convenient to me. So, I compiled my own using recursive CTE or Common Table Expression. Problem Statement Let’s say we have a table which contains …

The post Fill In Missing Dates for SQL Server Query Output using CTE first appeared on IT Tutorial.

Cannot shrink ‘read only’ database | Shrink Transaction Log While Using AlwaysOn Availability Group

Mehmet Salih Deveci — Thu, 25 Feb 2021 11:55:24 +0000

I got ” Cannot shrink ‘read only’ database ” error during Shrink Transaction Log While Using AlwaysOn Availability Group. Shrink Transaction Log While Using AlwaysOn Availability Group Transaction log of SQL Server size was very big, I need to shrink it to decrease its size. But My database is using AlwaysOn Availability Group, so …

The post Cannot shrink ‘read only’ database | Shrink Transaction Log While Using AlwaysOn Availability Group first appeared on IT Tutorial.

Azure SQL Database administration Tips and Hints Exam (DP-300)

Mustafa Emasry — Sat, 31 Oct 2020 22:16:31 +0000

Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many courses, videos, and articles, and this post of today is for spreading what I have from the knowledge and what I learned during the journey, and I do two things during my study …

The post Azure SQL Database administration Tips and Hints Exam (DP-300) first appeared on IT Tutorial.

JSON in SQL Server

M A A Mehedi Hasan — Sun, 25 Oct 2020 20:18:00 +0000

JSON (JavaScript Object Notation) is very popular standard for exchanging data specially in REST API. Almost all modern websites, android or iOS app use this for exchanging data with server. From SQL Server 2016, Microsoft extends its support for JSON through couple of built-in functions. This way SQL Server supports NOSQL features in traditional relational …

The post JSON in SQL Server first appeared on IT Tutorial.

SQL CASE Statement

M A A Mehedi Hasan — Fri, 23 Oct 2020 19:03:23 +0000

SQL CASE statement is very powerful and versatile. It can be used in SELECT, UPDATE and INSERT statement. Even it can be used in ORDER BY and GROUP BY clause. Let’s examine them one by one. Syntax First check out the syntax of CASE statement: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... WHEN conditionN THEN resultN ELSE result END; Data Preparation First …

The post SQL CASE Statement first appeared on IT Tutorial.

Software Review – Stellar Repair for MS SQL

Priyanka Chauhan — Tue, 13 Oct 2020 11:01:48 +0000

I am going to share my experience about how I was able to recover my SQL database from SUSPECT mode. Problem at hand About a week ago, I was inserting some entries in the SQL database. However, the process was halted due to power failure and returned with the SQL server database in SUSPECT mode. …

The post Software Review – Stellar Repair for MS SQL first appeared on IT Tutorial.