Skip to content

Kloudspro

  • Quick Links
    • Microsoft Certifications
    • Azure Portal
    • Azure Data Factory
    • Power BI Service
    • Azure Data Centers
    • Azure Pricing Calculator
    • Microsoft Bug Bounty Program
  • Downloads
    • Azure IP Ranges
    • Azure Storage Explorer
    • SQL Server Management Studio (SSMS)
    • Power BI
      • Power BI Desktop
      • Tabular Editor 2.16.5
  • Azure Health Check
    • Azure Status
    • DevOps Status
    • Service Health
  • Contact

Category: SQL Scripts

Extracting zip code from an open text address field using T-SQL

May 14, 2022 Kloudspro

Sometime we come across a situation where we need the ZIP code of an address but the raw data from operational systems is coming as

Continue reading

SQL Script to Check Partition Information in a SQL Server Database

September 8, 2021 Kloudspro

Few months ago, we talked about how to partition a table in SQL Server database. Let us now look at a script that you can

Continue reading

SQL Script to Check Tables Defined With All Columns as NULL

August 4, 2021 Kloudspro

Off late, I was asked to do a quick review of a database and it was one of the things that I always look for….generally,

Continue reading

SQL Script to Check Unused or Bad Indexes

July 10, 2021 Kloudspro

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

SQL Script to Check Index Fragmentation

July 8, 2021 Kloudspro

This may take some time to get executed if tables are heavy in the database sys.indexes, sys.objects and sys.dm_db_index_physical_stats() Mode can be “Sampled”, “Limited” or

Continue reading

SQL Script to Check Row Count of Each Table

June 29, 2021 Kloudspro

Need to check row count of each table in the database in an efficient manner? Here is the query that you can simply copy and

Continue reading

About the author

Top Posts

  • How to Increment a Variable in ADF (Azure Data Factory)
  • Handling Stored Procedure Output Parameters in ADF
  • Power BI: Use COUNTROWS instead of COUNT
  • A Practical Guide to Table Partitioning in Azure SQL Database
  • Did You Know...TempDB Size in Azure Synapse Dedicated SQL Pool (SQL DWH)

Recent Posts

  • Extracting zip code from an open text address field using T-SQL May 14, 2022
  • Azure Synapse Provisioning Issue in Southeast Asia Region: Not Accepting Creation of New Windows Azure SQL Database Servers at this Time April 27, 2022
  • Did You Know…Tumbling Window in Azure Stream Analytics is Nothing But A Hopping Window February 28, 2022
  • Integrate Tabular Editor (Free Version) in Power BI as External Tools in 2 Minutes December 17, 2021
  • Artificial Intelligence (AI) Features in Power BI November 17, 2021

Archives

  • May 2022 (1)
  • April 2022 (1)
  • February 2022 (1)
  • December 2021 (1)
  • November 2021 (1)
  • October 2021 (1)
  • September 2021 (4)
  • August 2021 (5)
  • July 2021 (10)
  • June 2021 (7)
  • May 2021 (2)
  • April 2021 (1)
  • March 2021 (7)
  • February 2021 (7)
  • January 2021 (6)
  • December 2020 (10)
  • November 2020 (7)
  • October 2020 (15)
  • September 2020 (8)
  • August 2020 (8)
  • July 2020 (3)
  • June 2020 (21)

Subscribe

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

 

Loading Comments...