SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information
Callum Today’s post describes SQL queries to get the following information about the processors of a...
Others
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 configure a static port for SQL Server?
One of the first things to do for securing your SQL Server is to change...
SQL Server 2022 STRING_SPLIT Function
SQL Server 2022 STRING_SPLIT Function – This function allows you to split a string by...
Understand SQL WHILE loop with examples
This tutorial will explain what a while loop is in SQL. It will also explain...
How to Change Always On availability group mode
This topic describes how to change the availability mode of an availability replica in an...
Script SQL Database Permissions for database refresh
Do you restore SQL databases across SQL instances? The Database administrators get frequent requests to...
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...
Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
SQL Server UPDATE STATISTICS WITH FULLSCAN is a process that is used to update statistics...
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...