Administration

• Topics

  Started by

  Posts

  Last post

• DBCC FREESYSTEMCACHE equivalent?

  Some 3rd party app ran a monster select query that took 51Gb of tempdb space in internal objects. T…

  spaghettidba

  5 replies

  14 years, 12 months ago

  By: spaghettidba

• performance issue

  On one of the prod servers(2000), app owners faced acute slowness wherein the server took ages to r…

  ps.

  5 replies

  14 years, 12 months ago

  By: ps.

• SQL server 2000 RAM limitations.?

  Hi, I have SQL server 2000 Enterprise edition SP4 32- bit OS:Windows server 2003 Enterpri…

  kriss_mk77

  3 replies

  14 years, 12 months ago

  By: Joie Andrew

• Dynamic disk expansion

  Hi list, I am running MS SQL Server 2008 Standard Edition on Hyper-V machine with windows server 20…

  Niyala

  7 replies

  14 years, 12 months ago

  By: Joie Andrew

• Running Enterprise Manager on an XP workstation

  I have SQL 2000 running on my server. It is part of an installation that was completed before I ca…

  vavfam

  1 replies

  14 years, 12 months ago

  By: Joie Andrew

• deadlocks

  Hi, Yesterday and today, users complained that they couldnt connect to one of the servers. i was a…

  ps.

  5 replies

  14 years, 12 months ago

  By: Evil Kraig F

• Any known issues with SQl Database on Dynamic Disk drive configuration?

  Are there any known issues with putting SQL databases on Dynamic drives??

  Aseda

  2 replies

  14 years, 12 months ago

  By: balosatom

• Email Notification job step failed

  Hi all, I have a job that runs several jobs it notifies me when the jobs have finished running but …

  tt-615680

  3 replies

  14 years, 12 months ago

  By: Joie Andrew

• Memory for SQL Server low in Task Manager

  Windows Server 2003 Enterprise SQL 2000 Enterprise Edition SP4 8GB Physical Memory When looking at …

  SuzDBA

  3 replies

  15 years ago

  By: Adiga

• Request for health check Script

  Hi, Please give me a scirpt for SQL server 2000 health check report. Thanks in advance ananda

  SQL Galaxy

  3 replies

  15 years ago

  By: Steve Jones - SSC Editor

• what is the effect of job category

  Hi what is the different if i make my sqlserver agent job as a realtime or daemon or uncategorized…

  bassem_farouk

  2 replies

  15 years ago

  By: bassem_farouk

• Table - UnusedSize

  Hi I checked one of the table its contain lot of unused free space as below details tablename - KW…

  SQL Galaxy

  3 replies

  15 years ago

  By: Tom Goltl

• BAckup job getting failed

  The job getting failed everyday which is used to take Full DB backup with the below error. sqlmaint…

  gv.elaya

  2 replies

  15 years ago

  By: Meet George Jetson

• primary filegroup is full

  I was trying to make a change on data type of a column. I got an error the job is terminated becaus…

  SQL ORACLE

  4 replies

  15 years ago

  By: Steve Jones - SSC Editor

• SQL Server Agent - "1% is not a valid win32 application"

  Hi, when I click the button "start" in SQL Server Agent services, error message appears. Below is t…

  Nelson-502430

  6 replies

  15 years ago

  By: opch