Free eBook: SQL Server Transaction Log Management
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong …
SQL SERVER – Remove Duplicate Rows Using UNION Operator
In my earlier post on SQL SERVER – Delete Duplicate Rows, I showed you a method of removing duplicate rows with the help of ROW_NUMBER() function and COMMON TABLE EXPRESSION. In this post, I am going to show you a tricky method of removing duplic …
One Hundred Percent CPU
Raise Your Hand If You’ve ever wanted to play a prank on your co-workers, but just didn’t have a any ideas that didn’t involve exploding Hot Pockets. Now you have something even less safe than molten cheese squirts! A stored procedure …
Loading CSV Files Using Dynamic SQL
In this article, we will see of a quick way to load CSV files from a directory on your computer. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix t …
Azure SQL Database High Availability
Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high …
SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?
Earlier this week I had multiple engagements of Comprehensive Database Performance Health Check. While working with one of the customers we realized that when we query sys.databases for one of the databases, we always see column log_reuse_wai …
Power BI Introduction: Publishing Reports to the Power BI Service — Part 8
The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …
Free Training Classes for Those Who Give Back: Announcing our 2019 Scholarships
You work at a charity or non-profit, helping them make a difference with data. Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you’re a developer at a non-government organization …
Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters
In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.
Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
Avoid running out of Disk Space ever again using SQL Monitor
If your SQL Server runs out of disk space, and it is running a database for an enterprise’s trading application, then the company can’t take money until the DBA fixes the problem. In this article Tony Davis shows you how to avoid this scena …
SQL SERVER – Identifying Query Using TempDB
During the recent Comprehensive Database Performance Health Check we observed that the size of the TempDB is very big for our customer. The first question which they asked was if there is any way they can identify query using TempDB. We ran the fo …
Where is the Default Settings for Backup Compression? – Interview Question of the Week #191
Question: Where is the Default Settings for Backup Compression? Answer: I think before I continue more on this blog post, I must show you an image which has created this question. Please look at the following database settings screen. You can go t …
[Video] Office Hours 2019/09/12 (With Transcriptions)
This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on …
SQL SERVER – Monitor Estimated Completion Times for Backup, Restore and DBCC Commands
Earlier this week, we were fortunate to receive an amazing script to overview HADR / AlwaysOn Local Replicate server from SQL Server Expert Dominic Wirth. You can read the amazing script here: Scripts to Overview HADR / AlwaysOn Local Replica Serv …