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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,898,659 DBAs, developers and SQL Server users

Headlines today   March 21, 2018

Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.  Read more...
By 2018/03/21 (first published: 2015/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,385 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 2018/03/21 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 92,494 reads

Charles Bachman and Pointer Chains

Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.  Read more...
By Additional Articles 2018/03/21 | Source: SimpleTalk | Category: history
Rating: (not yet rated)  Rate this |   Briefcase | 1,049 reads
Previous headlines

Balancing Performance and Readability

Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.  Read more...
By Gary Pollock 2018/03/20 | Source: SQLServerCentral.com | Category: coding style
Rating: |  Discuss |   Briefcase | 639 reads

Different Ways to Import JSON Files into SQL Server

Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.  Read more...
By Additional Articles 2018/03/20 | Source: MSSQLTips.com | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,366 reads

Investigating problems with ad-hoc queries using SQL Monitor

There is nothing wrong with the principle of using ad-hoc queries; one can use them occasionally and perfectly legitimately. However, when ad-hoc queries run as part of a processes that does database operations iteratively, row-by-agonizing-row, they can be one of the most unremitting ways of sapping the performance of a SQL Server instance.  Read more...
By 2018/03/20 | Source: Redgate | Category: ad hoc queries
Rating: (not yet rated)  Rate this |   Briefcase | 1,764 reads

Set-Based String Splitting table function

Describe and provide a set-based method that takes a multiple character split term and returns as a table  Read more...
By bevan ward 2018/03/19 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,380 reads

Masking Dates in a Non-Production Database

All too often there’s a reluctance to use masked data since it’s perceived to be just X’s and N’s and therefore not useable. That’s not the case if you use Redgate’s Data Masker tool.  Read more...
By 2018/03/19 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,017 reads

What is the State of My Transparent Data Encrypted Database?

When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,539 reads

TEMPDB Enhancements in SQL Server 2016

TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.  Read more...
By Dharmendra Keshari 2018/03/16 (first published: 2016/04/13) | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 6,277 reads

From the SQLServerCentral Blogs

Which One is Better? IN or BETWEEN?

I just had an interesting case of performance tuning: a query with multiple predicates on a very large table. Something...  Read more...
By Guy Glantser 2018/03/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,813 reads

Extended Events File Initialization Failure

It should come as no surprise that I write a lot of articles about Extended Events (XE). This happens to...  Read more...
By Jason Brimhall 2018/03/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,268 reads
Question of the Day

Loading Data

By Steve Jones 2018/03/21 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 352 reads

I have data in a text file that looks like this. All spaces are single spaces.

GameDate Visitor Home VisitorScore HomeScore
20180315 Oklahoma URI 78 53
20180315 WrightState Tennessee 47 73
20180315... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
38134 625894 SSC Guru  
Jeff Moden
34632 575831 SSC Guru  
Steve Jones - SSC Editor
21747 372037 SSC Guru  
Grant Fritchey
17377 254878 SSC Guru  
Lynn Pettis
15131 254084 SSC Guru  
Latest forum posts