we are able to get a rough view of tables detail in a database like how many rows, total space,
Continue readingAuthor:
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.
Continue readingPython 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
Continue readingPython 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
Continue readingHow 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
Continue readingSQL 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
Continue readingsys.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
Continue readingsys.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
Continue readingsys.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
Continue readingMemory Brokers In SQL Server
Memory Brokers:- Because memory is needed by so many components in SQL Server and to make sure each component uses
Continue reading