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

Welcome to

A Microsoft SQL Server community of 1,777,834 DBAs, developers and SQL Server users

Headlines today   January 28, 2015

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.  Read more...
By Gregory Larsen 2015/01/28 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,049 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 2015/01/28 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 46,494 reads

Why Developers Need to Understand Execution Plans

If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.  Read more...
By Additional Articles 2015/01/28 | Source: SimpleTalk | Category: execution plan
Rating: (not yet rated)  Rate this |   Briefcase | 3,476 reads
Previous headlines

Data Mining Part 23: Security

In this chapter we will talk about security recommendations for SQL Server Data Mining.  Read more...
By Daniel Calbimonte 2015/01/27 | Source: | Category: roles
Rating: |  Discuss |   Briefcase | 1,332 reads

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...
By Grant Fritchey 2015/01/27 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 999 reads

Finding Encrypted Data in a SQL Server Database

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.  Read more...
By Additional Articles 2015/01/27 | Source: | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 3,744 reads

Selecting from sub-queries as tables

Using sub-queries as tables only requires an alias 
By Ben Kubicek 2015/01/26 | Source: | Category: sub-queries
Rating: |  Discuss |   Briefcase | 8,840 reads

SQL Prompt Tip #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/01/26 | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,713 reads

Discrete and Continuous Data in SQL

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.  Read more...
By Additional Articles 2015/01/26 | Source: SimpleTalk | Category: data
Rating: (not yet rated)  Rate this |   Briefcase | 5,509 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: | Category: duplicate data
Rating: |  Discuss |   Briefcase | 26,571 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Statistics Parsing

Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when...  Read more...
By g00p3 2015/01/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,271 reads

Excel BI Tip #17: Using the Timeline Filter

  As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...  Read more...
By DataOnWheels 2015/01/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,563 reads
Question of the Day


By Steve Jones 2015/01/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 898 reads

How many rows are returned?

CustomerID int
,Salesyear char(4)
, complete tinyint
, amount int
INSERT INTO dbo.sales
( CustomerID
, Salesyear
, complete
, amount
( 1, '2013', 1, 100)
, ( 1, '2013', 1, 200)
, ( 1, '2014',... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
623 833 SSC Eights!  
513 618 SSChasing Mays  
Jeff Moden
454 36313 SSC-Dedicated  
RK Mandava
366 2333 SSCrazy  
361 1975 SSCommitted  
Latest forum posts