Commits

Branch selector

 master

User selector

All users

All time

Commit History

Commits on Feb 3, 2022

• Query optimization 2

  brodriguezv

  committed
  a0cdc2d

  Copy full SHA for a0cdc2d

Commits on Nov 8, 2020

• SQL Server Query Optimization Part 1

  Show description for 59d1b8b
  brodriguezv

  committed
  59d1b8b

  Copy full SHA for 59d1b8b

Commits on Jul 17, 2020

• Aggregates and grouping

  Show description for f057b54
  brodriguezv

  committed
  f057b54

  Copy full SHA for f057b54

Commits on Jul 9, 2020

• Query basics

  Show description for adbc21e
  brodriguezv

  committed
  adbc21e

  Copy full SHA for adbc21e

Commits on Jun 17, 2020

• FIRST_VALUE and LAST_VALUE

  Show description for 711e776
  brodriguezv

  committed
  711e776

  Copy full SHA for 711e776

Commits on Jun 2, 2020

• Remove duplicates and demo table

  Show description for 7153005
  brodriguezv

  committed
  7153005

  Copy full SHA for 7153005

Commits on May 28, 2020

• Indexes

  Show description for 4284bcc
  brodriguezv

  committed
  4284bcc

  Copy full SHA for 4284bcc

Commits on May 21, 2020

• Dynamic Data Masking

  Show description for eec07d7
  brodriguezv

  committed
  eec07d7

  Copy full SHA for eec07d7

Commits on May 14, 2020

• Create dynamic-pivot.sql

  Show description for 14ecd70
  brodriguezv

  committed
  14ecd70

  Copy full SHA for 14ecd70

Commits on May 8, 2020

• Update recursive_cte.sql

  brodriguezv

  committed
  0d931be

  Copy full SHA for 0d931be

• Merge branch 'master' of https://github.com/sqldevmty/sql-code

  brodriguezv

  committed
  cf28e67

  Copy full SHA for cf28e67

• new files and updates

  Show description for 3d690f4
  brodriguezv

  committed
  3d690f4

  Copy full SHA for 3d690f4

Commits on Mar 19, 2020

• How to use recursive CTEs

  brodriguezv

  authored
  9aacf0f

  Copy full SHA for 9aacf0f

• Merge pull request #1 from sqldevmty/development

  Show description for 09ae17d
  brodriguezv

  committed
  09ae17d

  Copy full SHA for 09ae17d

Commits on Jan 22, 2020

• Merge pull request #1 from sqldevmty/development

  Show description for 8843af6
  brodriguezv

  authored
  8843af6

  Copy full SHA for 8843af6

Commits on Sep 25, 2019

• The OUTPUT clause.

  brodriguezv

  committed
  83d4879

  Copy full SHA for 83d4879

Commits on Sep 4, 2019

• How to use string_split function

  brodriguezv

  committed
  3fccecc

  Copy full SHA for 3fccecc

Commits on Aug 9, 2019

• How to use OFFSET - FETCH filters

  brodriguezv

  committed
  8ffd9c0

  Copy full SHA for 8ffd9c0

Commits on Jun 7, 2019

• Added and fixed snippet

  brodriguezv

  committed
  4f3871b

  Copy full SHA for 4f3871b

Commits on Jun 6, 2019

• Use the MERGE statement

  brodriguezv

  committed
  f8daceb

  Copy full SHA for f8daceb

Commits on May 30, 2019

• How to use STRING_AGG function

  brodriguezv

  committed
  a965c15

  Copy full SHA for a965c15

Commits on May 2, 2019

• APPLY operator

  brodriguezv

  committed
  0a60035

  Copy full SHA for 0a60035

Commits on Apr 17, 2019

• Orders table schema and data

  brodriguezv

  committed
  6184fd7

  Copy full SHA for 6184fd7

• Ignore files

  brodriguezv

  committed
  1859f10

  Copy full SHA for 1859f10

• Window aggregates and framing

  brodriguezv

  committed
  145d074

  Copy full SHA for 145d074

Commits on Mar 28, 2019

• Sample database and table to use with the examples, and Ranking functions examples.

  brodriguezv

  committed
  33e5f4f

  Copy full SHA for 33e5f4f

Commits on Mar 7, 2019

• Example of how to use LEAD() and LAG() functions.

  brodriguezv

  committed
  b94ccfd

  Copy full SHA for b94ccfd

Commits on Mar 6, 2019

• Revert "Employee shifts table and queries using LEAD and LAG functions."

  Show description for 86a0194
  brodriguezv

  committed
  86a0194

  Copy full SHA for 86a0194

• Employee shifts table and queries using LEAD and LAG functions.

  brodriguezv

  committed
  e391dff

  Copy full SHA for e391dff

Commits on Feb 20, 2019

• no message

  brodriguezv

  committed
  9d5aa40

  Copy full SHA for 9d5aa40

• Example on how to use ROW_NUMBER()

  brodriguezv

  committed
  a1574ce

  Copy full SHA for a1574ce

• Revert "Example on how to use ROW_NUMBER()"

  Show description for 57809d1
  benordz

  committed
  57809d1

  Copy full SHA for 57809d1

• Example on how to use ROW_NUMBER()

  benordz

  committed
  d855719

  Copy full SHA for d855719

Commits on Feb 13, 2019

• Initial commit

  brodriguezv

  authored
  9f5c444

  Copy full SHA for 9f5c444