Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,870,585 DBAs, developers and SQL Server users

Headlines today   October 25, 2016

Managing Registered servers with SQL Powershell

Learn how to generate Registered Servers with PowerShell in this article.  Read more...
By Arco Scheepen 2016/10/25 | Source: | Category: registered servers
Rating: (not yet rated) |  Discuss |   Briefcase | 137 reads

Master Data Services – The Basics

Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained, gives organisations a powerful alternative to increasingly having to centralize databases as a way of preventing data from getting out sync or become inconsistent, and a reliable way of managing the flow of data through corporate IT systems. It makes microservice architectures realistic. Hari Yadav shows you how to get up and running with MDS.  Read more...
By Additional Articles 2016/10/25 | Source: SimpleTalk | Category: master data services (mds)
Rating: (not yet rated)  Rate this |   Briefcase | 669 reads
Previous headlines

EzAdo - Part 1

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.  Read more...
By Alan Hyneman 2016/10/24 | Source: | Category:
Rating: |  Discuss |   Briefcase | 1,083 reads

The Sort that Spills to Level 15,000

Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.  Read more...
By Additional Articles 2016/10/24 | Source: | Category: sort
Rating: (not yet rated)  Rate this |   Briefcase | 1,480 reads

Redgate DLM Demo Webinar

Watch the recording of our latest DLM Demo webinar and learn how to improve your database change management process. See how Redgate DLM plugs into Git, Jenkins & Octopus Deploy so that you can automate your database changes alongside your application code.  Read more...
By 2016/10/24 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,139 reads

JSON Select - Easily query values from JSON

Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+  Read more...
By Joshua Healy 2016/10/21 (first published: 2015/08/31) | Source: | Category: json
Rating: |  Discuss |   Briefcase | 11,791 reads

SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU9 for SP1.  Read more...
By Steve Jones 2016/10/21 (first published: 2015/02/23) | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 5,771 reads

Memory/Storage Technology Hierarchy and SQL Server

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.  Read more...
By Additional Articles 2016/10/21 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 3,290 reads

Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.   Read more...
By Mala Mahadevan 2016/10/20 | Source: | Category: r programming
Rating: |  Discuss |   Briefcase | 964 reads

SQLServerCentral team in Seattle

The team behind will be in Seattle at the PASS Summit next week, and we’d like to hear from you. If you’re heading to the event, we’d love to get feedback on how you use the site, and hear about any changes you’d like to see. If you’d be willing to have a quick chat, please email us, and we’ll set up some time with Steve and the team.  Read more...
By 2016/10/20 | Source: | Category: pass summit
Rating: (not yet rated) |  Discuss |   Briefcase | 1,708 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SELECT * Does Not Hurt Performance

I read all the time how SELECT * hurts performance. I even see where people have said that you just have...  Read more...
By Grant Fritchey 2016/10/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,105 reads

Thursday Game Night at PASS Summit

On Thursday night, Oct 27, 2016, Andy Warren and I are hosting a game night event at the Washington State...  Read more...
By Steve Jones 2016/10/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 197 reads
Question of the Day

Heaps and indexes

By Steve Jones 2016/10/25 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 185 reads

I have a simple table, created from this code:

CREATE TABLE [dbo].[Customers]
[CustomerID] [int] NULL,
[CustomerName] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerNotes] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [tinyint] NULL

I then add this index:

CREATE... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
327 905 SSC Eights!  
Jeff Moden
220 41646 SSC-Forever  
212 644 SSChasing Mays  
GP Van Eron
207 2431 SSCrazy  
Phil Parkin
194 7736 SSCertifiable  
Latest forum posts