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

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2017/02/17 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 33,283 reads

Lists With, or Without, Ranges in both T-SQL and PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.  Read more...
By Additional Articles 2017/02/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,448 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2017/02/10 (first published: 2015/09/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,872 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 2017/02/10 (first published: 2015/06/08) | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 15,610 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2017/02/03 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 36,681 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?  Read more...
By John Hick 2017/01/27 (first published: 2013/04/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 37,315 reads

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 | 3,198 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,317 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,259 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 | 106 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 | 513 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2017/02/10 (first published: 2015/09/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,872 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 | 2,020 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,465 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,603 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,186 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,455 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,420 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,397 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 | 13,127 reads
   Items 1 to 20 of 1253    Older >>