Recorded Class : Buy One Get One – SQL Server Performance Tuning Practical Workshop for EVERYONE
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)
The post The Sins of SELECT * (BP005) appeared first on SQLServerCentral.
When was Table Accessed Last By User? – Interview Question of the Week #226
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
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
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
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)
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
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
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.
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
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
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
The post Monitoring your servers and databases with SCOM and SQL Monitor appeared first on SQLServerCentral.
9 Tips for Faster SQL Server Applications
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
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 …