SQL Server - Where do my SQL Database files reside?
SQL Server - Where do my SQL Database files reside?
top of page
-
- May 5, 2022
- 1 min
T-SQL script to configure SQL Database for optimal VLF distribution
T-SQL script to configure SQL Database for optimal VLF distribution
164 views0 comments
-
- Mar 31, 2022
- 1 min
Query to list SQL Server indexes in a specific database
Sometimes you need to know the list of SQL Server indexes available in the SQL database. There are many ways to get the list of indexes....
242 views0 comments
-
- Feb 1, 2022
- 1 min
Space used by Individual tables in SQL Server
Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here.
254 views0 comments
-
- Feb 1, 2022
- 2 min
SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests
Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
279 views0 comments
-
- Jan 28, 2022
- 1 min
Get SQL Server Configuration using T-SQL
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
107 views0 comments
-
- Jan 28, 2022
- 1 min
SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information
Today's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph
233 views0 comments
-
- Jan 28, 2022
- 1 min
SQL Server - How to comma-separated values into different columns
This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query.
1,865 views0 comments
-
- Jan 28, 2022
- 1 min
T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password
Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
183 views0 comments
-
- Jan 28, 2022
- 1 min
SQL Server agent jobs without notification using T-SQL
This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
183 views0 comments
-
- Jan 27, 2022
- 1 min
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
233 views0 comments
-
- Jan 25, 2022
- 1 min
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being run. This blog shows how to u
447 views0 comments
-
- Jan 25, 2022
- 2 min
Identify When your SQL Database Was Last Used - SQL Server
I've seen several questions on the forums asking how to find out whether the SQL database is in use or not? Let's answer in this article.
2,932 views4 comments
-
- Jan 19, 2022
- 1 min
T-SQL Query to find Supported Compatibility Level Values in SQL Server
The question came up on the forum - how do I find all the possible values for a specific compatibility_level in SQL Server? Let's check .
108 views0 comments
-
- Jan 19, 2022
- 1 min
T-SQL Query to find Orphan data and log files of SQL Databases
Are you a DBA? Then you'll love this free T-SQL script. This script helps you find orphaned data and log files of SQL Databases.
314 views0 comments
-
- Jan 19, 2022
- 1 min
T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
292 views0 comments
-
- Jan 19, 2022
- 1 min
Export Windows applications logs in CSV format using SQL Server query
The Windows application logs are used by various applications to write new events. This blog exporting these logs into CSV format
48 views0 comments
-
- Jan 18, 2022
- 1 min
How to Change Always On availability group mode
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
304 views0 comments
-
- Jan 13, 2022
- 1 min
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
471 views0 comments
-
- Jan 11, 2022
- 1 min
PowerShell Script to restart SQL Services
Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
333 views0 comments
bottom of page