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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,903,093 DBAs, developers and SQL Server users

Headlines today   June 22, 2018

SQL Server Restart or Cluster Failover Notification

How to create an automatic SQL restart or failover notification.  Read more...
By Lori Brown 2018/06/22 (first published: 2015/12/10) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 3,807 reads

In-Memory OLTP – Common Workload Patterns and Migration Considerations

In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads, users can also migrate Transact-SQL code to natively compiled stored procedures. This can provide additional performance gains. This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits. The paper also discusses considerations for migrating applications to In-Memory OLTP.  Read more...
By Additional Articles 2018/06/22 | Source: Microsoft MSDN | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 1,103 reads

Demoing Latch Waits with Stupid Tricks

Stuffing table variables with hard-coded values to demonstrate concurrency.  Read more...
By Additional Articles 2018/06/22 | Source: Brent Ozar Unlimited Blog | Category: latching
Rating: (not yet rated)  Rate this |   Briefcase | 1,104 reads
Previous headlines

Converting Trace to Extended Events

A walkthrough of a conversion of a SQL Trace setup to an Extended Event session.  Read more...
By Steve Jones 2018/06/21 | Source: SQLServerCentral.com | Category: extended events (xe)
Rating: |  Discuss |   Briefcase | 453 reads

In-Memory OLTP – SQL Server In-Memory OLTP Internals Overview

In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvements in performance, and reduction in processing time. Tables can be declared as ‘memory optimized’ to enable In-Memory OLTP’s capabilities. Memory-optimized tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures can be compiled to machine code for further performance improvements on memory-optimized tables. The engine is designed for high concurrency and blocking is minimal.  Read more...
By Additional Articles 2018/06/21 | Source: Microsoft MSDN | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 1,610 reads

SQL Prompt Hidden Gems: The SSMS Results Pane

Louis Davidson explores the hidden treasures within SQL Prompt right-click context menu when working in the SSMS grid format results pane.  Read more...
By 2018/06/21 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,102 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 2018/06/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 75,670 reads

Welcome to the new world of curating data, not owning it

Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describe the data in our care (or data-containing artefacts like columns, tables and databases) are no longer sufficient.  Read more...
By 2018/06/20 | Source: Redgate | Category: data privacy and protection
Rating: (not yet rated)  Rate this |   Briefcase | 1,624 reads

SQL Server Database Corruption Detection

How to detect DB corruption ASAP... 
By Pauline Xiong 2018/06/19 | Source: SQLServerCentral.com | Category: corruption
Rating: |  Discuss |   Briefcase | 794 reads

From the SQLServerCentral Blogs

Analyzing Feedback From Music City Tech 2018

I recently presented two sessions at Music City Tech and just received my feedback.  I got great feedback and looks...  Read more...
By Angela Henry 2018/06/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,095 reads

Moving to Azure: A change in processes – TSQL Tuesday 103

For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...  Read more...
By Kenneth Fisher 2018/06/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,890 reads
Question of the Day


By Junior Galvão - MVP 2018/06/22 | Category: arithmetic
Rating: (not yet rated) |  Discuss |   Briefcase | 441 reads

After executing the Transact-SQL code block declared below in Microsoft Managenent Studio 17.7, what happens?

Use TempDB
Declare @MyVariableNumeric1 Numeric(6,2),
@MyVariableNumeric2 Numeric(2,2)

Set @MyVariableNumeric1 = 100.2
Set @MyVariableNumeric2 = 2

Select @MyVariableNumeric1 As 'Value 1', @MyVariableNumeric2 As... 
Latest forum posts