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,451 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)
966 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,270 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,714 reads
2009-12-30 (first published: 2009-12-15)
1,044 reads
Blogs
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Forums
Transactional Replication from Read replica
If I have Read replica (in Azure SQL MI), can it be used as...
SQL availability group and file server role answering from the same name
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers