Sites anglophones


SQL in the City Summits Down Under

Publié le 29 mai 2019 sur sqlservercentral.com
 

The post SQL in the City Summits Down Under appeared first on SQLServerCentral.

Glenn’s Tech Insights For May 28, 2019

Publié le 28 mai 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

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 …


Pages :