Results for "trim"
6 / 12 posts
Filter by Category
SQL Server Data Archiving System
Introduction As databases grow, performance starts degrading. Queries become slow, indexes become heavy, and maintenance becomes difficult. This is where dat...
Dynamic Linked Server Management in SQL Server
Introduction In SQL Server, sometimes we need to connect with another database server. This is done using a Linked Server . But manually creating and deletin...
SQL Server index Creation by using table
Database performance improve karne ke liye indexes bahut important hote hain. Lekin large ERP ya payroll systems me manually indexes manage karna difficult h...
SQL Server Deadlock & Performance Monitoring Made Easy
Introduction In SQL Server, performance issues are very common. Sometimes queries run slow, sometimes users get stuck, and sometimes the system becomes unres...
SQL Server Database Shrink Maintenance
Database shrink ka matlab hai database file (ya log file) ke size ko chhota karna by removing unused space . Matlab, agar tumhare DB me data delete ho gaya h...
PySpark Built-in Functions
These functions are commonly used with groupBy() , agg() , or select() to compute things like sum, average, max, min, count, etc. PySpark functions come fr…