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 1363    Older >>
 

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 | 411 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,836 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 | 691 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,602 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,956 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,380 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,506 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,573 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,602 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,072 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 | 842 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,478 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,544 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,515 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 | 2,989 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2018/11/30 (first published: 2016/10/06) | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 3,952 reads

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.  Read more...
By Toby Ovod-Everett 2018/11/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 513 reads

Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.  Read more...
By Steve Jones 2018/11/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 758 reads

Nasty Fast N-Grams (Part 1): Character-Level Unigrams

An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.  Read more...
By Alan Burstein 2018/11/22 (first published: 2016/06/23) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 3,910 reads

T-SQL Decommenter Part III

Detailed explanation of the recursive section of the T-SQL Decommenter.  Read more...
By Toby Ovod-Everett 2018/11/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 632 reads
   Items 1 to 20 of 1363    Older >>