Results for "drop"

6 / 60 posts

Search: drop

Filter by Category

SQL

SQL Server Index Optimization Automation (Missing & Unused Index Management)

Pehle Basics — Index Hota Kya Hai? Simple bhaasha mein — index ek kitaab ka index page hota hai. Jaise tum dictionary mein "Zebra" dhundne ke liye seedha Z s...

SQL Server Index Optimization Database Performance
Match in contentMatch in code
Mar 24, 2026 17 min read
PySpark

drop(), dropDuplicates(), and distinct() in PySpark

🔹 1. drop() – Removing Columns The drop() function is used to remove one or more columns from a DataFrame. 👉 Example: Removing a Single Column from pyspa…

distinct drop dropDuplicates
Match in titleMatch in tagsMatch in content
Mar 19, 2026 2 min read
Pandas

Pandas for Python Developers: The Complete Guide (Part 1 — Fundamentals)

Meta Description: Master Pandas from scratch. Learn Series, DataFrames, I/O operations, and essential data manipulation with real-world examples. The only gu...

pandas python data science
Match in contentMatch in code
Apr 15, 2026 21 min read
SQL

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 Linked Server Stored Procedure
Match in contentMatch in code
Mar 30, 2026 9 min read
SQL

How to Drop All Non-Clustered Indexes Dynamically in SQL Server

Database optimization aur maintenance ke time kabhi-kabhi hume sabhi Non-Clustered Indexes temporarily remove karne padte hain — especially jab: bulk data lo...

Non-Clustered Indexes Drop index
Match in titleMatch in tagsMatch in content
May 11, 2026 4 min read
Pandas

Advanced Pandas: Performance, Time Series, ML Pipelines & Interview Questions (Part 3)

Master advanced Pandas — MultiIndex, time series resampling, rolling windows, memory optimization, Pandas 2.x features, ML pipelines, and 30+ interview Q&A.

pandas advanced pandas time series pandas performance
Match in contentMatch in code
Apr 15, 2026 27 min read