(Joe Sack) I was asked a few questions about the behavior of using “ALTER INDEX ALL… REBUILD” and thought I would detail my answers here… Quick background – using the ALL argument with ALTER INDEX REBUILD instead of naming a specific index allows you to specify all indexes associated with the table

(Pinalkumar Dave) This blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh. The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO.

(Sadequl Hussain) When an Oracle instance is created, it is nothing but a collection of some structured areas in the server’s memory and some background processes spawned to interact with it. Oracle literature quite extensively describes these memory structures and processes.

(Jugal Shah) Many times we get requests to migrate a single user database or multiple user databases to different server. At the time of migrating databases, there are chances that we can miss some important steps, for example trustworthy property, dependent jobs, linked server, logins etc. There ar

(Chris Skorlinski) When applying Snapshot across the network for Transactional Replication, network delays can have significant performance impact and increase time it requires to apply a Snapshot.

(Ashish Kumar Mehta) While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Object Explorer Details. Database Developers and Administrators can use Object Explorer Details to get a lot of useful information ab

(Michael M. David) The SQL-92 standard unknowingly and without planning introduced the capability to perform full hierarchical data processing with its introduction of the LEFT Outer Join operation. This natural hierarchical processing capability will be explained in this article.

(Don Jones) These days, the cloud is one topic that seems to be on everyone’s lips. There’s talk about email in the cloud, storage in the cloud, software in the cloud, and of course, SQL Server in the cloud.

(Amit Chaudhary) One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.

(Thomas Kejser) In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate the feature, here’s a bit of background about lock escalation and lock granularities.