This procedure is intended for single column primary key relationships.First we will create two table functions. The first finds a list of all tables with their primary key columns. The second finds all existing foreign key relationships with their table and column names. Finally we find all tables with primary key column names that do […]
2007-02-26 (first published: 2006-11-17)
994 reads
Use this script to figure out the current age of a person or object. It also takes leap year birthdates into consideration. You can also use this to find out the age of something at a particular point of time.
2007-01-04 (first published: 2006-12-19)
226 reads
I find it so annoying to format dates. Sometimes I want to include the timestamp, but if it is a midnight time stamp, the time is irrelevant. Sending in a datetime will return either the date string or a date string with a timestamp up to the seconds with either AM or PM.
2007-01-02 (first published: 2006-12-20)
223 reads
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Comments posted to this topic are about the item It's Never Just One Thing
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers