By Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
It is pretty common that I frequently am asked to take over a server with SQL on it sight unseen. Many times shops many not be fully aware if additional instances are or have been installed on their server. Since I am working on a set of scripts that we can use for discovery on […]
Continue readingBy Lori Brown | SQL Development , SQL Server
Thought I would post some quick helpful things like shortcuts in SSMS. There is a link to a comprehensive list of keyboard shortcuts for SSMS at the end of this post. There is more than just ctrl-c & crtl-v out there!! Here are my fav’s – https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts For more information about blog posts, concepts and […]
Continue readingBy 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 readingBy Lori Brown | SQL Administration , SQL Server
Tempdb is a system database used in SQL Server to hold 1) temporary user objects like temp tables and stored procedures, 2) internal objects like work tables used for sorting, and 3) row versions created from data modification transactions. When configuring a new SQL Server, the tempdb should be set to a size that will […]
Continue readingBy 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 readingBy 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 readingBy 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 readingBy 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 readingBy Lori Brown | ColumnStore , Miscellaneous , SQL Administration , SQL Server
I was recently looking at a way to easily identify if any objects in a database were In-Memory. Since many times I am tasked with taking on systems that I have never seen before, I have learned that it is important to have ways of checking to see if some of the more specialized features […]
Continue reading