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

Headlines today   July 27, 2015

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2015/07/27 | Source: | Category: set-based loop
Rating: |  Discuss |   Briefcase | 8,310 reads

Learning Backup to Azure

References and links to get you started in backing up your database to the Azure blob storage.  Read more...
By Site Owners 2015/07/27 | Source: | Category: backup to azure
Rating: (not yet rated) |  Discuss |   Briefcase | 454 reads

Can Code Review Be Automated?

Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.  Read more...
By Additional Articles 2015/07/27 | Source: SimpleTalk | Category: code review
Rating: (not yet rated)  Rate this |   Briefcase | 2,710 reads
Previous headlines

SAN and NAS protocols and how they impact SQL Server

Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.  Read more...
By Gregory Jackson 2015/07/24 (first published: 2012/04/24) | Source: | Category: san
Rating: |  Discuss |   Briefcase | 14,522 reads

SQL Style Habits: Attack of the Skeuomorphs

Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced when computers first became mainstream in the post-war decades. In this article Joe Celko looks at the history of mainframes, FORTRAN I and COBOL.   Read more...
By Additional Articles 2015/07/24 | Source: SimpleTalk | Category: joe celko
Rating:  Rate this |   Briefcase | 3,197 reads

SQL Explained

A short explanation and infographic of what SQL is. For the non-SQL people in your life.  Read more...
By Additional Articles 2015/07/24 | Source: Other | Category: sql
Rating:  Rate this |   Briefcase | 5,228 reads

Is It Worth Writing Unit Tests?

What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.  Read more...
By Ed Elliott 2015/07/23 | Source: | Category: unit testing
Rating: |  Discuss |   Briefcase | 5,217 reads

Large SQL Server Database Backup on an Azure VM and Archiving

For a large SQL Server database on an Azure VM, backing up the data can have some challenges. In this article, Murshed Zaman focuses on the two most common challenges: size and speed.  Read more...
By Additional Articles 2015/07/23 | Source: SQLCAT | Category: azure vm
Rating: (not yet rated)  Rate this |   Briefcase | 3,742 reads

Free webinar: Embracing DLM – The Definitive Guide

Database Lifecycle Management (DLM) is about enabling rapid, risk-free database development and deployments. However, the most effective DLM processes actually reach beyond the database. Embracing the full scope of it can be daunting, so Grant Fritchey and Matthew Skelton are making it manageable.  Read more...
By Additional Articles 2015/07/23 (first published: 2015/07/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,506 reads

Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and ClosingPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/07/22 | Source: | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 2,416 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Excel Services in Power BI

**Information current as of 7/22/2015** There’s lots of exciting news this week with Power BI so expect several short blog posts...  Read more...
By Devin Knight 2015/07/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,402 reads

Without Borders – Getting Involved

One of the things I enjoy about the SQL community is the many people that you come into contact with....  Read more...
By CYates 2015/07/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads
Question of the Day

Size of view

By Karthik Babu 2015/07/27 | Category: views
Rating: (not yet rated) |  Discuss |   Briefcase | 770 reads

What will be the output of the below query where vwShowConsolidatedReport is a non-indexed view?

sp_spaceused [vwShowConsolidatedReport]  
Top Members (last 30 days)
# Name Score Level
30 days All-time
Rajan Patel
623 651 SSChasing Mays  
Iwas Bornready
519 4928 SSCarpal Tunnel  
482 482 SSC-Addicted  
meena.ramamani 93602
373 936 SSC Eights!  
Piotr Ryszkowski
309 2123 SSCrazy  
Latest forum posts