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

Headlines today   May 6, 2016

Unique Indexes Are Code; Non-Unique Indexes Are Data

Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.  Read more...
By Daniel White 2016/05/06 (first published: 2014/06/26) | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 9,154 reads

Announcing Bilm Academy

Join Andy Leonard the week of May 9-13 for 5 free days of Biml training.   Read more...
By Press Release 2016/05/06 (first published: 2016/04/26) | Source: | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 3,923 reads

SQL Server Reporting Services CountDistinct and Previous Functions

Scott Murray takes a look at what count function variations and related functions are available in SQL Server Reporting Services (SSRS).  Read more...
By Additional Articles 2016/05/06 | Source: | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 420 reads
Previous headlines

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2016/05/05 | Source: | Category: openjson
Rating: |  Discuss |   Briefcase | 1,179 reads

ASP.NET Core: A More Realistic Starter Kit

ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?  Read more...
By Additional Articles 2016/05/05 | Source: SimpleTalk | Category:
Rating: (not yet rated)  Rate this |   Briefcase | 1,628 reads

Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.  Read more...
By Daniel Calbimonte 2016/05/04 | Source: | Category: data
Rating: |  Discuss |   Briefcase | 634 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 2016/05/04 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 21,113 reads

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.  Read more...
By Additional Articles 2016/05/04 | Source: | Category: string_split
Rating: (not yet rated)  Rate this |   Briefcase | 2,200 reads

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Ability to enable Instant File Initialization during the installation of SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 948 reads

Execute Dynamic SQL commands in SQL Server

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?  Read more...
By Additional Articles 2016/05/03 | Source: | Category: dynamic sql
Rating:  Rate this |   Briefcase | 3,677 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

PASS 2016 – A Business Case for Attendance

For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the...  Read more...
By Rolf Tesmer (Mr. Fox SQL) 2016/05/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,147 reads
Question of the Day

More Unicode

By Steve Jones 2016/05/06 | Category: unicode
Rating: (not yet rated) |  Discuss |   Briefcase | 191 reads

Can I run this code, and what is returned? (choose 2).

SET @n = N'Abc';
Top Members (last 30 days)
# Name Score Level
30 days All-time
748 3396 Hall of Fame  
474 1114 Ten Centuries  
443 3274 Hall of Fame  
440 440 SSC-Addicted  
Iwas Bornready
428 7109 SSCertifiable  
Latest forum posts