Click here to monitor SSC
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 1247    Older >>
 

Simpson's Paradox

This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.   Read more...
By Mala Mahadevan 2017/01/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,996 reads

Using Mod to Generate Work Shifts

A short story on using the mod function to a shifting query.  Read more...
By Joe McGovern 2016/12/22 | Source: SQLServerCentral.com | Category: mod
Rating: |  Discuss |   Briefcase | 1,186 reads

How to Capture Deleted Records

This article shows a few techniques that help in capturing deleted records.  Read more...
By Darko Martinovic 2016/12/19 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,188 reads

Finally, Create or Alter

Today Steve Jones looks at the CREATE OR ALTER syntax, added in SQL Server 2016 SP1.  Read more...
By Steve Jones 2016/11/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Online T-SQL Scripts and Copyright

The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.  Read more...
By Brad McGehee 2016/11/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 510 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2016/11/18 (first published: 2015/09/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,964 reads

Bones of SQL - Practical Calendar Queries

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.  Read more...
By Bob Hovious 2016/10/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,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 2016/10/06 | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 2,386 reads

Constant Data Types

Data types are an important part of how tables and variables work. Did you know that constants have databases too?  Read more...
By Kenneth Fisher 2016/10/03 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,600 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 2016/09/29 | Source: SQLServerCentral.com | Category: r package
Rating: (not yet rated) |  Discuss |   Briefcase | 1,061 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2016/09/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,431 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2016/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,392 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 2016/09/19 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 2,315 reads

A Case FOR Cursors...

We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."  Read more...
By Chris Jones 2016/09/09 (first published: 2015/06/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 12,985 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2016/08/26 (first published: 2015/06/08) | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 14,348 reads

Using Microsoft R in Enterprise Environments

This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.  Read more...
By Tomaž Kaštrun 2016/08/25 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,811 reads

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2016/08/23 | Source: SQLServerCentral.com | Category: set options
Rating: |  Discuss |   Briefcase | 2,591 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2016/08/19 (first published: 2015/06/23) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,774 reads

Simple T-SQL Code Comparison With PowerShell

Tim Smith shows how you can use PowerShell to automate a simple comparison of objects such as stored procedures, views, and fucntions.  Read more...
By Additional Articles 2016/08/17 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,352 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.  Read more...
By Mickey Stuewe 2016/08/12 (first published: 2015/06/02) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 15,776 reads
   Items 1 to 20 of 1247    Older >>