The Curious Case of… what is the wait resource (0:0:0)?
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
DBA Training Plan 8: What’s Inside Your Own Databases
In the last episode of the DBA Training Plan, we talked about what’s inside the MDF file: a series of pages that store a database’s tables. Now, it’s time to check out the contents of YOUR database to understand what’s using the …
SQL SERVER – Retrieving N Rows After Ordering Query With OFFSET
As many of you know my SQL Server Performance Tuning Practical Workshop was sold out for June and July. That was the primary reasons, I was not able to write blog posts based on questions received in an email. Today, we will see the solution to very in …
Data privacy. Don’t look forward. Look back.
The post Data privacy. Don’t look forward. Look back. appeared first on SQLServerCentral.
“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 …