“But NOLOCK Is Okay When The Data Isn’t Changing, Right?”
I’ve already covered how NOLOCK gives you random results when you’re querying data that’s changing, and that’s a really powerful demo to show folks who think NOLOCK is safe to use in production. However, I’ve gotten a ques …
SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache
Earlier this weekend, I had an urgent product to help. One of my clients reached out to me as their application stopped running in the middle night on Saturday. The issue was indeed a strange one as they have very little traffic on weekends and particu …
An Intro to SQL Window Functions
The post An Intro to SQL Window Functions appeared first on SQLServerCentral.
How SQL Server monitoring benefits your whole organization.
The post How SQL Server monitoring benefits your whole organization. appeared first on SQLServerCentral.
How to Write in Text File from T-SQL in SQL Server? – Interview Question of the Week #236
Question: How to Write in Text File from T-SQL in SQL Server?Answer: The question above was actually asked in an interview and also was not asked in the same word. The actual conversation was on a very different topic.Recently I was hired by one of the …
SQL SERVER – DBCC CHECKDB WITH PHYSICAL_ONLY Failing and DBCC CHECKDB Succeeding – Bug
The other day, I was hired for the most strange issue I have encountered. One of my previous client of Comprehensive Database Performance Health Check recently reached out with a strange bug where DBCC CHECKDB WITH PHYSICAL_ONLY failed and DBCC CHECKDB …
Reporting Services Basics: Parameters
The series so far: Reporting Services Basics: Overview and Installation Reporting Services Basics: Creating Your First Report Reporting Services Basics: Data Sources and Datasets Reporting Services Basics: Parameters Adding parameters is one of the ess …
SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511
While performing an in-place upgrade from SQL Server 2014 SQL server 2016 my client faced an error. In this blog, I am going to share the cause and the solution of error Microsoft .NET Framework 4.0 installation has failed with exit code -2146498 …
Practical steps for end-to-end data protection
The post Practical steps for end-to-end data protection appeared first on SQLServerCentral.
Help! SQL Server 2008 is Still Here!
The post Help! SQL Server 2008 is Still Here! appeared first on SQLServerCentral.
What The Consultant Toolkit Does
It’s one thing for me to tell you how much easier The Consultant Toolkit makes my job and how clients love how much I can tell them about their server during the initial sales call – but it’s another thing to hear it from a happy cust …
SQL SERVER – Error 35296: Log Backup for Database “SQLAuthority” on Secondary Replica Failed Because the New Backup Information Could Not be Committed on Primary Database
One of my clients contacted me for whom I assisted in configuring Always On Availability Groups for the first time. They were getting an error whole taking log backup on secondary replica: Log backup for database “SQLAuthority” on secondary …
How to Unclog SQL Server
Not long ago, we were notified of a query timing out in an application after three minutes. We were consulted to help find out why. No, it was not SQL Server itself timing out, we explained. SQL Server doesn’t understand what a …
Polling and Survey Data Transparency
The post Polling and Survey Data Transparency appeared first on SQLServerCentral.
3 ways Managed Services Providers can offer more value
The post 3 ways Managed Services Providers can offer more value appeared first on SQLServerCentral.