By Jeffry Schwartz | Function , Performance Tuning , Query Tuning , SQL Development , SQL Server
If you are looking for major performance gains, the answer is no. However, if you are using SQL Server 2017 and developing new code, you should consider using the new String_agg function that is available on SQL Server 2017 because code that uses this function is so much more readable and easier to write and […]
Continue readingBy Jeffry Schwartz | Function , SQL 2016 , SQL Development , SQL Server
Overview In short, no. However, for many years there was no alternative to the T-SQL option, and even when there were other viable options, it was unclear whether it was worth changing existing code to take advantage of the new technologies. With the addition of the string_split function in SQL Server 2016, it is worth […]
Continue readingBy Ginger Daniel | Miscellaneous , Performance Tuning , Query Tuning , SQL Development , SQL Server
Jobs on a SQL server can take milliseconds or minutes to complete depending on the size and complexity of your query and also the SQL environment on which it’s executing. It’s important to have a baseline or at least be familiar with the normal amount of time your SQL jobs take to execute. For a […]
Continue readingBy Lori Brown | Helpful Scripts , Miscellaneous , SQL Administration , SQL Maintenance , SQL Server
This might be kind of basic but since I am working on a comprehensive script to discover things that a DBA really needs to know about, I made a couple of queries that will produce a list of the databases that have multiple files along with the locations of the physical files. One query finds […]
Continue readingBy Lori Brown | Installation , SQL Administration , SQL Server , Upgrade
I was recently performing an in-place upgrade of SQL 2008 R2 to SQL 2014 on one of my client’s servers. I have done a ton of successful and uneventful in-place upgrades and was surprised when the upgrade failed with the error message: “Failed to create a new folder ‘X:\SQLBackups’. The specified path is invalid (for […]
Continue readingBy Ginger Daniel | SQL Development , SQL Server , SSRS
When scrolling through the pages of a SQL Server Reporting Services (SSRS) report, it is very useful to be able to see the column headers throughout the report. So let’s say you have successfully created an SSRS report using Visual Studio, and everything looks wonderful…except the headers on your columns disappear when you scroll down […]
Continue readingBy Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server
A little while back I wrote a post going over sp_help in a beginning effort to find table dependency information. https://www.sqlrx.com/using-sp_help-to-find-object-dependencies/. That expanded to reviewing sys.dm_sql_referenced_entities & sys.dm_sql_referenced_entities (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ & https://www.sqlrx.com/how-to-find-the-objects-and-columns-a-stored-procedure-or-view-uses/ ) and sys.sql_expression_dependencies (https://www.sqlrx.com/using-sys-sql_expression_dependencies-as-a-single-source-to-find-referenced-and-referencing-objects/ ) Now I want to loop back just a bit and expand on more information that is found in sp_help […]
Continue readingBy Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server
I thought I would continue to expand on ways to view dependencies. This post will give you an alternate way to find things referencing tables and finding things that are referenced by a stored procedure or view after my previous posts on the subject. See these (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ & https://www.sqlrx.com/how-to-find-the-objects-and-columns-a-stored-procedure-or-view-uses/ ) A different way to find […]
Continue readingBy Lori Brown | Backup and Restore , Helpful Scripts , Log Shipping , SQL Administration , SQL Maintenance , SQL Server
I have a client that uses a lot of disconnected log shipping on a few servers. They do this because they want to have a copy of their database that is actually hosted by software vendors for reporting purposes. So, disconnected log shipping it is! We pull down files that have been FTP’d to the […]
Continue reading