How do you tell if a user defined function is deterministic or non-deterministic? One OBJECTPROPERTY call with IsDeterministic gives you the answer.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
XQuery distinct-values: Deduplicate Atomic Values, Not Nodes
XQuery distinct-values removes repeated atomic values rather than selecting representative source nodes. I rebuild a small sorted XML result from repeated text. The example also keeps an empty document in view.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.
SQL SERVER – Create Database Error in Windows Vista
A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
ACOS: Check the Cosine Domain Before Calculating Angles
ACOS calculates an angle from a supported cosine ratio. Keep invalid and missing inputs visible while displaying valid radians at a chosen scale.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.