Administering

• Topics

  Started by

  Posts

  Last post

• URGENT: CPU 100% SQLSERVR.EXE but no high CPU process

  This morning on our production SQL 2005 9.0.3353 box it is running at 100% CPU. I have looked at sy…

  sotn

  10 replies

  13 years ago

  By: Ant-Green

• get total disk space per instance from within SQL without cmdshell.

  For policy reasons I can't enable cmdshell. I can get disk free space via xp_fixeddrives. But is i…

  snomadj

  9 replies

  13 years ago

  By: salimdkg4

• what is the use of dbo.dtproperties, can this be deleted?

  Hello, One of our customer is running a desktop utility that compares DB structure to the strucutur…

  asir83

  5 replies

  13 years ago

  By: asir83

• Help needed with analyzing this deadlock

  Hi all: Here is the output from the errorlog on a deadlock that occurred this morning: 12/04/2012 0…

  Del Lee

  2 replies

  13 years ago

  By: Del Lee

• Restore database without secondary datafile (.ndf)?

  I need to restore a database to a location that does not have enough space for the secondary data f…

  DKlein

  3 replies

  13 years ago

  By: George M Parker

• SQL SERVER LOCKING ISSUES

  I found a blocking issues using the DMV . [/url] from the captured result . I use DBCC IND('DBNAME…

  stanley_1982

  5 replies

  13 years ago

  By: homebrew01

• Checking for Available Disk Space (outside of SQL Server)

  We are running SQL Server 2005 SP4 on Windows Server 2008 R2 SE SP1 and Windows Server 2003 R2 SE S…

  HookSQLDBA7

  4 replies

  13 years ago

  By: HookSQLDBA7

• Increasing the size of the container

  Hello -- One of our systems is running SQL Server 2005, and has a database that was initially 'size…

  kaplan71

  6 replies

  13 years ago

  By: Chris Harshman

• Restore DB with actual data size

  Hi, I have a SQL Server database whose data files have been created with an initial…

  ArjunaReddy

  3 replies

  13 years ago

  By: baabhu

• Export SQL Server 2005 tables to text file

  I got a request to Export SQL Server 2005 tables to text file in the below format. Please let me kn…

  pawana.paul

  1 replies

  13 years ago

  By: pawana.paul

• SQL Server services failing

  Please assist my SQL Server service is failing to start after power cut. TITLE: Surface Area Confi…

  kapfundestanley

  3 replies

  13 years ago

  By: vivekinmadar

• SNAPSHOT Isolation with (NOLOCK) being used all over

  Recently, my applications architect decided that we needed to change the level of the database Isol…

  SQL_ME_RICH

  24 replies

  13 years ago

  By: SQL_ME_RICH

• Exporting SQL Job

  Hi, How to export SQL Jobs which under SQL Server Agent -> Jobs -> (All the jobs). Just want …

  New2SQL-343122

  7 replies

  13 years ago

  By: erikskinner

• Upgrade from SQL Server 2005 Standard to Enterprise

  Hi, Im having some problems with this, it is the first time im attempting to upgrade to a different…

  jenny 12957

  3 replies

  13 years ago

  By: Meet George Jetson

• sp_who2 output explanation pls

  Dear all, I would like be able to understand the meaning of a couple of values when launch sp_who2 …

  jamessdba

  1 replies

  13 years ago

  By: Bhuvnesh