Administering

• Topics

  Started by

  Posts

  Last post

• Querying results from reports

  Hi, Can someone advise me on this please. How we can query the results which returned by the report…

  ravisamigo

  1 replies

  14 years, 2 months ago

  By: LutzM

• sql server 2008 table partitioning

  I haven't had much experience with table partitioning in sql server in general. I'm looking for som…

  ericwenger1

  4 replies

  14 years, 2 months ago

  By: Gail Shaw

• truncate, drop taking exceptionally long

  I have a server, the ram is limited to 1GB. I'm sure this would effect the operation. I'm trying t…

  jshurak

  1 replies

  14 years, 2 months ago

  By: Grant Fritchey

• Determine last index rebuild or reorg

  Hi. Would sys.dm_db_index_usage_stats.last_system_update be the place to look for the last time an …

  ken.trock

  1 replies

  14 years, 2 months ago

  By: Gail Shaw

• question about unknown sa password

  I have an instance of SQL Server 2005 (9.00.3042.00) which I would like to patch up to Service Pack…

  Jpotucek

  5 replies

  14 years, 2 months ago

  By: Jpotucek

• Unable to perform a bulk delete of data from a table using datediff

  Can anyone help with the following. I have 2 servers. Server A and B running SQL 2005 standard with…

  AHWB

  3 replies

  14 years, 2 months ago

  By: Steve Jones - SSC Editor

• delete files from DOS

  Hi, I need to delete all the files from a directory named c:\sgrs except Rar files (Rar is the exte…

  river1

  6 replies

  14 years, 2 months ago

  By: river1

• SQL 2005 SP2 Database Mirroring

  I have a sql database mirror in place, I tried stopping the primary SQL Server and the Mirror SQL b…

  angel.fernandezj

  5 replies

  14 years, 2 months ago

  By: Gail Shaw

• Relation between Table Partition and Cluster Index

  Hi! I have a table SO_Orders and need to reduce Read I/O from this table. So I have decide table pa…

  Ramdas

  2 replies

  14 years, 2 months ago

  By: J.Yogesh

• Can we implement Clustered Index on Unique key ?

  Hi, Can we implement Clustered Index on Unique key ? If no... why ? Regards, Sachin.

  dsachu

  13 replies

  14 years, 2 months ago

  By: Ninja's_RGR'us

• Procedure cache with low memory size and low hit rate.

  I have a SQL Server 2005 64bit server running and it currently has a really low procedure cache hit…

  Derek Gemmen

  5 replies

  14 years, 2 months ago

  By: Rayven

• Not enough storage is available to complete this operation.

  Hi All, We moved the SCCM Application SQL Database to separate Server. One this activity has been …

  Jeetendra

  5 replies

  14 years, 2 months ago

  By: ChrisTaylor

• creating a new subscription in 2005 but getting following error Exception Message: The snapshot could not be generated because the publisher is inactive.

  I try to create new subscrition, and when I try to view snapshort agent status I am getting followi…

  MAK-1128556

  1 replies

  14 years, 2 months ago

  By: sharon-644450

• SQL2005 Express with Advanced Service SP4

  I have downloaded SQL 2005 Express Edition with Advanced Service SP4 (SQLEXPR_ADV) and tried to app…

  tyang

  3 replies

  14 years, 2 months ago

  By: Perry Whittle

• DTS package running under SQL 2000 not running as scheduled.

  I have a dts package that needs to run daily. The package just queries information from the databa…

  jasons 77446

  1 replies

  14 years, 2 months ago

  By: homebrew01