2007-10-25
3,892 reads
2007-10-25
3,892 reads
2007-10-24
4,723 reads
What is the best way to return the "duration" of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios?
2007-10-24
4,455 reads
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
2007-10-16
7,279 reads
This little script will search for all matching tables on the SQL Server instance
2008-07-30 (first published: 2007-10-15)
666 reads
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,619 reads
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
2011-09-29 (first published: 2007-10-11)
2,139 reads
Most DBAs don't ever deal with multiple languages or different collation and sort order settings in SQL Server, but it can be a handy piece of information to have. Steve Jones brings us a quick look at a problem in comparing data across databases.
2007-10-11
8,511 reads
2013-10-22 (first published: 2007-10-10)
30,168 reads
2007-10-08
4,283 reads
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
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