NTSEQ:- A IT Infrastructure and Cyber Security Blogs

SQL SERVER – Get Size of All Tables In Database

we are able to get a rough view of tables detail in a database like how many rows, total space,

PHP program to find the Standard Deviation of an array

To write a program to find Standard Deviation of an array we are going to use below PHP inbuilt functions.

Python for Loop And While Loop

Loops in Python:- The Python programming language provides the following types of loops to handle looping requirements. Python offers three

Python Program to Convert Decimal to Binary

In this program, we have defined a function for conversion to be named DecimalToBinary (). This function takes the decimal

How to Rename Column Name And Table Name In SQL Server

In this article we are going to show you,How to Rename Table Name and Column Name in SQL Server with

SQL SERVER – Find Most Expensive Queries Using DMV

The following query returns the top 10 queries by total CPU time, to help you identify the most expensive queries

sys.dm_exec_query_stats In SQL Server

Just as the text returned from the sql_handle is the text for the entire batch, the compiled plans that are

sys.dm_exec_requests In SQL Server

sys.dm_exec_requests:- The sys.dm_exec_requests view returns one row for every currently executing request within your SQL Server instance and is useful

sys.dm_exec_sql_text In SQL Server

Function sys.dm_exec_sql_text can take a sql_handle or a plan_handle as a parameter, And it returns the SQL text that matches

Memory Brokers In SQL Server

Memory Brokers:- Because memory is needed by so many components in SQL Server and to make sure each component uses