The 5 First SQL Errors to Check For
Is your SQL query crashing? Nine times out of ten it will be for one of these 5 reasons!
2011-06-14
13,118 reads
Is your SQL query crashing? Nine times out of ten it will be for one of these 5 reasons!
2011-06-14
13,118 reads
Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.
2011-06-13
7,805 reads
What do SQL joins and the "teach a man to fish" Chinese proverb have in common? SQL joins, like regular expressions, are one of those commonplace programming tasks in which true success is entirely dependent upon your ability to conceptualize the outcome. Fail to do so and you'll likely wind up spending a few hours in a frustrating round of trial and error. Like regular expressions, the proliferation of online examples has actually contributed to the frustration, providing the equivalent of a day's worth of fish rather than the proverbial fishing pool.
2011-06-10
8,288 reads
2011-06-07
3,458 reads
If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to the more standard datatypes that were introduced in SQL Server 2008. Joe Celko explains why, and walks through some of the history of the TSQL way of storing and manipulating dates and times.
2011-05-25
3,801 reads
2011-05-24
3,046 reads
2011-05-17
3,169 reads
2011-05-11
2,889 reads
2011-05-10
3,124 reads
The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.
2011-04-28
3,328 reads
The post Analytics vs. Advanced Analytics appeared first on Joyful Craftsmen.
By Brian Kelley
Recently, on a post celebrating a female professional earning a significant achievement within the...
By Rob Sewell
Four of our favorite new themes.
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers