Sometimes you need to calculate a running sum. Uses of this include adding a Month-To-Date column to a query of recent orders. I haven't seen anyone publish how to do this before (using this method).This query works by using the Row_Number() function and recursive query capability of SQL 2005.
2007-07-16
541 reads
2007-07-16
2,263 reads
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
2008-05-09 (first published: 2007-07-12)
15,674 reads
Complex event processing (CEP) software delivers on the promise of real-time insight, but is the technology too green for mainstream success? CEP was once available only to big financial institutions and government agencies that could afford custom development projects. That's no longer the case, as off-the-shelf products and implementations have proliferated.
2007-07-10
1,831 reads
Robyn Page and Phil Factor almost dispel the myth that XML is boring, with their radical new SQL Server XML workbench.
2007-07-06
3,684 reads
Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance.
2007-07-04
3,635 reads
The interest in dynamic data warehousing (DDW) is growing significantly. A sure sign that the virtual brand has reached take-off speed is claims by bloggers that they did not get enough credit for coining the concept, viral brand or idea. For example, Dan Linstedt recently went on what he described as a "rant" about "dynamic data warehousing."
2007-07-03
2,137 reads
Are you taking care of yourself as an IT professional? We try to cover all aspects of your SQL Server career here, not just the technical stuff. Longtime SQL Server guru Michael Coles brings us some health tips in an interview with Dr. Jerry Sanders
2008-05-23 (first published: 2007-07-02)
9,801 reads
The script is in three parts:1. A select statement to determine the number of duplicate records contained within the table2. The deduping process builds a temporary table called #Duplicates and uses it to compare duplicates across both similar tables whilst deleting records with multiple counts3. Final test of deduping with no records indicating table is […]
2007-06-27
388 reads
The SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Microsoft® Exchange Server 2007 and Microsoft SQL Server™ 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications so that the data appears as if it were stored in SQL Server. As you will see, this creates some exciting development scenarios.
2007-06-22
1,640 reads
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
Comments posted to this topic are about the item The AI Bubble and the...
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers