Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,878,425 DBAs, developers and SQL Server users

Rss
Headlines today   January 23, 2017

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.  Read more...
By Daniel Calbimonte 2017/01/23 | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 1,276 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU7 for SP3.  Read more...
By Steve Jones 2017/01/23 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 17,871 reads

Getting Started with R Services in SQL Server 2016 – Part 2

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.  Read more...
By Additional Articles 2017/01/23 | Source: Database Journal | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 1,554 reads

Need to run multiple scripts against multiple servers?

Let Chris Yates give you a quick overview of Redgate's SQL Multi Script to learn more about a quick and easy way to solve the problem.  Read more...
By Additional Articles 2017/01/23 | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,328 reads
Previous headlines

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2017/01/20 (first published: 2012/11/12) | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 51,522 reads

Development Delusions: That it is Enough to Build a Better Mousetrap

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.  Read more...
By Additional Articles 2017/01/20 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 1,797 reads

Keeping Fact Tables Online while Loading via Partition Switching

Provides overview of steps that can be used to keep fact tables online during loading process.  Read more...
By Shubhankar Thatte 2017/01/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 944 reads

What's New in Reporting Services 2016 Service Pack 1

SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.  Read more...
By Additional Articles 2017/01/19 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,148 reads

Free Webinar: An Introduction to DevOps

Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is to get started. Redgate have invited James Betteley, Head of Education at the DevOpsGuys, to run through the basics in this free webinar. Register now.  Read more...
By 2017/01/19 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,052 reads

Put your Database under Source Control

This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.  Read more...
By Thomas Liddle 2017/01/18 | Source: SQLServerCentral.com | Category: db source control
Rating: |  Discuss |   Briefcase | 770 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Power BI Subscriptions

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in...  Read more...
By Devin Knight 2017/01/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,006 reads
Question of the Day

right aligning

By Steve Jones 2017/01/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 677 reads

I have this table and want to right align the output with 2 decimals for each number. What should I replace the xxx with in my query?


DECLARE @t TABLE (mynum...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
3044 45386 SSC-Forever  
2.
Steve Jones - SSC Editor
1844 36320 SSC-Dedicated  
3.
GilaMonster
1675 47404 SSC-Forever  
4.
SQLRNNR
1042 21125 SSC-Insane  
5.
Koen Verbeeck
986 16522 SSCoach  
Latest forum posts