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

Previous headlines

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,840 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,496 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,431 reads

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 | 475 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,845 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,298 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,787 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,796 reads

SQL Server Database Corruption Detection

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

Question of the Day

Arithmetic

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

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

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

Set @MyVariableNumeric1 = 100.2
Set @MyVariableNumeric2 = 2

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