Tags » SQL Server 2008 R2

Sql Server : Query all the indexes or tables that are COMPRESSED

Quick one today:

How to get a list of objects (or indexes) that are compressed or have COMPRESSION enabled?

I frequently use the below script to get a complete list. 187 more words


Sql Server: Assign permissions on table TYPE to users

Quick one today:

How do we assign permissions on TABLE TYPEs to user accounts?

Earlier last week, this was a point that needed to be covered in our deployment code. 123 more words


Background Info (Part-1)

So before I start writing on SQL SERVER, here’s the outline of my plan.

  1. Less DML (Data Manipulation Language) commands, More on DDL(Data Definition Language) side.
  2. 138 more words
Adventure Works

Auditing SQL Server Database Engine changes for SharePoint 2013.

Why the hell would you audit SQL Server changes for SharePoint Server as there is a “don’t touch“policy. As a SharePoint administrator or database administrator you can’t directly write into a database. 700 more words

Gokan Ozcifci

RESOURCE_SEMAPHORE WAIT - Performance Troubleshooting

Recently I was involved in troubleshooting the performance issue. All the queries were running slow on SQL instance. Most of the queries usually complete in seconds and that day it was running more than 15 minutes and not return any output. 590 more words

SQL Server

Sql Server Error Messages : The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'

Quick one today:

Earlier last week, I was playing with one of our customer databases in our lab environment. As part of implementing table partitioning, some tables changes were necessary; Moving data from one set of tables to another. 203 more words