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

Headlines today   October 1, 2014

Stairway to AlwaysOn Level 2: Storage 101

level 2 of the stairway 
By Perry Whittle 2014/10/01 | Source: | Category: alwayson
Rating: |  Discuss |   Briefcase | 1,478 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/10/01 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 31,788 reads

Filling In Missing Values Using the T-SQL Window Frame

Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the 'Data Smear'. Do window functions make this easier, and what is performance like? Dwain Camps investigates.  Read more...
By Additional Articles 2014/10/01 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,955 reads
Previous headlines

Synchronize Salesforce with SQL Server using SSIS

Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.   Read more...
By Eric Madariaga 2014/09/30 | Source: | Category: integers
Rating: |  Discuss |   Briefcase | 3,347 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 52,169 reads

Webinar: 7 Steps to Build a Database Deployment Pipeline

Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.  Read more...
By Press Release 2014/09/30 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,065 reads

Change All Computed Columns to Persisted in SQL Server

Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.  Read more...
By Additional Articles 2014/09/30 | Source: | Category: change column
Rating: (not yet rated)  Rate this |   Briefcase | 4,073 reads

Removing SQL Server Management Data Warehouse (Data Collector)

Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.  Read more...
By Bruno Silva 2014/09/29 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 2,104 reads

You Can Still Vote for PASS

If you couldn't vote last week or didn't get a ballot, you still can. Please go to and learn more.  Read more...
By Steve Jones 2014/09/29 | Source: | Category: pass
Rating: |  Discuss |   Briefcase | 277 reads

Azure Diagnostics for Virtual Machines

Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.   Read more...
By Additional Articles 2014/09/29 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 4,559 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Database default locations

One of the options you had when installing your instance was setting some default file locations. Defaut data file locationDefault log...  Read more...
By Kenneth Fisher 2014/10/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,805 reads

Notes On Our First Student to IT Pro Seminar

This past week we did our first try at the Student to IT Pro Seminar, run concurrently with SQLSaturday Orlando....  Read more...
By Andy Warren 2014/10/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,666 reads
Question of the Day


By Steve Jones 2014/10/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 908 reads

If I have this data?

CustomerID   Sales
1            100
2            50
3            50
4            120
5            110

If I want to get the rankings of customers, and ensure that I get a rank of  each number,...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
888 888 SSC Eights!  
741 741 Right there with Babe  
591 3268 Hall of Fame  
412 609 SSChasing Mays  
347 347 Old Hand  
Latest forum posts