2009-03-26
4,734 reads
T-SQL
Avoid Transact-SQL's Column Alias Limitations
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
2009-03-18
3,116 reads
2009-03-17
4,085 reads
2009-03-16
3,855 reads
2009-03-11
6,338 reads
SQL Server 2005 Paging – The Holy Grail
Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.
2010-05-08 (first published: 2009-03-11)
41,425 reads
2009-03-06
4,317 reads
2009-03-04
4,036 reads
The Safe and Easy Way to Delete All Data in a SQL Server DB
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
2009-03-03
4,786 reads
2009-03-02
4,288 reads
Blogs
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
MDX SSAS Calculated measure for last totals + turnovers
I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...
display bytea image
I moved a table from MsSql to Postgresql that had a field defined as...
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers