Some time back i had the requirement for a SP which will give non repeatable random numbers with in a range. Following SP accepts a range and gives the random numbers. Once the numbers are exhausetd NULL, will be the out put. In this case user can restart the random number generation by passing 1 […]
2007-06-20 (first published: 2006-03-29)
248 reads
I just saw a script on this site for object search across the db's. I have written an alternate version with sp_msforeachdb undocumented sp which is much simpler.This avoids a lot of code and dynamic sql.Replace "object_name" with the name of the object which needs to be searched across the databases.
2006-10-17 (first published: 2006-03-29)
186 reads
2006-05-17 (first published: 2006-04-25)
273 reads
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers