Sites anglophones


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 …

SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip

Publié le 23 mai 2019 sur journey to sqlauthority
 

My most of the Comprehensive Database Performance Health Check consulting engagement I do are online and I enjoy working on them when I am at home office and I have multiple monitors. However, I often travel to the customer’s location when my cli …

Bloor scores SQL Provision 4.5 out of 5 for test data provisioning

Publié le 23 mai 2019 sur sqlservercentral.com
 

The post Bloor scores SQL Provision 4.5 out of 5 for test data provisioning appeared first on SQLServerCentral.

My classes have really sucked lately, and I apologize.

Publié le 22 mai 2019 sur brentozar.com
 

I teach my Mastering classes in a regular rotation: Mastering Index Tuning, then Mastering Query Tuning, then Mastering Server Tuning. I go 1-2-3 like that because they build on each other, and I repeat ’em over and over through the year so peopl …

SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression

Publié le 22 mai 2019 sur journey to sqlauthority
 

At midnight I got a call from a customer who earlier availed my service Comprehensive Database Performance Health Check. The issue which they were facing were sudden high CPU for their SQL Server. They sent me an SOS message for help and I responded. T …

SQL Server Subquery in Select Statement with Where Clause

Publié le 22 mai 2019 sur sqlservercentral.com
 

The post SQL Server Subquery in Select Statement with Where Clause appeared first on SQLServerCentral.

Monitoring your servers and databases with SCOM and SQL Monitor

Publié le 22 mai 2019 sur sqlservercentral.com
 

The post Monitoring your servers and databases with SCOM and SQL Monitor appeared first on SQLServerCentral.

9 Tips for Faster SQL Server Applications

Publié le 21 mai 2019 sur brentozar.com
 

Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start. Query Design Tips 1. Code for readability first. The e …

SQL SERVER – Difference Between Login Vs User – Security Concepts

Publié le 21 mai 2019 sur journey to sqlauthority
 

In the last 13 years of blogging, I have been asked this question again and again and so many times that I think if you wake me up in the middle of the night I can easily reply about the difference between Login Vs User – Security Concepts.Before …


Pages :