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

Headlines today   November 25, 2015

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.  Read more...
By Gregory Larsen 2015/11/25 | Source: | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 328 reads

SQL Prompt Tips #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/11/25 (first published: 2015/01/26) | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 2,128 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/11/25 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 11,680 reads


Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.  Read more...
By Additional Articles 2015/11/25 | Source: | Category: coalesce
Rating: (not yet rated)  Rate this |   Briefcase | 298 reads
Previous headlines

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 | 3,182 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,641 reads

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,333 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,098 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 | 20,015 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,739 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

PowerMap with Custom Region shapefiles - Demystified

[2015-Nov-18]  Today is a global GIS Day ( where people across the globe celebrate and promote the use of various geo...  Read more...
By Rayis Imayev 2015/11/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 278 reads
Question of the Day

Filestream filegroups

By Steve Jones 2015/11/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

When I alter a SQL Server 2015 database to add a Filestream filegroup, what do I need to do to allow Filestream access to the tables and columns I will...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1111 1408 Ten Centuries  
366 521 Mr or Mrs. 500  
342 5846 SSCertifiable  
Iwas Bornready
323 5908 SSCertifiable  
Ed Wagner
289 7129 SSCertifiable  
Latest forum posts