TRUNCATE vs DELETE: they're not interchangeable. DELETE: removes rows one at a time. Fully logged (each row goes to the transaction log). Fires DELETE triggers. Supports WHERE clause. Slow on large tables. TRUNCATE: deallocates data pages. Minimally logged (only page deallocation is logged). Does not fire row-level triggers. No WHERE clause. Resets identity columns. Extremely fast. Both are rollback-safe inside a transaction. TRUNCATE can't be used on tables referenced by a foreign key — even if the FK table is empty. You must drop or disable the FK first. For clearing large tables in dev/staging or end-of-period resets: TRUNCATE every time. #SQLServer #TSQL #TRUNCATE #Performance

SQL Server 2025 adds AI‑assisted tuning and automatic plan correction—but you still need to know why queries slow down. @GFritchey dives deep into statistics, parameter sniffing & execution plans to stay in control. #DataPlatform #TSQL #SQLPerformance 🔗 ow.ly/zRaa50YVAPK

Latest Master Class Recordings More Shorts here: bit.ly/SQLServerShorts Share/RT. #SQLServer #SQL #TSQL #AzureSQL #SQLServerWithAmitBansal

Job Opportunity. Apply Now Online! Sr. .Net Applications Developer (Deadline 6/19) $76.10-$86.50/hr | Health Ins. | FT, Contract | Tallahassee, FL | Onsite zurl.co/LL90O #BIICSInc #BIICS #TechJobs #nowhiring #FLJobs #TallahasseeJobs #DotNet #ASPNet #TSQL #AzureDevOps

PIVOT and UNPIVOT rotate data between rows and columns. PIVOT: turn distinct values in one column into column headers: SELECT * FROM ( SELECT Year, Quarter, Revenue FROM SalesData ) src PIVOT ( SUM(Revenue) FOR Quarter IN ([Q1],[Q2],[Q3],[Q4]) ) pvt; UNPIVOT: turn column headers back into rows (useful for normalizing wide tables). The PIVOT syntax requires knowing the column values at query-write time. For dynamic column lists, you need dynamic SQL. For most PIVOT patterns, a conditional aggregation (SUM(CASE WHEN Quarter='Q1' THEN Revenue END)) is more readable and equally fast. #SQLServer #TSQL #PIVOT #DataTransformation

Latest Master Class Recordings More Shorts here: bit.ly/SQLServerShorts Share/RT. #SQLServer #SQL #TSQL #AzureSQL #SQLServerWithAmitBansal

Latest Master Class Recordings More Shorts here: bit.ly/SQLServerShorts Share/RT. #SQLServer #SQL #TSQL #AzureSQL #SQLServerWithAmitBansal

Latest Master Class Recordings More Shorts here: bit.ly/SQLServerShorts Share/RT. #SQLServer #SQL #TSQL #AzureSQL cc @SQLMaestros #SQLServerWithAmitBansal

Master Transact-SQL for querying data in SQL Server, Azure SQL, & Synapse Analytics! Perfect for data analysts, engineers, scientists, DBAs, & more. Learn to write powerful SQL queries—enroll now! #TSQL #DataTraining @ExcelMaestro opencastlabs.co.ke/courses/e…

⎐كُـود⎐كوبِون⎐خـِصم⎐ ⎐نون⎐ ⊵S3Q⊴ ⎐ايهرب⎐ايهيرب اهرب ⊵GCA5893⊴ ⊴تيمو ⊴ ⊵TEB72⊴ ❮كارديال❯ A004 ⎐نمشي⎐ ⊵AABN⊴ ⎐ريف⎐للعطور ⎐ ⎐AX140⊴ ماكــس⎐ A9B *** tSqL

Persisted computed columns let the engine store the computed result on disk rather than recalculating on every read. CREATE TABLE dbo.Orders ( OrderId INT PRIMARY KEY, Qty INT, UnitPrice DECIMAL(10,2), LineTotal AS (Qty * UnitPrice) PERSISTED ); Benefits: → The value is stored once on write, not recalculated on every SELECT → You can build an index on the persisted column → Statistics are maintained on it like any physical column Constraints: the expression must be deterministic and precise. GETDATE(), RAND(), and non-deterministic functions can't be persisted. Great for frequently queried derived values, especially when those values appear in WHERE or JOIN clauses. #SQLServer #TSQL #ComputedColumns #Indexes

Master the art of CROSS APPLY in T-SQL and gain a solid understanding of how it lays the groundwork for other join operations in SQL Server. Enhance your skills now! #SQL #TSQL #JoinOperations youtu.be/tMnyNFgTMR0 youtu.be/tMnyNFgTMR0

Índices Filtrados: Corte o Excesso ✂️ Por que desperdiçar recursos indexando milhões de linhas que suas consultas nunca acessam? youtu.be/dd5Oml3tOX4 #SQLServer #PerformanceTuning #SQLPerformance #DatabaseOptimization #DBA #TSQL #sql #SQLTips #DataManagement #FilteredIndexes

OPTION(RECOMPILE) at the statement level is a precision tool, not a last resort. When a stored procedure has one statement with severe parameter sensitivity and the rest execute fine, adding OPTION(RECOMPILE) to just that statement forces recompilation of that statement only — without touching the plan for the rest of the procedure. The compiled plan is not cached. Fresh plan every execution. CPU overhead per execution is negligible for queries that run infrequently. Ideal for: → Reports with highly variable filter ranges → Queries against heavily skewed data → Queries with optional parameters (WHERE (@Status IS NULL OR Status = @Status)) Don't add it globally. Profile first, apply surgically. #SQLServer #ParameterSniffing #TSQL #Performance

The successful applicant will work closely with Data Analysts, developers, subject matter experts, and business stakeholders throughout the analysis, development, testing, and implementation lifecycle. proactive.it/job/sql-data-en… #SSIS #TSQL

Full-text search in SQL Server lets you query word meanings, not just string patterns. CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT; CREATE FULLTEXT INDEX ON dbo.Articles (Title, Body LANGUAGE 1033) KEY INDEX PK_Articles; Now query: -- Contains word or phrase SELECT * FROM dbo.Articles WHERE CONTAINS(Body, 'index'); -- Weighted relevance ranking SELECT * FROM dbo.Articles WHERE FREETEXT(Body, 'SQL Server performance'); -- Ranked with score SELECT a.Title, k.RANK FROM dbo.Articles a INNER JOIN CONTAINSTABLE(dbo.Articles, Body, 'NEAR(SQL, performance)') k ON a.ArticleId = k.[KEY] ORDER BY k.RANK DESC; LIKE '%word%' scans every row. Full-text seeks an inverted index. #SQLServer #FullTextSearch #TSQL

Job Opportunity. Apply Now Online! Sr. .Net Applications Developer (Deadline 6/19) $76.10-$86.50/hr | Health Ins. | FT, Contract | Tallahassee, FL | Onsite zurl.co/fcPPE #BIICSInc #BIICS #TechJobs #nowhiring #FLJobs #TallahasseeJobs #DotNet #ASPNet #TSQL #AzureDevOps

SQL Server 2025 adds AI‑assisted tuning and automatic plan correction—but you still need to know why queries slow down. @GFritchey dives deep into statistics, parameter sniffing & execution plans to stay in control. #DataPlatform #TSQL #SQLPerformance 🔗 ow.ly/zRaa50YVAPK

ID-4100の逆トーンスケルチ（どこぞのバス会社など） MENU→メモリー管理→メモリーチャンネル→当該登録メモリ→[QUICK]で編集に入る→[Tone選択]を[TSQL-R]→[TSQL周波数]→[74.4Hz]→[上書き]