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,813,319 DBAs, developers and SQL Server users

Headlines today   July 8, 2015

Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services

In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 198 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2015/07/08 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 61,093 reads

The Poster of the Plethora of PowerShell Pitfalls

One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.  Read more...
By Additional Articles 2015/07/08 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 336 reads
Previous headlines

Translating reports with Analysis Services and MS-Excel

Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment  Read more...
By Jan D'Hondt 2015/07/07 | Source: | Category: ssas
Rating: |  Discuss |   Briefcase | 2,495 reads

Temporarily Change SQL Server Log Shipping Database to Read Only

I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.  Read more...
By Additional Articles 2015/07/07 | Source: | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,050 reads

Monitoring Availability Groups with Redgate SQL Monitor

Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows you a technique for monitoring AG replication latency with Redgate SQL Monitor and its Custom Metric functionality.  Read more...
By Anthony Nocentino 2015/07/07 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 758 reads

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms  Read more...
By David Poole 2015/07/06 | Source: | Category: soundex
Rating: |  Discuss |   Briefcase | 2,551 reads

Learning About Temporal Tables

Learn about the new temporal table feature in SQL Server 2016  Read more...
By Site Owners 2015/07/06 | Source: | Category: temporal tables
Rating: (not yet rated) |  Discuss |   Briefcase | 2,326 reads

Getting to know your customers better – cohort analysis and RFM segmentation in R

It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range of analyses, and graphs, in order to ensure that you're answering the right question, to explore alternative hypotheses, or to provide insight into a problem. Feodor demonstrates how to quickly, and interactively, explore the ways that customers purchase goods and services using cohort analysis.  Read more...
By Additional Articles 2015/07/06 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 1,232 reads

A Quick Tour of the Performance Dashboard Reports

SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance.  Read more...
By Prett Sons 2015/07/03 (first published: 2013/06/11) | Source: | Category: performance dashboard reports
Rating: |  Discuss |   Briefcase | 15,827 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

How to Grant limited permissions to create views in another schema?

How to Grant limited permissions to create views in another schema? In SQL Server 2005 and 2008R2 you can grant permissions...  Read more...
By prakash karande 2015/07/08 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 146 reads
Question of the Day


By Shiva N (Virtusa) 2015/07/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 118 reads

What is the command to refresh the view?

Syntax: exec <below command> viewname

Top Members (last 30 days)
# Name Score Level
30 days All-time
429 1827 SSCommitted  
Jeff Moden
312 37876 SSC-Dedicated  
306 2211 SSCrazy  
298 450 SSC-Addicted  
274 42224 SSC-Forever  
Latest forum posts