SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,891,060 DBAs, developers and SQL Server users

Headlines today   September 19, 2017

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 320 reads

Searching and finding a string value in all columns in a SQL Server table

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".  Read more...
By Additional Articles 2017/09/19 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,335 reads

Benchmark your Database DevOps maturity level

Whether you’re only just starting to explore the advantages of DevOps or you’re already fully immersed in the journey, including the database brings additional advantages. Take a few minutes to complete our Database DevOps Maturity Assessment and you’ll better understand how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers.  Read more...
By 2017/09/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 994 reads
Previous headlines

The Instance ID MSSQLSERVER Is Already In Use

This article will explain how to fix "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE' Error.   Read more...
By Nisarg Upadhyay 2017/09/18 | Source: SQLServerCentral.com | Category: mssqlserver
Rating: (not yet rated) |  Discuss |   Briefcase | 579 reads

How to Drop All Your Indexes – Fast

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.  Read more...
By Additional Articles 2017/09/18 | Source: Brent Ozar Unlimited Blog | Category: drop indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,815 reads

Redgate wants your opinion

Have you tried or used SQL Prompt? Redgate is running some research on SQL Prompt pricing. Please help by filling in their short survey for the chance to win one of three licenses of SQL Prompt or a Redgate point-tool if your choice.  Read more...
By 2017/09/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,171 reads

A Pattern for Email Address storage and retrieval

Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently.  Read more...
By Jeff Reinhard 2017/09/15 (first published: 2015/09/24) | Source: SQLServerCentral.com | Category: email address
Rating: |  Discuss |   Briefcase | 6,902 reads

SQL Server R Services: Digging into the R Language

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.  Read more...
By Additional Articles 2017/09/15 | Source: SimpleTalk | Category: sql server r services
Rating:  Rate this |   Briefcase | 3,146 reads

Automate MSBI deployments Using PowerShell

There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.  Read more...
By Kunal Rathi 2017/09/14 | Source: SQLServerCentral.com | Category: msbi
Rating: |  Discuss |   Briefcase | 427 reads

sp_AllNightLog: Creating Jobs Like I’m The President

Erik Darling explains why sp_AllNightLog creates so many jobs by default.  Read more...
Rating:  Rate this |   Briefcase | 3,008 reads

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is...  Read more...
By Devin Knight 2017/09/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,381 reads

Dynamic Threshold for Statistic Update - SQL Server 2016

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...  Read more...
By 2017/09/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 888 reads
Question of the Day

Real Maths

By Mike Tanner 2017/09/19 | Category: operator precedence
Rating: (not yet rated) |  Discuss |   Briefcase | 586 reads

In mathematics, multiplication and division are said to be commutative, meaning that it doesn't matter which order the operation is performed in. 

The way SQL Server performs numeric calculations follows... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
74792 365921 SSC Guru  
Jeff Moden
65182 335607 SSC Guru  
Steve Jones - SSC Editor
40640 221594 SSC Guru  
Lynn Pettis
28837 148815 SSC Guru  
25793 121720 SSC Guru  
Latest forum posts