This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent on...

SQL Azure is a Microsoft solution for relational database cloud computing.  It comes as part of the Azure platform.  As with the Azure...

In most sites I’ve been working at, developing Analysis Services solutions, most people were treating the Analysis Services server as a...

This article may be useful when you want to relocate your system databases to another disk on the same server (same instance).  There...

In the last 12 months, virtualization and cloud computing have become one of the hottest issues in the hosting world.  It started with...

One of the powerful tools that the DBA can use when tuning queries is the “sys.dm_exec_query_stats” dynamic management view. This view...

Problem I installed SQL server 2005 Developer edition with a named instance on my computer. I created a database in order to check some...

When I was young and free (and stupid, let’s be honest – we were all quite stupid when we were young and free), I dreamed about living on...

Overview Sometimes there is a need to rename a database.  There may be variable causes: Restoring/moving the database from...

Overview Partition views have been part of SQL Server since SQL Server 7.0, but the maintenance and benefits they provided were limited....