Power and Deception of CTEs
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
2008-12-01
9,155 reads
T-SQL
2008-11-27
4,106 reads
2008-11-26
4,933 reads
The Numbers Table
Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.
2008-11-24
10,723 reads
2008-11-20
3,732 reads
2008-11-18
4,496 reads
2008-11-14
9,697 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,974 reads
2008-12-08 (first published: 2008-11-07)
446 reads
2008-11-06
4,053 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
Forums
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
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