SQL in the City Summits Down Under
The post SQL in the City Summits Down Under appeared first on SQLServerCentral.
Glenn’s Tech Insights For May 28, 2019
(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.
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
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
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)
The post Insert Statement Without Column List (BP004) appeared first on SQLServerCentral.
How to Reseed Your Identity Column Value in SQL Server
The post How to Reseed Your Identity Column Value in SQL Server appeared first on SQLServerCentral.
Ordering T-SQL Scripts with Git and PowerShell
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?
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
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
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 …