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

Popular Content

13 Questions about SQL Server Data Types You were Too Shy to Ask

Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums. Rob Sheldon continues in his mission to answer all those questions that we hesitate to ask.  Read more...
By Additional Articles 2014/07/21 | Source: SimpleTalk | Category: data types
Rating:  Rate this |   Briefcase | 12,286 reads

Version Control as a Cloud Service

Robert Sheldon wonders if cloud-based version control still too risky for a service that must be secure, and risk-free?   Read more...
By Additional Articles 2014/07/15 | Source: SimpleTalk | Category: source control
Rating:  Rate this |   Briefcase | 10,007 reads

Developing a Custom SSIS Source Component

SSIS was designed to be extensible.Although you can create tasks that will take data from a wide variety of sources, transform the data is a number of ways and write the results a wide choice of destinations, using the components provided, there will always be occasions when you need to customise your own SSIS component.  Read more...
By Additional Articles 2014/07/17 | Source: SimpleTalk | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 9,981 reads

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: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 16,527 reads

Who Truncated That Table & What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.  Read more...
By Sujeet Singh 2014/06/05 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 12,855 reads

SQL Saturday #302 - Albany

SQL Saturday is coming to Albany, NY on July 26, 2014. This is a free full day of training and networking for SQL Server professionals. This event also features a paid-for precon session with Grant Fritchey on query performance tuning. The event is soon so register while space is available.   Read more...
By Press Release 2014/07/16 | Source: SQL Saturday | Category: sql saturday
Rating:  Rate this |   Briefcase | 7,878 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 2014/05/27 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 11,479 reads

SQL Server Tables - 11 Questions You Were Too Shy to Ask

There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions. Robert Sheldon reckons that no questions about SQL Tables are off-limits, and deserve frank answers.   Read more...
By Additional Articles 2014/07/03 | Source: SimpleTalk | Category: tables
Rating:  Rate this |   Briefcase | 7,989 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: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 16,440 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: SQLServerCentral.com | Category: sql server 2014
Rating:  Rate this |   Briefcase | 10,635 reads

Why Put Your Database into Source Control?

Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.  Read more...
By Additional Articles 2014/07/25 | Source: SimpleTalk | Category: source control
Rating:  Rate this |   Briefcase | 6,882 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/07/23 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 25,646 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 | 8,918 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2014/07/17 | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 12,302 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/06/25 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 23,394 reads

Producing JSON Documents from SQL Server queries via TSQL

Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.  Read more...
By Additional Articles 2014/05/22 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 6,951 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,790 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: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 11,902 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/05/28 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 23,760 reads

Finding and Eliminating Duplicate or Overlapping Indexes

Duplicate & Overlapping Indexes can be a drag on write speed and disk resources. How do we find and eliminate them quickly and effectively?  Read more...
By Edward Pollack 2014/06/16 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,776 reads