July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Function Property – Deterministic or Non-Deterministic

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
I recently received question through email that how to determine if any user defined function is deterministic or non-deterministic? First go through two articles I have written about deterministic and non-deterministic function. SQL SERVER – Deterministic Functions and Nondeterministic Functions SQL SERVER – 2005 – Use of Non-deterministic Function in…
Read More

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL System Table
What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for any blog or online community. Recently many readers have contributed their suggestions and script to this blog. Joffery has provided nice script which is modification to previous article of…
Read More

SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Stored Procedure
Christopher Miller read article of SQL SERVER Database Coding Standards and Guidelines Complete List Download and came up with wonderful SQL Server Script to rename all their database constraint with more organized constraint names, which helps to easily identify the constraint database exist on. Christopher Miller – “When we submit…
Read More