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

Popular Content

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2014/03/25 | Source: | Category: except
Rating: |  Discuss |   Briefcase | 14,920 reads

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2014/04/07 | Source: | Category: sql like search
Rating: |  Discuss |   Briefcase | 14,522 reads

SQL Server 2014 Has Been Released

Today is the first day of general availability for SQL Server 2014.  Read more...
By Press Release 2014/04/01 | Source: | Category: sql server 2014
Rating:  Rate this |   Briefcase | 9,419 reads

SQLServerCentral apologizes and you can win a book

After a plagiarized article this week, a content for you.  Read more...
By Press Release 2013/12/05 | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 11,822 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2014/03/24 | Source: | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 7,923 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 2014/04/09 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,971 reads

14 SQL Server Indexing Questions You Were Too Shy To Ask

The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.  Read more...
By Additional Articles 2014/04/08 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 6,170 reads

Lessons Learned from Six Years of Agile Database Development

Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a reality, without disrupting users. He explains how this allowed his team to apply an iterative, evolutionary approach to the design and development of their databases, as well as applications.   Read more...
By Additional Articles 2013/12/03 | Source: SimpleTalk | Category: agile database techniques
Rating:  Rate this |   Briefcase | 10,716 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2014/04/02 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 19,448 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/02/19 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 16,672 reads

Microsoft SQL Server 2014 released to manufacturing

, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1.  Read more...
By Press Release 2014/03/19 | Source: TechNet Blogs | Category: sql server 2014
Rating:  Rate this |   Briefcase | 6,603 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/03/19 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 16,436 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 2013/10/28 | Source: | Category: merge
Rating: |  Discuss |   Briefcase | 15,757 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Stefan Krzywicki 2013/10/08 | Source: | Category: duplicate data
Rating: |  Discuss |   Briefcase | 15,574 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 2014/01/15 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,963 reads

What is Biml? - Level 1

An introduction to the Biml language from Andy Leonard that helps  Read more...
By Andy Leonard 2013/07/17 | Source: | Category: biml
Rating: |  Discuss |   Briefcase | 17,104 reads

Stairway to T-SQL: Beyond The Basics Level 3: Building a Correlated Subquery

This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.  Read more...
By Gregory Larsen 2014/03/05 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,898 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaz Kastrun 2014/03/10 | Source: | Category: r language
Rating: |  Discuss |   Briefcase | 7,686 reads

Creating a Date Range from Multiple Rows Based on a Single Date

When you've got only a single effective date on a record and you need to artificially create the effective end date based on a following row in T-SQL, the techniques discussed in this article will help you decide what is best.  Read more...
By Dwain Camps 2014/03/18 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,670 reads

Applying The Scientific Method to SQL Server Performance Tuning

A relational database is a complex machine that is asked to deal with intricate problems. When things go wrong, it usually takes knowledge, deduction and a systematic approach to track down the root core of problems and to determine the best fix, Joshua Feierman illustrates how this can be done.  Read more...
By Additional Articles 2014/03/31 | Source: SimpleTalk | Category: problem solving
Rating:  Rate this |   Briefcase | 5,448 reads