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...
Category: Others
117 articles
How to modify SQL Server Analysis Services Modes
SQL Server Analysis Services can be installed in one of three modes. Tabular Multidimensional SharePoint How to check the current...
How to configure a static port for SQL Server?
One of the first things to do for securing your SQL Server is to change its default TCP port. You...
SQL Server 2022 STRING_SPLIT Function
SQL Server 2022 STRING_SPLIT Function – This function allows you to split a string by a delimiter and return a...
Understand SQL WHILE loop with examples
This tutorial will explain what a while loop is in SQL. It will also explain how to use the SQL...
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...
Script SQL Database Permissions for database refresh
Do you restore SQL databases across SQL instances? The Database administrators get frequent requests to refresh the staging or development...
T-SQL script to Measure Transactions Per Seconds in SQL Server
Learn how to measure transactions per second in SQL Server with this quick and easy guide. We’ll show you step-by-step...
Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
SQL Server UPDATE STATISTICS WITH FULLSCAN is a process that is used to update statistics in SQL Server. This article...
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-AM/PM. The...