Posts

How to make T-SQL code readable format with one single click

Image
Benefits of Code Formatting: ✓ Easy to read, understand, modify and maintain. ✓ Everyone can read each other’s code ✓ Safely rename SQL Objects. Step by Step Guide:  To enhance code readability and maintain consistency, consider installing the following SSMS plugins. Download link for SQL formatter: You can design a custom template tailored to your organization's needs. https://www.apexsql.com/sql-tools-refactor/ References: https://www.apexsql.com/sql-tools-search.aspx          https://blog.apexsql.com/category/apexsql-refactor Author: Naresh Cherukuri
Post a Comment
Read more

Improve the SQL Server Database Size Achievement

Image
Size of the [ TRANSACTION]  database before deleting the records from the  ETL.ETL_Job_Log  table: Database Name :  [ TRANSACTION]   Table Name :    ETL.ETL_Job_Log Daily SSIS (ETL) Package and task logs are stored in the ETL.ETL_Job_Log table.   BEFORE : After deleting log records older than one year, the free space increased from 50 GB to 134 GB. Finally, after clearing out the ETL Log tables: AFTER:   A faster way to delete rows from the big table: Create a view on the [ETL].[ETL_Job_Log] table. CREATE VIEW [ETL].[ETL_job_log_id_ToBeDeleted] AS     SELECT TOP 5000000 *     FROM [ETL].[ETL_job_log]     WHERE StartDT < DATEADD ( year , -1, GETDATE ())     ORDER BY StartDT; Create an index on the StartDT table for better performance, as we are using this column for ordering. CREATE NONCLUSTERED INDEX [IX_StartDT] ON [ETL].[ETL_job_log] ([StartDT] ASC ) WITH ( PAD_INDEX = OFF , STATISTICS_NOR...
Post a Comment
Location: United Kingdom
Read more