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

<< Newer    Items 21 to 40 of 1241    Older >>


Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2016/06/07 | Source: | Category: percent_rank
Rating: |  Discuss |   Briefcase | 3,698 reads


When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,271 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2016/05/27 (first published: 2015/02/24) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,008 reads

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2016/05/13 (first published: 2014/03/04) | Source: | Category: execution plans
Rating: |  Discuss |   Briefcase | 12,963 reads

RANDom traps for the unwary

The Books Online description of the RAND() function is only true from certain perspectives.  Read more...
By David Poole 2016/05/09 | Source: | Category: rand()
Rating: |  Discuss |   Briefcase | 2,166 reads

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.  Read more...
By Gregory Larsen 2016/04/20 (first published: 2014/04/09) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,728 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: | Category: special characters
Rating: |  Discuss |   Briefcase | 13,765 reads

Insert Stored Procedure Results Into New Table Without Using OPENQUERY

OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.  Read more...
By Orlando Colamatteo 2016/03/22 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,733 reads

Stairway to T-SQL: Beyond The Basics Level 5: Storing Data in Temporary Tables

There are times when retrieving data for complex business requirement requires you to temporarily store one or more results sets for a short period of time. Typically these temporary tables are stored in the scope of the current connection, but they may also need to be available across multiple connections.   Read more...
By Gregory Larsen 2016/03/18 (first published: 2014/04/02) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,409 reads

Find a String in a String

Learn how you can find data in a string and extract it, no matter where it's located.  Read more...
By Steve Jones 2016/03/10 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,117 reads

Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.  Read more...
By Gregory Larsen 2016/02/19 (first published: 2014/12/17) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,977 reads

Holidays and Calendar Generation

Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.  Read more...
By Paul Hunter 2016/02/16 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,675 reads

Find and Remove Duplicate Records SQL Server

Learn a quick method to find and remove duplicate records in your SQL Server tables.  Read more...
By Ginger Keys 2016/02/01 | Source: | Category: data integrity
Rating: |  Discuss |   Briefcase | 6,647 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 2016/01/28 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,281 reads

Having fun with PARSENAME (SQL Spackle)

PARSENAME is perhaps the most infrequently used built-in documented function in SQL Server. SQL Server Microsoft Certified Master Wayne Sheffield shows why this nifty function ought to be included in your SQL toolbox.  Read more...
By Wayne Sheffield 2016/01/15 (first published: 2014/03/17) | Source: | Category: parsename
Rating: |  Discuss |   Briefcase | 18,148 reads

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2016/01/04 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,434 reads

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.  Read more...
By Tom Staab 2015/12/29 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,073 reads

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2015/12/18 (first published: 2014/05/27) | Source: | Category: cte
Rating: |  Discuss |   Briefcase | 21,707 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2015/12/11 (first published: 2014/07/17) | Source: | Category: rows to columns
Rating: |  Discuss |   Briefcase | 26,310 reads

Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause

The first topic in this stairway will be discussing the TOP clause. The TOP clause allows you to control the number of rows to be returned or affected by a query.  Read more...
By Gregory Larsen 2015/11/20 (first published: 2014/01/15) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,978 reads
<< Newer    Items 21 to 40 of 1241    Older >>