Administering

• Topics

  Started by

  Posts

  Last post

• Urgent: How to shrink this huge DB?

  I inherited a bad designed DB with: 25GB mdf + 99GB ldf. As I know, most data are redundant and can…

  halifaxdal

  11 replies

  11 years, 11 months ago

  By: Jeff Moden

• Time-out occurred while waiting for buffer latch type 3 for page

  Getting this error message Time-out occurred while waiting for buffer latch type 3 for page (1:7381…

  MarvinTheAndriod

  9 replies

  11 years, 11 months ago

  By: Priz

• How can i find which tables are read/write intensive within sql server 2005

  How can i find which tables are read/write intensive within sql server 2005 Really would appreciate…

  dba_track

  4 replies

  11 years, 11 months ago

  By: dba_track

• NUMA Node

  Hi all, We have 16CPU servers. When i took a look at Errorlog log i have all this informational M…

  azhagumuthu

  12 replies

  11 years, 11 months ago

  By: Jeremy Brown

• What roles do I add to a new custom role, which will allow CRUD and execute on SP?

  I want to create a new, custom role to my databases, to which I'll add users. This role will allow …

  Rod at work

  8 replies

  11 years, 11 months ago

  By: Gail Shaw

• Creating a Loop to Iterate Through a SQL Table and Change Default Database

  Hello! I was wondering whether someone could help me with creating a loop to iterate through a tabl…

  Simbo_mk

  3 replies

  11 years, 11 months ago

  By: Lynn Pettis

• backup job failed

  Hi , my full,dataintegrity,index optimization jobs failed with the below error Ö Executed as user:…

  Lavanyasri

  5 replies

  11 years, 11 months ago

  By: Gail Shaw

• SQL SERVER 2005 STARTING PROBLEM

  Hai Every One. I am using SQL Server-2005. When i am trying to start my SQL Server(MSSQLSERVER) it …

  perireddy.arikatla

  3 replies

  11 years, 11 months ago

  By: Gail Shaw

• Index seek and Index scan ....order of columns

  Below is my query and i have two different NC indices. Now when i have the first index, below query…

  curious_sqldba

  5 replies

  11 years, 11 months ago

  By: Bhuvnesh

• Best Index Rebuild/Reorganize and Update Statistics Strategy

  I have a several databases in full recovery model around 200 GB. As soon I run maintenace plan, log…

  SQL_Surfer

  15 replies

  11 years, 11 months ago

  By: Jeff Moden

• How to change default database for multiple users (logins) at once?

  Hello! I am trying write a sql script to change the default database to master for multiple users a…

  Simbo_mk

  5 replies

  11 years, 11 months ago

  By: Simbo_mk

• Query two DB on same virtual server, Linked server?

  Hello all, I'm out of my depth here. Working for a small company that has two small databases on th…

  SQLKnitter

  8 replies

  11 years, 11 months ago

  By: SQLKnitter

• MAXDOP uses different settings?

  I have two servers each have CTP =5 and MAXDOP = 1. I have same query running on these two servers,…

  curious_sqldba

  5 replies

  11 years, 11 months ago

  By: Gail Shaw

• Set up jobs on SQL Server 2012 Servers in AlwaysOn configuration

  Hello everybody, I am a SQL DBA and need some help. We currently have two 2012 SQL Servers in High …

  AER

  2 replies

  11 years, 12 months ago

  By: AER

• Installation disc for MS SQL 2008 R2 DE from a downloaded ISO file

  How do I create an installation disc for MS SQL 2008 R2 DE from a downloaded ISO file?

  wippich.robert

  3 replies

  11 years, 12 months ago

  By: EdVassie