Microsoft SQL Server Archives

Apr 11

Replication Slow at Subscriber Due to Missing Indexes

By Lori Brown | Helpful Scripts , Indexes , Replication , SQL Server

Problem Have you ever had transactional replication mysteriously start showing significant latency at a subscriber server? If so, check to see if the primary keys from the publisher database are missing on the subscriber database! Replication was showing long latency while the publisher and subscriber servers were not heavily utilized. Microsoft generated stored procedures that […]

Aug 01

Monitoring Log Shipping Using T-SQL

By Lori Brown | Log Shipping , SQL Administration , SQL Server

Log Shipping has been around a long time and it looks like it will continue to be useful and therefor supported. Since I still find Log Shipping being used, let’s talk about a T-SQL way to monitor it.

Apr 18

And Now a Couple of Job Queries

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 […]

Mar 07

Should I Replace My FOR XML PATH String Merges with String_agg?

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 […]

Feb 14

Are All Delimited-String Parsers Created Equal?

By 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 […]

Oct 18

Find Out Which Databases Have Multiple Files

By 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 […]

Oct 04

Failed In-Place Upgrade – Missing Backup Directory

By 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 […]

Sep 20

SSRS – Keep Column Headers Visible

By 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 […]

Sep 14

Finding Table Defaults, Primary and Unique Keys and Foreign Keys with sp_helpconstraint

By 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 […]

1 2 3 … 17 Next »

Tag Archives for " Microsoft SQL Server "