June 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 – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers. Hi Pinal, Recently,…
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