By Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server
Hooray!! We finally have our 70-764 and 70-765 certification exams done and can turn our attention back to blogging more regularly. Those exams were pretty tough mostly because there was a lot of information that had to be memorized since there are always aspects of SQL that we don’t regularly use and there is no […]
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 | 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 | 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