Tag Archives for " Lori Brown "

Index REORGANIZE Generates Out of Space Messages

By Lori Brown | Indexes , SQL Administration , SQL Maintenance , SQL Server

I was doing some performance analysis at a client where we captured a traditional SQL trace.  Our client has SQL 2016 Enterprise that is fully patched up and uses Ola Hallengren’s IndexOptimize (https://ola.hallengren.com/) stored proc to do nightly index maintenance.  While the index maintenance ran, we caught over a hundred thousand Error 1105, Severity 17, […]

Continue reading

Interesting New String Functions

By Lori Brown | SQL Development , SQL Server

Here are a few new string functions that I cam across while doing some research.  Just goes to show you that you learn something new every day! STRING_AGG (https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql) This function is available starting with SQL 2017. It concatenates values from rows and places your separator in between the values. Here I create a comma […]

Continue reading

How Enabling Change Tracking Can Cause Backup Failure

By Lori Brown | Backup and Restore , Helpful Scripts , SQL Administration , SQL Server

Recently I had a client who contacted me because all of the sudden the backup for a couple of databases started to fail. While those backups had been running successfully in the past they suddenly started failing with this message: With a little more digging he found more info. Here is more verbiage from the […]

Continue reading

Query to Get SQL Job Info from sysprocesses

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit

We recently were troubleshooting an issue where one client reported that the SQL instance was suddenly very slow. One of the things we do is check to see what queries are currently running in SQL by using the following query: — Finds info on queries that are running NOW SELECT GETDATE() AS CurrentTime, SUBSTRING(text, CASE […]

Continue reading

Large MSDB Database From sysmaintplan_logdetail Table

By Lori Brown | Advice , Beginner , SQL Administration , SQL Maintenance , SQL Server

I am recycling this blog post from 2015….”Why?”, you might ask…..Well, I am still running into instances with this exact issue. Soooo, here we go….again.  Enjoy. I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found […]

Continue reading

Get Index Column Info with Includes for One or Many Tables

By Lori Brown | Helpful Scripts , Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

I was recently working with one of my clients on some low hanging fruit type of query tuning. We had checked the cache for plans with missing index warnings in them and were trying to see if we could tweak and existing index or add a new index to speed things up. If you ever […]

Continue reading

Find Out Who Changed the Database Recovery Model

By Lori Brown | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server

I ran into a situation where we were working on a migration and had been directed to put all databases into FULL recovery model in anticipation of using log shipping to push databases to the new server. Once we are ready to go live on the new server the plan was to ship the last […]

Continue reading

Use MSDB to Get Database Backup Size and Total Time For Each

By Lori Brown | Backup and Restore , Beginner , Helpful Scripts , SQL Administration , SQL Server

We recently started using a third party software to do our in-house SQL backups so that the backup files are stored in a redundant and safe place. To confirm that the software was indeed compressing backups as it stated it would, we wanted to see what each backup size actually was in SQL so that […]

Continue reading

Installing and Connecting to SQL 2017 on Ubuntu (Linux)

By Lori Brown | Installation , SQL 2017 , SQL Administration , SQL Server

SQL Server 2017 is available as a CTP for testing (https://www.microsoft.com/en-us/sql-server/sql-server-2017) and is able to be installed on a system running Linux. Because I have done all of my professional work on Windows systems, the leap to a Linux system was a bit of a stretch. I learned that while Linux is the OS kernel, […]

Continue reading