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)
954 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,233 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,042 reads
Blogs
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
Forums
The Pervasive Nature of Open Source
Comments posted to this topic are about the item The Pervasive Nature of Open...
Migrating from SSRS 2008 (SP Integrated) to 2022 (Native)
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT *
FROM Sales.SalesOrderHeader AS soh
WHERE customerid IN (SELECT soh.CustomerID
FROM Sales.Customer AS C
WHERE soh.CurrencyRateID = 1
ORDER BY c.ModifiedDate)
See possible answers