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

Headlines today   March 22, 2018

The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS

This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.  Read more...
By SPT 2018/03/22 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: (not yet rated) |  Discuss |   Briefcase | 18 reads

How to Get a Random Row from a Large Table

Brent Ozar takes a look at four different ways to get a random row from a large SQL Server table.  Read more...
By Additional Articles 2018/03/22 | Source: Brent Ozar Unlimited Blog | Category: random data
Rating: (not yet rated)  Rate this |   Briefcase | 239 reads

5 Minutes with Fritchey

For quick information on various aspects of the Microsoft Data Platform and Redgate software, look no further than Grant Fritchey's Youtube channel. In addition to all the technical content, he also editorializes on various aspects of data and all things IT.  Read more...
By 2018/03/22 | Category: video
Rating: (not yet rated)  Rate this |   Briefcase | 196 reads

Registration is now open for Redgate's SQL Privacy Summit

The SQL Privacy Summit takes place on May 18, in London, and is an exclusive conference for senior IT data managers, responsible for data privacy and protection of SQL Server databases. You'll learn how Redgate's solutions help to ensure the ongoing protection of personally identifiable information (PII) in SQL Server, so that you can protect your business and comply with data privacy regulations such as the GDPR.   Read more...
By 2018/03/22 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 179 reads
Previous headlines

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,413 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,611 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,231 reads

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 | 641 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,440 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,837 reads

From the SQLServerCentral Blogs

Data experiments with salary survey – I

As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how...  Read more...
By Mala Mahadevan 2018/03/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 969 reads

Getting Started With R In SQL Server 2017

Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...  Read more...
By MarlonRibunal 2018/03/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 791 reads
Question of the Day

The DTU Counters

By Steve Jones 2018/03/22 | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 21 reads

Which counters do you capture on your on-premises SQL instance to help you estimate your DTU usage in Azure SQL Database?

Top Members (last 30 days)
# Name Score Level
30 days All-time
38574 626698 SSC Guru  
Jeff Moden
35053 576574 SSC Guru  
Steve Jones - SSC Editor
22080 372574 SSC Guru  
Grant Fritchey
17427 255176 SSC Guru  
Lynn Pettis
15352 254443 SSC Guru  
Latest forum posts