datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,444 reads
William Talada
- Interests: non-dualism
Implementing Most Recently Used Lookups
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
955 reads
A Genetic Algorithm Sample in T-SQL
Bill Talada brings us an interesting use of T-SQL. Imagine you have a robot moving around a grid and it needs to complete various actions. How do you find the smart robots across many generations?
2010-01-14
11,237 reads
Validate Deployed Databases by Version
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
766 reads
2010-01-07 (first published: 2009-12-18)
1,711 reads
2009-12-30 (first published: 2009-12-15)
1,043 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...