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

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,538 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,278 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,726 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,528 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,911 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,089 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2015/09/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,598 reads

T-SQL Window Functions Speed Phreakery

Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions? Kathi revisits a famous SQL challenge to find out.  Read more...
By Additional Articles 2015/09/18 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,947 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 22,927 reads

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2015/08/28 (first published: 2013/06/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,477 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2015/08/21 (first published: 2013/05/08) | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 27,352 reads

Detecting Differences in Files on Servers

Detecting file differences on two different web servers using T-SQL.  Read more...
By Ed Wagner 2015/07/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,138 reads

Is It Worth Writing Unit Tests?

What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.  Read more...
By Ed Elliott 2015/07/23 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 6,653 reads

How to Get NULLs Horribly Wrong in SQL Server

NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.  Read more...
By Additional Articles 2015/07/14 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,580 reads

A simple trick for “Block Comment” syntax in SSMS

Make your comment blocks much more useful, in a surprising number of ways  Read more...
By Peter Zerk 2015/07/10 (first published: 2013/07/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,087 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2015/06/26 (first published: 2013/07/09) | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 22,843 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 2015/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,501 reads

Reusing T-SQL Code

Alex Kuznetsov, in an article taken from his book 'Defensive Database Programming with SQL Server', shows how DRY principles can be put in practice with constraints, stored procedures, triggers, UDFs and indexes.  Read more...
By Additional Articles 2015/06/10 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,733 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 2015/06/08 | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 11,201 reads

Demystifying the use of CASE in an ORDER BY statement

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.  Read more...
By Chuck Hoffman 2015/06/05 (first published: 2012/04/26) | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 25,821 reads
<< Newer    Items 21 to 40 of 1224    Older >>