#sqlfragmentation 検索結果

Recalling a past blog post stating that SQL is not a language for performing analysis, it initially seemed insane since SQL is very flexible. However, with more use cases involving analysis and exploration through visualization, SQL is becoming increasingly irrelevant for…

SPL outshines SQL in data analysis: handles file data directly, simplifies complex logic with block-like coding, offers robust debugging, and excels at tasks like stock analysis/funnel analysis—fixing SQL’s pain points. medium.com/p/this-is-prob…

It's horizontal partitioning but the state of individual database instances is independent of each other. Its coordinated by a proxy. Say, your proxy that manages the shards commits to three of the database instances and two succeed but one fails. This becomes a consistency…

SQL is just: - Data Storage (Tables, Schemas, Databases) - Data Cleaning (TRIM, REPLACE, CAST, COALESCE) - Data Retrieval (SELECT, WHERE, ORDER BY, LIMIT) - Data Analysis (GROUP BY, HAVING, JOINS, SUBQUERIES) - Data Automation (Views, Stored Procedures, Triggers) That’s it

Sharding vs. Partitioning - What's the Difference? 🔹 Partitioning - Divides a large table into smaller chunks (called partitions) - Happens within a single database server - Improves performance and simplifies maintenance Example: Partitioning logs table by month within one…

✂️Chunking Data for RAG Applications Learn about how to transform your data for retrieval-augmented generation (RAG) applications using different chunking strategies. Covers: recursive splitting, document-specific splitting, and semantic splitting learn.mongodb.com/courses/chunki…

If you are working with databases, one must-know concept is ACID. ACID in databases stands for Atomicity, Consistency, Isolation, and Durability. Here’s what each term means: ✅ Atomicity (A) Atomic means something that cannot be broken down. It’s the same thing that our…

𝗛𝗼𝘄 𝗧𝗼 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲 𝗬𝗼𝘂𝗿 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝗶𝗲𝘀? To do this, you need first to understand the execution order of an SQL query. SQL statements are executed in multiple steps: 𝟭. 𝗙𝗥𝗢𝗠 - tables are joined to get the base data. 𝟮. 𝗪𝗛𝗘𝗥𝗘 - the base data is…

Day 4 of #SQL INTERVIEW series: Here’s another most frequently asked question in #interviews ⭕️What is the order of execution of a sql query? In SQL, the execution sequence of a query typically follows these steps: 1. FROM : Determines the source tables. 2. JOIN : Joins are…

Here are some Advanced #SQL Queries you should know for #DataAnalytics 1. Window Functions 2. Common Table Expressions (CTEs) 3. Recursive CTEs 4. PIVOT Queries 5. Dynamic SQL 6. MERGE Statement Learn how to implement all these queries: bit.ly/advanced-sql-q…

✂️Basics of chunking & splitting To create better RAG applications, you need to know how to split/chunk the documents so you preserve the content while asking questions This may not be as easy as you think! Great community video going over the basics: youtube.com/watch?v=tMwdl9…

ACID in Databases stands for Atomicity, Consistency, Isolation, and Durability. ✅ Atomicity (A) Atomic means something that cannot be broken down. Atomicity describes what happens to a Transaction that’s executing multiple write operations and something goes wrong halfway.…

Distributed SQL is not the same as regular SQL! These keywords cause shuffling in distributed environments: - GROUP BY - JOIN - ORDER BY - PARTITION BY These keywords behave mostly the same everywhere: - WHERE - HAVING - FROM - SELECT You’ll notice the word “BY”…

Dive into the inner workings of SQL queries in our latest video. Explore how query execution plans can improve database performance and learn more about the execution order of SQL operators. Watch here: youtu.be/BHwzDmr6d7s

Fragmented indexes waste disk space, memory, increase backup size, and slow down index access times. Analyze SQL Server fragmentation with Database Health Monitor. #SQLserver #SQLfragmentation #SQLmonitor #StedmanSolutions databasehealth.com/database-overv…

SQL is a query language used to interact with the database. All the SQL queries can be divided into 4 Commands: 1) DDL ( Data Definition Language ) 2) DQL ( Data Query Language ) 3) DML ( Data Modification Language ) 4) DCL ( Data Control Language )

SQL Queries I use daily as a Data Analyst: 🐷 Count per Category 🐷 Distinct Values 🐷 Selection by date component 🐷 Cumulative total 🐷 Joining tables 🐷 Pattern matching 🐷 Updating values Reply below with yours!🐷

Analyze SQL Server fragmentation with Database Health Monitor. databasehealth.com/database-overv… #SQLfragmentation #SQLserver #databasehealthmonitor #stedmansolutions

Earlier this year, we split our single backend database into 480 shards — but 5 minutes of maintenance was just the tip of the iceberg! Our team spent months architecting this migration to ensure scalability for years to come 🏔 Here's what we learned: notion.so/blog/sharding-…

SQL Automation: 1. Use waybackurls/gau to get all possible url's 2. Use GF tool to filter SQL parameters [Create your own pattern for SQL] & save as allsql.txt 3. Send filtered url's to Sqlmap - python sqlmap.py -m allsql.txt --batch #bugbountytips #bugbounty