rajendra guptaMay 51 minT-SQL script to configure SQL Database for optimal VLF distributionT-SQL script to configure SQL Database for optimal VLF distribution
rajendra guptaMar 311 minQuery to list SQL Server indexes in a specific databaseSometimes 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....
rajendra guptaFeb 11 minSpace used by Individual tables in SQL ServerLearn how to manage SQL Server space used by individual tables with this tutorial. Read more here.
rajendra guptaFeb 12 minSQL Server Dynamic Management View(DMV)- sys.dm_exec_requestsExecute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
rajendra guptaJan 281 minGet 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
rajendra guptaJan 281 minSQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type informationToday's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph
rajendra guptaJan 281 minSQL 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.
rajendra guptaJan 281 minT-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption passwordLearn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
rajendra guptaJan 281 minSQL Server agent jobs without notification using T-SQLThis article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
rajendra guptaJan 271 minDisplay dates between two input dates using SQL DATEDIFF function in SQL ServerSQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
rajendra guptaJan 251 minT-SQL query to change the job owners for all jobs owned by a specific loginMany 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
rajendra guptaJan 242 minIdentify When your SQL Database Was Last Used - SQL ServerI'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.
rajendra guptaJan 191 minT-SQL Query to find Supported Compatibility Level Values in SQL ServerThe 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 .
rajendra guptaJan 191 minT-SQL Query to find Orphan data and log files of SQL DatabasesAre 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.
rajendra guptaJan 181 minT-SQL script to Backup database SQL Server with TimeStampThe 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-...
rajendra guptaJan 181 minExport Windows applications logs in CSV format using SQL Server queryThe Windows application logs are used by various applications to write new events. This blog exporting these logs into CSV format
rajendra guptaJan 171 minHow 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
rajendra guptaJan 121 minT-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)
rajendra guptaJan 111 minPowerShell Script to restart SQL ServicesLearn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
rajendra guptaJan 101 minEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server databaseEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server database