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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,911,432 DBAs, developers and SQL Server users

Rss
Headlines today   January 17, 2019

Getting started with SQL 2019 big data cluster in Azure

Installing and connecting to SQL 2019 big data cluster  Read more...
By Blesson John 2019/01/17 | Source: SQLServerCentral.com | Category: big data cluster
Rating: (not yet rated) |  Discuss |   Briefcase | 244 reads

Saving Data to Various Formats, Using SQL

You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.  Read more...
By Additional Articles 2019/01/17 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,034 reads

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Learn how to use T-SQL to fix contents of an XML document using FLWOR  Read more...
By Additional Articles 2019/01/17 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 1,473 reads
Previous headlines

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/01/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,359 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2019/01/16 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 81,613 reads

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.  Read more...
By Additional Articles 2019/01/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,621 reads

Implementing Stretch Database.

Learn how you can enable the Stretch Database feature in SQL Server 2016.  Read more...
By Deepak Prasad Sahu 2019/01/15 | Source: SQLServerCentral.com | Category: stretch database
Rating: |  Discuss |   Briefcase | 687 reads

New Preview of SQL Server Management Studio Available for Download

On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,247 reads

SQL Server Logical Reads – What do they really tell us?

SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading  Read more...
Rating:  Rate this |   Briefcase | 2,066 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/14 | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 231 reads
 

From the SQLServerCentral Blogs

PowerShell to Simulate Load

Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...  Read more...
By Grant Fritchey 2019/01/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,851 reads

Introducing ChaosLoad

Scripted Simulation of SQL Server Loads When blogging, presenting or testing an idea, one issue I constantly have is that my...  Read more...
By Gavin Draper 2019/01/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,832 reads
Question of the Day

Reducing the Identity

By Steve Jones 2019/01/17 | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 502 reads

If I run this code in SQL Server 2017, what happens?


CREATE TABLE dbo.SalesOrderHeader
( OrderKey INT IDENTITY(1, -1)
, CustomerName VARCHAR(30)
)
GO
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy')
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian')
INSERT dbo.SalesOrderHeader (CustomerName) VALUES...  Read more...
Latest forum posts