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
Category: SQL Scripts
SQL Script to Check Partition Information in a SQL Server Database
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
SQL Script to Check Tables Defined With All Columns as NULL
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,
SQL Script to Check Unused or Bad Indexes
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
SQL Script to Check Index Fragmentation
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
SQL Script to Check Row Count of Each Table
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