Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag T-SQL Rss

Search for any content tagged t-sql

   Items 1 to 20 of 1171    Older >>
 

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2015/04/02 | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 1,405 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 14,052 reads

Unit Testing with SQL Server

Learn how to begin unit testing with tSQLt and SQL Server.   Read more...
By Alessandro Alpi 2015/03/26 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 4,564 reads

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,763 reads

Common Mistakes

This week Steve Jones is wondering what the common mistakes that T-SQL developers make are.  Read more...
By Steve Jones 2015/03/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 264 reads

The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...  Read more...
By Dwain Camps 2015/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,753 reads

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...
By Dwain Camps 2015/03/06 (first published: 2013/11/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,662 reads

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2015/02/27 (first published: 2013/11/12) | Source: SQLServerCentral.com | Category: outer joins
Rating: |  Discuss |   Briefcase | 20,476 reads

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins  Read more...
By Ashutosh Pandey 2015/02/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,131 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 2015/02/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,825 reads

Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask

Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do in their various contexts? Robert Sheldon has the answers to this and other questions.  Read more...
By Additional Articles 2015/02/10 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 10,100 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 2015/02/06 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 30,177 reads

Using a column name in a COUNT function

Putting a column name in a COUNT() function may not always give you what you are looking for.  Read more...
By Charles Kincaid 2015/01/30 (first published: 2013/10/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 26,654 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Sioban Krzywicki 2015/01/23 (first published: 2013/10/08) | Source: SQLServerCentral.com | Category: duplicate data
Rating: |  Discuss |   Briefcase | 28,472 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2015/01/09 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 30,085 reads

Parsing HTML to SQL using SQLDOM

It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM  Read more...
By David Rueter 2014/12/26 (first published: 2012/04/16) | Source: SQLServerCentral.com | Category: html
Rating: |  Discuss |   Briefcase | 14,497 reads

Linked lists

Learn how you can achieve better performance with linked list instead of a numbering column.  Read more...
By Andreas Bartels 2014/12/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,018 reads

Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask

Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.  Read more...
By Additional Articles 2014/12/18 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 10,392 reads

Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

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 2014/12/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,329 reads

The SQL Scrabble Puzzle

An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.  Read more...
By Additional Articles 2014/12/05 | Source: Other | Category: contest
Rating:  Rate this |   Briefcase | 7,781 reads
   Items 1 to 20 of 1171    Older >>