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,812,912 DBAs, developers and SQL Server users

Rss
Headlines today   July 6, 2015

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: SQLServerCentral.com | Category: soundex
Rating: |  Discuss |   Briefcase | 1,511 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: SQLServerCentral.com | Category: temporal tables
Rating: (not yet rated) |  Discuss |   Briefcase | 1,376 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 | 700 reads
Previous headlines

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: SQLServerCentral.com | Category: performance dashboard reports
Rating: |  Discuss |   Briefcase | 14,938 reads

Press Release: Redgate brings expert SQL Server training to London and Seattle

Cambridge, UK, 2 July 2015 – Redgate, the SQL Server and .NET software company, returns to London and Seattle in October with its enormously popular training event, SQL in the City.   Read more...
By Press Release 2015/07/03 | Source: Redgate | Category: redgate software
Rating: (not yet rated) |  Discuss |   Briefcase | 332 reads

Data Load Optimisation using the SSIS Balanced Data Distributor

Optimize SSIS data loads using parallel processing and the Balanced Data Distributor  Read more...
By Adam Aspin 2015/07/02 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 3,434 reads

How to Fix a Corrupt MSDB SQL Server Database

Keep reading and you will see that there is another way to rebuild the msdb database without compromising the master database.  Read more...
By Additional Articles 2015/07/02 | Source: MSSQLTips.com | Category: msdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,440 reads

Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.  Read more...
By Perry Whittle 2015/07/01 | Source: SQLServerCentral.com | Category: high availability
Rating: |  Discuss |   Briefcase | 1,697 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2015/07/01 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 61,030 reads

Survey: Development and Test Databases

Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.  Read more...
By Additional Articles 2015/07/01 (first published: 2015/06/26) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,401 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Database Drops in SQL 2012

In the previous article on this topic (which can be read here), I discussed the problem of having a database get...  Read more...
By Jason Brimhall 2015/07/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 551 reads

Download SSMS 2015 as a standalone download.... finally!

I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek Two...  Read more...
By g00p3 2015/07/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,389 reads
Question of the Day

integer lengths (II)

By Tom Thomson 2015/07/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 608 reads

The column J is declared as INT NOT NULL. In what circumstances will the logical expression

STR(J) = CAST(J as CHAR(10))
evaluate to TRUE? (Assume ANSI NULLS is ON and SQL Server 2014)
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Sowbhari
420 1818 SSCommitted  
2.
Jeff Moden
305 37867 SSC-Dedicated  
3.
JimmyJones
304 449 SSC-Addicted  
4.
sgmunson
290 2195 SSCrazy  
5.
Rajan Patel
271 285 SSC Veteran  
Latest forum posts