SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag T-SQL Rss

Search for any content tagged t-sql

   Items 1 to 20 of 1368    Older >>
 

The OUTPUT Clause for INSERT and DELETE Statements

In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.  Read more...
By Amarendra Reddy Thummeti 2019/03/15 (first published: 2017/05/25) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,648 reads

The OUTPUT Clause for the MERGE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.  Read more...
By Amarendra Reddy Thummeti 2019/03/08 (first published: 2017/06/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,520 reads

The Performance of Window Aggregates Revisited with SQL Server 2019

T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.  Read more...
By Additional Articles 2019/03/07 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,786 reads

Unit Testing with SQL Server

Learn how to begin unit testing with tSQLt and SQL Server.   Read more...
By Alessandro Alpi 2019/03/01 (first published: 2015/03/26) | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 7,534 reads

A Sudoku Solver for Ordinary folk

Solving Sudoku in smaller, simpler steps  Read more...
By Pete Revell 2019/02/21 | Source: SQLServerCentral.com | Category: sudoku
Rating: |  Discuss |   Briefcase | 1,127 reads

Learning about DML Triggers

Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.  Read more...
By Steve Jones 2019/02/19 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 590 reads

Installing R packages in SQL Server R Services

This article shows four ways you can use when installing missing R packages for Microsoft R Services.  Read more...
By Tomaž Kaštrun 2019/02/01 (first published: 2016/09/29) | Source: SQLServerCentral.com | Category: r package
Rating: |  Discuss |   Briefcase | 1,864 reads

Rolling Back CREATE DDL Statements

There is a myth that DDL statements can't be rolled back. This article tests and debunks the myth.  Read more...
By Steve Jones 2019/01/24 | Source: SQLServerCentral.com | Category: data definition language
Rating: |  Discuss |   Briefcase | 705 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/21 (first published: 2019/01/14) | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 1,662 reads

Manipulating Filetable Files Programatically

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer  Read more...
By Steve Jones 2019/01/18 (first published: 2016/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,978 reads

Saving Data to Various Formats, Using SQL

You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.  Read more...
By Additional Articles 2019/01/17 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,511 reads

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Learn how to use T-SQL to fix contents of an XML document using FLWOR  Read more...
By Additional Articles 2019/01/17 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,560 reads

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.  Read more...
By Additional Articles 2019/01/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,635 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/21 (first published: 2019/01/14) | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 1,662 reads

The Basics of iTVFs

Learn the basics of inline table valued functions in this short article.  Read more...
By Steve Jones 2019/01/10 | Source: SQLServerCentral.com | Category: itvf
Rating: |  Discuss |   Briefcase | 1,085 reads

Primary keys for an OLTP database

OLTP database performance with different clustered indexes.  Read more...
By Evgeny Garaev 2018/12/27 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 851 reads

The Bones of SQL - The Holiday Table

This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.  Read more...
By Bob Hovious 2018/12/25 (first published: 2016/09/19) | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 3,493 reads

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?  Read more...
By Mike Byrd 2018/12/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,571 reads

An Overview of STRING_SPLIT()

Learn how to use the STRING_SPLIT() function in T-SQL.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: string_split()
Rating: |  Discuss |   Briefcase | 1,529 reads

Transferring Data with JSON in SQL Server

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.  Read more...
By Additional Articles 2018/12/05 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 3,025 reads
   Items 1 to 20 of 1368    Older >>