This paper discusses how to use SQL Server 2008 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers.
2008-11-14
2,699 reads
Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.
2008-11-13
11,451 reads
Details for those of you coming to PASS and looking to attend the SQLServerCentral.com party on Tuesday night.
2008-11-13
850 reads
In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.
2008-11-13
4,334 reads
When the database is small, developers often use built-in SQL Server tools and scripts to create the data model. However when the data model grows into an enterprise level data model with all of the associated complexities, the management and maintenance grow as well. So what options are available to manage and build the data model?
2008-11-13
3,240 reads
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
2008-11-13
147 reads
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
2008-11-13
132 reads
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
2008-11-13
128 reads
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,997 reads
Calling stored procedures from your application should be easy. Mark Frishman of ActiveDB talks about what he's done to help you build applications quicker.
2008-11-12
4,671 reads
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
Comments posted to this topic are about the item Local Agents
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers