Ebru BaddalUSER-DEFINED FUNCTION (UDF)A user-defined function is a Transact-SQL or common language runtime (CLR) routine that accepts parameters, performs an action, such as a…Sep 28, 2023Sep 28, 2023
Ebru BaddalUse #Temp Table Instead of CTETemporary tables are valuable when you need to perform complex data processing or transformations in your SQL queries. They allow you to…Sep 22, 2023Sep 22, 2023
Ebru BaddalRecursive CTE -101A Recursive Common Table Expression (CTE) in SQL serves the goal of querying hierarchical or recursive data structures, such as…Aug 24, 2023Aug 24, 2023
Ebru BaddalAzure Synapse Analytics TemelleriSon zamanlarda Azure Synapse adını sıkça duyuyoruz. Peki, nedir bu Azure Synapse Analytics?Apr 26, 2023Apr 26, 2023
Ebru BaddalCOALESCE( ) vs ISNULL( ) in SQLISNULL() replaces NULL with the specified replacement value. Do not use ISNULL to find NULL values. Use IS NULL instead. The following…Feb 26, 2023Feb 26, 2023
Ebru BaddalROLLUP( ) and CUBE( ) in SQLROLLUP and CUBE are performance functions. They are used with the GROUP BYclause. ROLLUP calculates subtotals and grand totals. The CUBE is…Feb 20, 2023Feb 20, 2023
Ebru BaddalWindow Functions in SQLIn SQL, a window function or analytic function is a function which uses values from one or multiple rows to return a value for each row…Sep 24, 2022Sep 24, 2022
Ebru Baddal5 Essential Subquery ExamplesA subquery is also called an inner query or inner select, while the statement containing a subquery is also called an outer query or outer…Jul 6, 2022Jul 6, 2022
Ebru BaddalCase Function in SQLThe CASE statement goes through conditions and returns a value when the first condition is met (like an if-then-else statement). So, once a…May 24, 2022May 24, 2022
Ebru BaddalIncremental Refresh neden kullanılır ve nasıl oluşturulur?Power BI’da veriler delete-reload yöntemi ile refresh edilir. Ancak Incremental refresh büyük veri setlerinde küçük bir zamanı baz alarak…Apr 24, 2022Apr 24, 2022