In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?
Moving databases is fairly simple, but when you move a system database, there are a few extra steps to follow. MVP Brian Knight walks us through how to move temdb in this video.
What would you do if you want to perform 15 to 30 lookups using the same reference dataset? This is how I did it...
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
Today many companies determine to publish their data on the Internet trying to expand their business and make their information more accessible. The IT industry proposes a wide range of original solutions for resolving data inconsistency problems that publishers inescapably face when exporting their data as they need to properly access, process and interchange large amounts of information mainly through the web.
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries
Comments posted to this topic are about the item The Service Name