Tags » SQL Server 2008 R2

High Level Steps for Sql Server Cluster Installation

Quick one today:

Surprisingly, we’ve been doing a lot of Sql Server Cluster installations in the last few weeks/months. This is a handy chart, helpful to showcase the steps at a VERY high level. 120 more words

DBA

Find fragmentation and if the table/index is partitioned

select DB_NAME(a.database_id), OBJECT_NAME(a.object_id), i.name ,i.index_id,index_type_desc,index_level, case when p.partition_number <> 1 Then ‘1’ else ‘0’ end isPartitioned,
avg_fragmentation_in_percent,is_unique,is_disabled,
page_count,avg_fragment_size_in_pages,a.partition_number
from sys.dm_db_index_physical_stats (DB_ID(),object_id(‘NameOfTable’),NULL,NULL,’LIMITED’) a
join sys.indexes i on a.object_id=i.object_id and a.index_id=i.index_id… 51 more words

Sql Server SQL XML DML: How to INSERT a new node or update value in non-existing node.

Quick one today:

Continuing the series of posts on XML DML, today, we’ll look at updating/replacing value in an non-existing node (or INSERTing a new node into an existing element). 419 more words

DBA

Sql Server SQL XML DML: Update or replace value in empty node

Quick one today:

Continuing the series of posts on XML DML, today, we’ll look at updating/replacing value in an empty node.

In the past two posts, we saw how to update (or replace ) values in XML nodes. 357 more words

DBA

Sql Server : Replication : Length of LOB data (65536) to be replicated exceeds configured maximum 131072. The statement has been terminated

Quick one today:

Every once in a while, this error pops up in production environments, usually after application software upgrade. Error message looks something like this: 203 more words

DBA

How to recover sysadmin access to SQL Server 2005/2008 R2 when sa password is lost

 

  1. Open the SQL Server Configuration Manager tool
  2. Navigate to SQL Server Services and Stop the SQL Server Instance that needs a sa password reset …
  3. 161 more words
Microsoft

Sql Server : Active/Active, Active/Passive what do they mean? Terminology confusion.

Quick one today:

For many years, we’ve heard Active/Active & Active/Passive terms in the context of Failover Clustering; They have an implied understanding of what each means. 166 more words

DBA