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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,892,790 DBAs, developers and SQL Server users

Headlines today   October 24, 2017

Parameter Sniffing In Action

This article will demonstrate what is parameter sniffing and how can it can kill performance   Read more...
By Nisarg Upadhyay 2017/10/24 | Source: SQLServerCentral.com | Category: parameter sniffing
Rating: |  Discuss |   Briefcase | 211 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/24 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 290 reads

How to determine SQL Server database transaction log usage

One crucial aspect of all databases is the transaction log. The transaction log is used to write all transactions prior to committing the data to the data file. In some circumstances the transaction logs can get quite large and not knowing what is in the transaction log or how much space is being used can become a problem. So how to you determine how much of the transaction log is being used and what portions are being used?  Read more...
By Additional Articles 2017/10/24 | Source: MSSQLTips.com | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 451 reads
Previous headlines

Azure DWH part 19: Backup and Restore SSAS

In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.  Read more...
By Daniel Calbimonte 2017/10/23 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 165 reads

9 New Features with SQL Server 2017

Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.  Read more...
By Additional Articles 2017/10/23 | Source: Database Journal | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 3,265 reads

How Redgate use SQL Clone internally to provision databases

A common thread behind the software Redgate develop is a problem or issue they’ve come across in the software development process. They then adopt the software themselves, which gives us a real understanding of the features that need to be developed further. To gain a deeper insight into SQL Clone, this interview was conducted with Joseph Woodhouse, Redgate's IT Manager, to find out about how it’s being used to implement a new database provisioning process at Redgate.  Read more...
By 2017/10/23 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 707 reads

A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.  Read more...
By Porter James 2017/10/20 (first published: 2015/11/02) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 4,029 reads

Overview of Azure Data Lake

Azure Data Lake stores petabytes of data and analyzes trillions of objects in one place with no constraints. Data Lake Store can store any type of data including massive data like high-resolution video, medical data, and data from a wide variety of industries. Data Lake Store scales throughput to support any size of analytic workload with low latency. Read on to learn more.  Read more...
By Additional Articles 2017/10/20 | Source: Database Journal | Category: azure data lake
Rating: (not yet rated)  Rate this |   Briefcase | 2,089 reads

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...
By Paul Brewer 2017/10/19 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 632 reads

Simple SQL: Random Thoughts

How does one get a truly random sample of data of a certain size from a SQL Server database table. Well, there are simple non-portable tricks one can use, such as the NewID() function, but then refining those can be tricky. Take the Rand() function for a start. Can it really provide you with a truly random number? Why doesn't the TABLESAMPLE clause give you a set number of rows? Joe Celko scratches his head a bit, explains some of the issues and invites some suggestions and tricks from readers.  Read more...
By Additional Articles 2017/10/19 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,458 reads

From the SQLServerCentral Blogs

Non Profit Umbrella Org – Good Idea?

Note: Published too soon, so lots of edits from the first version. Sorry for any confusion. I had a question from...  Read more...
By Andy Warren 2017/10/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 228 reads

SQL Server: What will REPAIR do?

So I had a corruption issue and I was thinking about running repair but I wanted to know what would...  Read more...
By Arun Sirpal 2017/10/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 396 reads
Question of the Day

FORMATting dates

By Steve Jones 2017/10/24 | Category: format()
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

I've got a date that I want to format to look better for a client report. My intention is to get the date to just show the month name and...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
47450 418310 SSC Guru  
Jeff Moden
43679 384130 SSC Guru  
Steve Jones - SSC Editor
26853 251718 SSC Guru  
Grant Fritchey
19020 165075 SSC Guru  
Lynn Pettis
18627 169361 SSC Guru  
Latest forum posts