Sites anglophones

How to Run DBCC CHECKDB for In-Memory OLTP (Hekaton) Tables

Publié le 12 avril 2016 sur

tl;dr – run a copy-only full backup of the Hekaton filegroup to nul. If the backup fails, you have corruption, and you need to immediately make plans to either export all your data, or do a restore from your last good full backup, plus all y …

Splitting Strings in SQL Server 2016

Publié le 12 avril 2016 sur

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods

How to fix SQL Server deadlocks with monitoring

Publié le 12 avril 2016 sur

Learn about deadlocks and how you might better troubleshoot the issues involved.

The 2015/2016 Simple-Talk Awards: Winners Announced

Publié le 12 avril 2016 sur

The 2015/16 Simple-Talk Awards have concluded, the votes have been counted and recounted, and the winners have now been announced.

Server Sizing Comments: the case for 1-socket in OLTP

Publié le 12 avril 2016 sur

Long ago, almost 20 years, there was legitimate concern on whether servers had sufficient capability to drive transaction processing requirements for large businesses. Then for a long period, perhaps from the late 1990’s to 2012, the better choic …

Reasons to upgrade SQL Server

Publié le 12 avril 2016 sur

With SQL Server 2005’s extended support ending today, it seems appropriate to write a post about “My Favourite SQL Server Feature” for T-SQL Tuesday this month, hosted by Jens Vestergaard (@vestergaardj). The thing is that when I cons …

SQL SERVER – Drive Space Full Due to MDMP Files

Publié le 12 avril 2016 sur journey to sqlauthority

If you are a DBA and if you ever hear about drive space full issues on the SQL Server machine, the first thought to come to your mind would be “huge transaction log file”. Recently I have also fallen into the same trap. One of my clients co …

Tinkering with SSIS 2016 RC2

Publié le 11 avril 2016 sur

I’ve been testing SSIS 2016 as the CTPs (Community Technology Previews) and RCs (Release Candidates) have been made available. I’ve been most interested in changes to the SSIS Catalog. Getting RC2 running posed a couple challenges for me so …

[Video] Free Training of the Week: Dynamic Quorum and Dynamic Witness

Publié le 11 avril 2016 sur

In this week’s free video training sample, dig into the details of dynamic quorum and dynamic witness: what do they do? What’s strange about them at small node counts in a cluster? You’ll also learn how to configure quorum in three co …

NonClustered Index Structure

Publié le 11 avril 2016 sur

Learn how the clustered index keys affect the non clustered index structure.

Getting Started with Temporal Table in SQL Server 2016 – Part 1

Publié le 11 avril 2016 sur

With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how …

Podcast – Conversation With Author – Serving a Benevolent Master

Publié le 11 avril 2016 sur journey to sqlauthority

I had amazing fun time earlier last week when I was interviewed by prominent podcaster Dave Rael. He is amazing interviewer and knows how to get secret information from the people. He had asked me indeed very, very difficult question in the podcast. I …

Implementing SQL Server In-Memory OLTP

Publié le 11 avril 2016 sur

How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step …

What is ACID Property in Database? – Interview Question of the Week #066

Publié le 10 avril 2016 sur journey to sqlauthority

Today I want to take you all back to the one of the very original database interview questions and answer which I see often discussed in the interview. I have previously written about this ACID properties as well. In my career, I have seen 1000s of the …

SQL Saturday Silicon Valley

Publié le 9 avril 2016 sur

Network and learn the latest SQL tips and tricks Join other SQL Server and business intelligence professionals in Silicon Valley on April 9 for a free training and networking event on the Microsoft campus.  read more

Pages :