(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
Tag: sql server
SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index
(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.
A High Level Comparison Between Oracle and SQL Server – Part II
(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.
SQL Server Database Migration Checklist
(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
Tips to improve performance when applying Snapshot in Transactional Replication
(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.
Using Object Explorer Details and Object Search Feature of SQL Server 2008 Management Studio
(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
ANSI SQL Hierarchical Data Processing Basics
(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.
When (and why) to move SQL Server to the cloud
(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.
SQL Server 2008 R2 Multi-server Administration – A First Look
(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.
Enabling Partition Level Locking in SQL Server 2008
(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.