Category Archives for "SQL Administration"

Jul 19

How To Find the Objects and Columns a Stored Procedure or View Uses

By Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server

In my last post I covered finding objects that reference another object using the dmf, sys.dm_sql_referencing_entities.  (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ )  Now let’s reverse that and find what objects are referenced in stored procedures or views.  When updates are needed to business logic often that happens in these objects.  If the stored procedures or views are large with […]

Continue reading
May 10

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
Feb 08

Notification for Restored Database

By Ginger Daniel | Backup and Restore , Database Mail , SQL Administration , SQL Server

According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded (ahem…), or sometimes an organization simply does not have the financial resources to spin up separate servers for testing or development. Whatever […]

Continue reading
>