Results for "Index"
9 / 184 posts
What is an Index? Explain its different types in SQL
✅ Index in SQL Server (इंडेक्स इन SQL सर्वर): Index SQL Server में एक database object (डेटाबेस ऑब्जेक्ट) है जो टेबल के डेटा को जल्दी से प्राप्त करने के लिए…
Order by index number in SQL
SELECT empid, lastname FROM HR.Employees ORDER BY 1 DESC --order by first column SELECT empid, lastname FROM HR.Employees ORDER BY 2 DESC --order by second…
Split full name into first name and last name in SQL
Split full name into first name and last name : SELECT EmployeeName, CASE WHEN CHARINDEX(' ', EmployeeName) > 0 -- Check if there is a space (indicating…
Index Rebuilding vs. Reorganization in SQL Server
As a database grows, maintaining optimal performance becomes crucial. One of the key contributors to performance degradation over time is index fragmentati…
SQL Interview Q&A
Here are the questions along with their corresponding answers extracted from the provided context: What is SQL? SQL stands for Structured Query Language. I…
SQL Server Optimization Q&A
1. What is SQL Server Optimization? Answer: SQL Server Optimization ka matlab hota hai database ka performance better banana — jaise queries fast chalna, k…
select() Function in PySpark
In PySpark, select() function is used to select single, multiple, column by index, all columns from the list and the nested columns from a DataFrame, PySpa…
Dynamic CREATE TABLE Script in SQL Server
DECLARE @TableName NVARCHAR(100) = 'Employee'; DECLARE @SQL NVARCHAR(MAX) = ''; DECLARE @PKCols NVARCHAR(MAX) = ''; -- Get Primary Key Column(s) SELECT @PK…
Indexes in Data Warehouse
Database Me Data Kaise Store Hota Hai? Table ke rows disk par randomly store hote hain. Example: Row Customer_ID Sales 1 8 100 2 5 200 3 4 300 4 8 150 Agar…