Skip to content

Kloudspro

  • Home
  • Quick Links
    • Microsoft Certifications
    • Azure Portal
    • Azure Data Factory
    • Power BI Service
    • Azure Data Centers
    • Azure Pricing Calculator
    • Azure Database Migration Guide
    • Microsoft Bug Bounty Program
    • Databricks Community Edition

Tag: SQL Scripts

Script to Check Size of Each Table

November 9, 2020 Parry M.

If you want to get the size of each table in each database on the instance, run the following script – Below part of the

Continue reading

Script to Check SQL Server Database Connections

September 13, 2020 Parry M.

More significant for Azure SQL Database to determine who all are connected from which IP address and how many connections sys.dm_exec_sessions and sys.dm_exec_connections

Continue reading

SQL Script to Check Most Time Taking Queries at Instance Level

September 13, 2020 Parry M.

This is similar to what we saw in SQL Script to Check Most Executed Queries in a SQL Server Database post with the difference that

Continue reading

SQL Script to Check Most Executed Queries in a SQL Server Database

September 13, 2020 Parry M.

sys.dm_exec_query_stats sys.dm_exec_sql_text to fetch the exact query sys.dm_exec_query_plan to fetch the query plan And again Thanks to Glenn Berry for sharing the script.

Continue reading

Script to Check Unused or Possibly Bad NonClustered Indexes in SQL Server Database

September 13, 2020 Parry M.

sys.indexes, sys.objects and sys.dm_db_index_usage_stats Checks where writes are greater than the reads i.e. index maintenance is higher than the benefit it is serving during read

Continue reading

Script to Check Row Count for All Tables in SQL Server

September 13, 2020 Parry M.

sys.partitions and sys.objects Consider ONLY Heap or Clustered Index that gives you the count Thanks to Glenn Berry for sharing the script.

Continue reading

Script to Check Statistics Updated Last Time in SQL Server

September 13, 2020 Parry M.

When was the last time statstics were updated for a particular index You can filter it as per you needs to run it faster or

Continue reading

Script to Check Index Fragmentation in SQL Server

September 13, 2020 Parry M.

This may take some time to get executed if the database size is large You may filter it for some specific cases to run it

Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Search what you are looking for

Read this blog in your own language

Advertisements
  • Home
  • Quick Links
Create a website or blog at WordPress.com