Skip to content
Register for a course

Techfura

All about Programming and Data Engineering

  • Blog
  • Register

Category: Indexes

SQL Server – Indexes

September 18, 2020May 27, 2024 Kennedy

Why do we need indexing a table? Because without an index the SQL server has to scan the entire table to return the requested data. It is like the index page in a book. You check within the index for the Read More …

Indexes, TSQL

Categories

  • AI/ML (1)
    • RAG (1)
  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (23)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • Data Engineering (2)
    • DE Roadmap (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (2)
    • Basic Linux Commands (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (42)
    • C# (5)
    • C++ (4)
    • Fundamentals (1)
    • HTML/CSS (3)
    • JavaScript (6)
    • Python (1)
    • Spark (4)
      • Intro to Apache Spark (1)
      • PySpark (1)
      • Spark DataFrame Cheat Sheet (1)
      • SparkSQL (1)
    • TSQL (16)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (4)
  • Reporting (2)
    • SSRS (2)

Archives

  • May 2025 (1)
  • February 2025 (1)
  • September 2024 (2)
  • May 2024 (7)
  • January 2024 (1)
  • June 2023 (2)
  • March 2022 (1)
  • April 2021 (8)
  • March 2021 (3)
  • January 2021 (3)
  • December 2020 (2)
  • October 2020 (1)
  • September 2020 (10)
  • July 2020 (1)
  • June 2020 (6)
  • May 2020 (30)
  • April 2020 (1)
  • April 2019 (1)

Recent Posts

  • Cloud Platforms Comparison Cheat Sheet
  • SQL – CRUD and CT
  • Building a Real-Time Data Pipeline with Python, Docker, Airflow, Spark, Kafka, and Cassandra
  • Mastering Personalized Conversations with RAG
  • Top 10 Core Concepts in every Programming Languages

Tags

ADLA Azure Big Data Cheat Sheet CTE Data Data Engineering Dataframe Data Pipeline Dataset Functions Linux MSSQL Procedures PySpark Python RDD Scala SLQ Delete Duplicates Spark SQL SQL SERVER SSIS SSIS Catalog error SSISDB Stored procedures STUFF() Stuff() Function TSQL U-SQL U-SQL Table UDF USQL U_SQL File Metadata

Traffic Count

traffic counter

Categories

  • AI/ML (1)
    • RAG (1)
  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (23)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • Data Engineering (2)
    • DE Roadmap (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (2)
    • Basic Linux Commands (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (42)
    • C# (5)
    • C++ (4)
    • Fundamentals (1)
    • HTML/CSS (3)
    • JavaScript (6)
    • Python (1)
    • Spark (4)
      • Intro to Apache Spark (1)
      • PySpark (1)
      • Spark DataFrame Cheat Sheet (1)
      • SparkSQL (1)
    • TSQL (16)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (4)
  • Reporting (2)
    • SSRS (2)
© 2024 Techfura.com. All Rights Reserved