Category Archives for "SQL Development"

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

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

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

Continue reading
Apr 19

Interesting New String Functions

By 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 reading
Dec 14

Rx for Demystifying Index Tuning Decisions – Part 8

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

Review Due to the holiday week, this part will be shorter than usual. In Parts 1 through 7 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, […]

Continue reading
1 2 3 4
>