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

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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,230 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: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 11,562 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: SQLServerCentral.com | Category: rand()
Rating: |  Discuss |   Briefcase | 1,816 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,340 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: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 13,433 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,426 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,204 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,049 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,459 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,614 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: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 6,424 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,246 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: SQLServerCentral.com | Category: parsename
Rating: |  Discuss |   Briefcase | 18,093 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,359 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,065 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: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 21,516 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: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 26,270 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,686 reads

A Simple Formula to Calculate the ISO Week Number

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!  Read more...
By Jeff Moden 2015/10/23 (first published: 2013/04/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,523 reads

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2015/10/21 | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,877 reads
   Items 1 to 20 of 1219    Older >>