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,841,406 DBAs, developers and SQL Server users

Headlines today   November 24, 2015

Hadoop many flavors of SQL

What are the most popular SQL implementations for Hadoop? How different are they from T-SQL?  Read more...
By Daniel Klionsky 2015/11/24 | Source: | Category: big data
Rating: |  Discuss |   Briefcase | 2,975 reads

Azure SQL Database - Transparent Data Encryption

Transparent Data Encryption offers the ability to encrypt content of the database, its transaction logs, as well as backups while at rest. Encryption and decryption are performed in real-time, at the individual page level, as the database is being written to and read from storage, without necessitating changes to applications accessing their data. Marcin Policht reviews the feature.  Read more...
By Additional Articles 2015/11/24 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,426 reads
Previous headlines

Getting ready for Hadoop

Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.  Read more...
By David Poole 2015/11/23 | Source: | Category: hadoop
Rating: |  Discuss |   Briefcase | 4,249 reads

SQL Server Heaps, and Their Fragmentation

In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are likely to be the cause of poor performance. If a table is likely to have a large number of changes, then it can become fragmented due to way that space is allocated and forward pointers used. How does one detect this problem? Is it significant? How does one deal with it, if necessary? Neeraj Tripathi explains.  Read more...
By Additional Articles 2015/11/23 | Source: SimpleTalk | Category: heaps
Rating: (not yet rated)  Rate this |   Briefcase | 2,029 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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 19,983 reads

Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts

There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard snippets suit developers fine but aren't so DBA-oriented, so he set about asking the SQLServerCentral community what they typed in the most, and set about producing a set of DBA snippets with the results.   Read more...
By Additional Articles 2015/11/20 | Source: SimpleTalk | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,705 reads

SQLCMD and Batch File magic

Execute scripts in a folder with a single click using SQLCMD and a batch file.  Read more...
By Manu Mohanan 2015/11/19 | Source: | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 5,643 reads

Webinar: Unit Testing in SQL Server with tSQLt

Join tSQLt developer, Sebastian Meine, and Steve Jones as they answer your questions and show you how to unit test T-SQL code.  Read more...
By Press Release 2015/11/19 (first published: 2015/11/12) | Source: | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,908 reads

Installing SQL Server 2016

Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.  Read more...
By Additional Articles 2015/11/19 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,527 reads

A Single-Parameter Date Range in SQL Server Reporting Services

Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.  Read more...
By John F. Tamburo 2015/11/18 | Source: | Category: ssrs
Rating: |  Discuss |   Briefcase | 5,347 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Identity Column Increment Value (EVEN/ODD)

As always I’m sitting at my desk, minding my own business, when an email comes in from a developer. “Hey DBA’s,...  Read more...
By cjsommer 2015/11/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,315 reads

Reporting Services redesign – it’s the little things

SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing: new look...  Read more...
By Koen Verbeeck 2015/11/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,380 reads
Question of the Day

The dotted table

By Steve Jones 2015/11/24
Rating: (not yet rated) |  Discuss |   Briefcase | 1,071 reads

What's wrong with this table?



    myid INT

  , mychar VARCHAR(200)

Top Members (last 30 days)
# Name Score Level
30 days All-time
1111 1408 Ten Centuries  
370 521 Mr or Mrs. 500  
340 5844 SSCertifiable  
Iwas Bornready
323 5908 SSCertifiable  
Ed Wagner
287 7127 SSCertifiable  
Latest forum posts