June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation logo-sql08.gif SQL Server Technical Article Writers: Mark Theissen, Eric Kraemer Published: February 2009 To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,”…
Read More

SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, SQL Index, SQL White Papers
Partitioned Table and Index Strategies Using SQL Server 2008 Writer: Ron Talmage, Solid Quality Mentors Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft Greg Low, Herbert Albert – Solid Quality Mentors When a database table grows in size to the hundreds of gigabytes or…
Read More

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts
Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from…
Read More