Lori Brown Archives - Page 2 of 9

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

Aug 23

Using sys.sql_expression_dependencies as a Single Source to Find Referenced and Referencing Objects

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

Aug 16

Find the Last Time Databases or Logs were Restored

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

Jul 26

How to Break an Existing Single Database File Into Multiple Files

By Lori Brown | Performance Tuning , SQL Administration , SQL Server

I occasionally come across some pretty good sized databases that are set up with a single data file. We recently have been working with a client to break up their single data file into multiple data files so that we can spread them over several different LUNs and so that they can take advantage of […]

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

Jul 05

Finding Things in SQL That Reference a Table

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

Have you ever been asked to make changes to a table that is used by other things/processes? One of the challenges is to figure out what will be impacted by the change. This way you can know what to check and test so that the change is rolled out with success. One good place to […]

Jun 14

Using sp_help To Find Object Dependencies

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

I have been working on some things lately that have required that I find objects with specific data types and collations and then find those objects dependent objects and anything else that uses those objects. My end goal was to ultimately create drop and create statements for the things I found since we were changing […]

Jun 08

Get a List of all SQL Instances on a Server

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

May 17

SSMS Shortcuts

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

« Previous 1 2 3 4 … 9 Next »

Tag Archives for " Lori Brown "