Sites anglophones


User-defined scalar functions suck – even when they don’t access data.

Publié le 28 mai 2019 sur brentozar.com
 

The performance of scalar functions sucks hard. Let’s see it in action using the Stack Overflow database – any size will work. I’ll set things up first in case you want to follow along: USE StackOverflow2013; GO ALTER DATABASE CURRENT …

SQL Server Plan Cache Limits

Publié le 28 mai 2019 sur SQLSkills.com - Erin Stellato
 

Last week on SQLPerformance.com I blogged about ad hoc workloads and how they impact performance, noting plan cache bloat, and I had a comment asking about SQL Server plan cache limits.  Kimberly mentions them in her classic post Plan cache and op …

SQL SERVER – An Index Reduces Performance of SELECT Queries

Publié le 28 mai 2019 sur journey to sqlauthority
 

Can an Index reduce the performance of SELECT Queries? Let me make this question a bit more complete –Can an Index reduce the performance of SELECT Queries even though that index is not used anywhere?If your answer is NO, well, continue read …

Insert Statement Without Column List (BP004)

Publié le 28 mai 2019 sur sqlservercentral.com
 

The post Insert Statement Without Column List (BP004) appeared first on SQLServerCentral.

How to Reseed Your Identity Column Value in SQL Server

Publié le 28 mai 2019 sur sqlservercentral.com
 

The post How to Reseed Your Identity Column Value in SQL Server appeared first on SQLServerCentral.

Ordering T-SQL Scripts with Git and PowerShell

Publié le 28 mai 2019 sur sqlservercentral.com
 

DevOps and Continuous Integration are dominant themes today, and Microsoft’s launch of Azure DevOps underscores their importance.  SQL Server DevOps is also contributing to expanded adoption of database source control systems, with the goal …

Do You Know What Secrets Your SQL Servers Are Sharing?

Publié le 27 mai 2019 sur sqlmag.com
 

Here’s how to check the current state of connections to the production SQL Server, what to look for and why.

5 Questions to Ask When You Upgrade SQL Server

Publié le 27 mai 2019 sur brentozar.com
 

Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you …

Recorded Class : Buy One Get One – SQL Server Performance Tuning Practical Workshop for EVERYONE

Publié le 27 mai 2019 sur journey to sqlauthority
 

This is a special offer to everyone who has been writing to me to give a discount on my recorded class SQL Server Performance Tuning Practical Workshop for EVERYONE. Well, here is good news. This is an offer of buy one get one for everyone who buys the …

The Sins of SELECT * (BP005)

Publié le 27 mai 2019 sur sqlservercentral.com
 

The post The Sins of SELECT * (BP005) appeared first on SQLServerCentral.

When was Table Accessed Last By User? – Interview Question of the Week #226

Publié le 26 mai 2019 sur journey to sqlauthority
 

Question: When was Table Accessed Last By User?Answer: Every time when I go to the Comprehensive Database Performance Health Check. One of the conversations which we usually do is about creating and removing the indexes. When I run my diagnosis scripts …

SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode

Publié le 25 mai 2019 sur journey to sqlauthority
 

I was in a situation where I was helping the customer to overcome a disaster. They had a hardware failure and the master database was corrupted. The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we wil …

SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name

Publié le 24 mai 2019 sur journey to sqlauthority
 

This was one of an interesting error which I received while preparing for a demo. I wanted to demonstrate a disaster recovery scenario by doing backup and restore. In this blog we would learn how to fix Msg 4353 – Conflicting file relocations hav …

Setting MAXDOP During SQL Server 2019 Setup

Publié le 23 mai 2019 sur brentozar.com
 

Just a short note – in SQL Server 2019, the setup process has a new MAXDOP tab: The hyperlink about MAXDOP configuration points here. I did a few quick test installs: 4 cores gave me a MAXDOP 4 8 cores offered MAXDOP 8 12 cores offered MAXDOP 6 H …

Query Store in SQL Server 2019 (CTP 3.0)

Publié le 23 mai 2019 sur SQLSkills.com - Erin Stellato
 

Friends, CTP 3.0 dropped today, and it includes some changes for Query Store in SQL Server 2019!  I am so excited!!  I’ve downloaded it and have WideWorldImporters installed and have a lot of testing planned, but if you’re impatie …


Pages :