Administering

• Topics

  Started by

  Posts

  Last post

• What are the minimum events and fields I need to capture to find the cause of log growth ?

  Experts, One of our database log grows to huge size, which is unexpected. I would like to run a ser…

  Joy Smith San

  9 replies

  14 years ago

  By: Joy Smith San

• Database Growth

  Hi experts, Is there any way to find out the database growth for the last month even if i dont have…

  VastSQL

  6 replies

  14 years ago

  By: vikingDBA

• Compatibility Levels

  I have a DB with an uwanted compatibility level. The quickest way to determine if its associated ap…

  Lippy

  2 replies

  14 years ago

  By: Lippy

• Any clustering experts out there who can advise.

  We have a SQL geo cluster. 1 Node at Site A and 1 node at Site B Site C is where we have a file ser…

  ybol

  2 replies

  14 years ago

  By: Perry Whittle

• PLE

  Page life expectancy drops frequently with a value less than 300 secs. Does it mean that memory nee…

  Admingod

  9 replies

  14 years ago

  By: SQLQuest29

• SQL Server having high RESOURCE_SEMAPHORE_QUERY_COMPILE waits

  Hi, I've read http://jefferytay.wordpress.com/2011/02/16/sql-server-having-high-resource_semaphore_…

  Little Nick

  1 replies

  14 years ago

  By: yelouati

• tracking data changes

  Hi, How can I tell which user inserted or updated data in a table? Is that possbile i can know? Tha…

  imranx101

  2 replies

  14 years ago

  By: Elliott Whitlow

• SQL Documentation Tool

  What tools have you used to document SQL databases? I found this tool online: http://www.winnersht…

  Erin.

  11 replies

  14 years ago

  By: Z1024

• I deleted about 60 gigs from 4 history tables where does the space that I have cleared go?

  I deleted about 60 gigs from 4 history tables where does the space that I have cleared go? Does the…

  twdavis-893252

  1 replies

  14 years ago

  By: Gail Shaw

• Page level locking is disabled????

  Hello, Iam Getting an error while doing reindexing as below. Msg 2552, Level 16, State 2, Line 1 Th…

  madhu-686862

  16 replies

  14 years ago

  By: Gail Shaw

• Restore DB From Network Drive

  Hi All, I am trying to restore database from an backup file which is located on development server.…

  ningaraju.n

  9 replies

  14 years ago

  By: Ant-Green

• How to edit a report in "home" follder in reporting server.

  Experts, I may sound stupid. New to reporting services. I connected to one of the reporting server.…

  Joy Smith San

  12 replies

  14 years ago

  By: Joy Smith San

• SSRS 2005

  Hi, How I can give the access to reporting server for specific user to view/write reports ? Please …

  ravisamigo

  1 replies

  14 years ago

  By: MarkusB

• Linked server "Catastrophic failure"; Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "server_name"

  Hi, Some of the users report the following error message while using the openquery: Msg 7399, Level…

  sqlstart wannabe

  4 replies

  14 years ago

  By: Josh Turner-440822

• Time outs due to huge transactions?

  I am seeing a lot of these errors in one of the database production servers: Autogrow of file 'brid…

  Benki Chendu

  6 replies

  14 years ago

  By: Benki Chendu