Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,746,335 DBAs, developers and SQL Server users

Rss
Headlines today   September 2, 2014

Clustered Columnstore Index Gives "Unable to find index entry" Error

The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table  Read more...
Rating: |  Discuss |   Briefcase | 229 reads

Quick Survey: PostgreSQL in Your Organization

Do you use PostgreSQL in your organization? Are you thinking about using it? Take our short survey and tell us about what you think about it.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 407 reads

SQL Monitor Custom Metric: Time Since Last Restore

If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 302 reads

Implementing Azure Blob Storage (ABS) With SQL Server 2014

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.   Read more...
By Additional Articles 2014/09/02 | Source: Microsoft MSDN | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 271 reads
Previous headlines

Using the Script Task in SSIS to Process Data Files When They Arrive

Learn how you can process data files with SSIS as soon as they arrive using the Script Task.  Read more...
By Orlando Colamatteo 2014/09/01 (first published: 2012/10/25) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 21,703 reads

New toys in SQL Server 2012

In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.  Read more...
By Daniel Calbimonte 2014/09/01 (first published: 2012/05/15) | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 16,422 reads

More Text Analysis with the SSIS Term Lookup Component

As mentioned before, we will use the same use case in this tip as used with the Term Extraction component, which is an archive of all my tweets I've downloaded from Twitter. Using this archive and the Term Extraction transformation I found out which topics I particularly tweeted about in the past years or which persons I mentioned the most.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,905 reads

Data Mining Introduction Part 2

This is a continuation of first article about Data Mining. We will talk about decision trees.  Read more...
By Daniel Calbimonte 2014/08/29 (first published: 2012/12/31) | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 14,255 reads

A TDD Journey: 2 - Naming Tests; Mocking Frameworks; Dependency Injection

Test-Driven Development (TDD) relies on the repetition of a very short development cycle starting from an initially failing automated test that defines the functionality that is required, and then producing the minimum amount of code to pass that test, and finally refactoring the new code.   Read more...
By Additional Articles 2014/08/29 | Source: SimpleTalk | Category: tdd
Rating: (not yet rated)  Rate this |   Briefcase | 4,481 reads

Free SQL in the City Seminar Cambridge, MA – Oct 8, 2014

SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Cambridge this October in place of the NESSUG meet-up. Learn how to build an efficient development and deployment process for your organization. Register for this free event.  Read more...
By Press Release 2014/08/29 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,909 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be...  Read more...
By ArthurOlcot 2014/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 404 reads

I did my part – Helping others

Let’s raise some money, people. TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign. What started out as a joke...  Read more...
By Steve Jones 2014/09/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 212 reads
Question of the Day

Persisted Columns

By Steve Jones 2014/09/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 189 reads

I have a table in SQL Server 2012. 


create table MyTest
(id int
, first int
, sec int
, third as (first + sec)
);
go

I want to make my computed column (third)...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Eirikur Eiriksson
393 1777 SSCommitted  
2.
cruice
345 907 SSC Eights!  
3.
GilaMonster
324 42829 SSC-Forever  
4.
ben.mercer
317 344 Old Hand  
5.
crussell-931424
295 2677 SSCrazy  
Latest forum posts