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

Headlines today   August 27, 2015

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework  Read more...
By David Poole 2015/08/27 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,672 reads

An Introduction to Real-Time Communication with SignalR

SignalR, from Microsoft, solves many of the problems that come with developing web applications that need a communication channel with the server that is effective on a variety of server and client configurations. Christos Matskas gives an overview of the library and its potential.  Read more...
By Additional Articles 2015/08/27 | Source: SimpleTalk | Category: signalr
Rating: (not yet rated)  Rate this |   Briefcase | 1,654 reads

Database Documentation Survey

Documentation often gets left behind in software development, perhaps even more so when it comes to developing the database schema. How do you keep yours up-to-date? Do you even think you should?  Read more...
By Additional Articles 2015/08/27 (first published: 2015/08/20) | Source: Redgate | Category: survey
Rating:  Rate this |   Briefcase | 2,983 reads
Previous headlines

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem  Read more...
By Mike Good 2015/08/26 | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 2,730 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/26 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,104 reads

Identify SQL Server Database Growth Rates

Unchecked SQL Server database growth can hurt the bottom line of organizations in the form of poor application performance and increased infrastructure costs. In this article, Marios Philippopoulos looks at whether there's an easy way to proactively obtain a recent list of the fastest-growing databases in a SQL Server instance using information captured by default in the database engine.  Read more...
By Additional Articles 2015/08/26 | Source: | Category: database growth
Rating: (not yet rated)  Rate this |   Briefcase | 2,063 reads

Exam 70-462: Using Azure for the Practice Setup

A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.  Read more...
By Nathan Bell 2015/08/25 | Source: | Category: certification
Rating: |  Discuss |   Briefcase | 3,261 reads

Deciding on a Primary Key in Oracle

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.  Read more...
By Additional Articles 2015/08/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 2,462 reads

The Process to Provision and Configure Azure SQL PaaS

This document describes the process to provision a SQL Azure server manually. While it is expected that most servers will be provisioned using automation, DBA's must have the skills and know the process to perform the same provisioning manually.  Read more...
Rating: |  Discuss |   Briefcase | 967 reads

Learning Live Query Statistics

References and information on the Live Query Statistics feature in SQL Server 2016.  Read more...
By Site Owners 2015/08/24 | Source: | Category: live query statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,226 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Studying for the 70-462 Exam: Database Mirroring

If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...  Read more...
By Adam Kreul 2015/08/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,137 reads

Live Query Statistics

The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...  Read more...
By prakash karande 2015/08/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 729 reads
Question of the Day

Columnstore Index metadata

By Hugo Kornelis 2015/08/27 | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 619 reads

On SQL Server 2012, you create a columnstore index. You want to find out how many rows are in each rowgroup. Which DMV(s) can you query for this?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Piotr Ryszkowski
936 3136 Hall of Fame  
472 477 SSC-Addicted  
451 504 Mr or Mrs. 500  
344 344 Old Hand  
339 363 Old Hand  
Latest forum posts