In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.
2008-03-26
3,950 reads
This article is to discuss a number of important cluster Group and Resource properties that have significant impact on failover behaviors.
2008-03-25
6,563 reads
This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.
2008-03-25
21,105 reads
Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
2008-03-25 (first published: 2007-04-12)
9,940 reads
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
40 reads
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
31 reads
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
38 reads
With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.
2008-03-25
2,032 reads
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2008-03-25
3,820 reads
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
2008-03-24 (first published: 2007-04-03)
10,150 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers