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

Aggregate Data for the Last Day of the Month

On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.  Read more...
By Adam Aspin 2018/08/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,008 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2018/08/10 (first published: 2016/09/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,050 reads

Using a CTE as a Tally Table

Sometimes you need to output blank lines - in effect displaying Records for Missing Data. This article explains how to use a CTE to do this  Read more...
By Adam Aspin 2018/08/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,676 reads

Using a Derived Table to Compare Data with Values from a Previous Year

Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL  Read more...
By Adam Aspin 2018/08/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,235 reads

Display Median Values

DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this  Read more...
By Adam Aspin 2018/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 911 reads

PARSE

Introducing the PARSE function, brought to us in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/07/24 | Source: SQLServerCentral.com | Category: parse()
Rating: |  Discuss |   Briefcase | 1,542 reads

Segment Data into Deciles

This short article shows a simple example of how to segment data into deciles  Read more...
Rating: |  Discuss |   Briefcase | 793 reads

T-SQL Window Functions and Performance

T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.  Read more...
By Additional Articles 2018/07/16 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,948 reads

Generating Completely Random Sample Output from a Dataset

This short article shows a simple example of how to generate completely random sample output from a Dataset  Read more...
By Adam Aspin 2018/07/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 748 reads

Ensuring Each Client has a Full Set of Key-Value Pairs

In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.  Read more...
By Steve Jones 2018/07/10 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 551 reads

Creating Compound Interest Calculations in SQL

This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills  Read more...
By Adam Aspin 2018/07/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,098 reads

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,509 reads

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 2018/06/28 (first published: 2017/05/25) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,250 reads

Introduction to T-SQL Window Functions

T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.  Read more...
By Additional Articles 2018/06/28 | Source: SimpleTalk | Category: window functions
Rating: (not yet rated)  Rate this |   Briefcase | 4,095 reads

Common Mistakes

This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.  Read more...
By Steve Jones 2018/06/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 498 reads

Quick Tips For Debugging Large Stored Procedures

SSMS is a good management tool, but it’s not a good development tool. When you’re writing some simple queries, it’s fine. When you’re writing code with lots of branching, dynamic SQL, temp tables, error handling, and so on… Not so much. Here are some tips Erik darling has put together after a couple years of wrangling the Blitz scripts in the First Responder Kit.  Read more...
By Additional Articles 2018/06/01 | Source: Brent Ozar Unlimited Blog | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,781 reads

TRY_CONVERT

An introduction to the TRY_CONVERT function, introduced in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/05/29 | Source: SQLServerCentral.com | Category: try_convert()
Rating: |  Discuss |   Briefcase | 1,969 reads

One Million Tables

A quick experiment to create one million tables in a database.  Read more...
By Steve Jones 2018/05/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,341 reads

Friday the 13th

Looking forward to the next few ones of these scary days?  Read more...
By Jan Van der Eecken 2018/05/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 855 reads

Random Word Generation for Data Scrubbing

With HIPAA and GDPR requiring your careful scrubbing of data for lower environments, random word generation promises to be a huge helper. Read here how to do it.  Read more...
By John F. Tamburo 2018/05/01 | Source: SQLServerCentral.com | Category: rand()
Rating: |  Discuss |   Briefcase | 1,188 reads
   Items 1 to 20 of 1326    Older >>