2011-12-13 (first published: 2010-05-05)
10,846 reads
Articles
Using Recursion and Date Tables to Simplify Date Logic
Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.
2011-12-13
11,616 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.
2011-12-13
5,779 reads
SQL Server Database Growth and Autogrowth Settings
It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What do I do about it? Read on!
2011-12-13
5,832 reads
Vote for SQL Bits 10
Voting is now open to choose the sessions you would like to see at the SQLBits Community Day on 31st March, 2012.
2011-12-13
4,630 reads
A C# toolkit for writing SSIS Script Tasks
This article demonstrates basic C# code that will enable SSIS package developers to write useful custom SSIS script tasks.
2011-12-12
22,960 reads
TSQL Challenge 71 - Play mangled words game in TSQL
Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.
2011-12-12
1,397 reads
Backup Verification: Tips for Database Backup Testing
A Backup system is merely part of a recovery system. If your backups can't be used to recover the database, then they're useless. Do you regularly make sure that you can restore a database from your backups?
2011-12-12
5,983 reads
Vote for the DBA in Space Finalists
There are 15 finalists in the DBA in Space competition. Cast your vote today, and every day, for the next 5 days to decide who is going into space.
2011-12-12 (first published: 2011-12-08)
3,372 reads
A brief explanation and solution for the Double Hop problem
What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?
2011-12-09
38,108 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers