SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Memory estimate

  how do we estimate/calculate procedure cache usage

  mxy

  5 replies

  11 years, 8 months ago

  By: SQLBuddy123

• SQL Server is terminating because of fatal exception c0000005 Error

  Hi, I am getting the following error in two SQL Server 2008 servers[Production]. This happens usual…

  sram24_mca

  1 replies

  11 years, 8 months ago

  By: SQLBuddy123

• Clustered index rebuild failure?

  Last night I launched a clustered index rebuild on a huge table to put the index on a partition sch…

  dan-572483

  9 replies

  11 years, 8 months ago

  By: Gail Shaw

• Lazy CPUs ?? 7 Idle, 1 maxed out

  I've got a couple of long running SQL jobs going, and am getting "Lock request timeout period excee…

  homebrew01

  11 replies

  11 years, 8 months ago

  By: SQLBuddy123

• Log File keep on growing when any maintenance task carried

  I have database in Simple Mode on SQL 2008 R2, every time I index or carry maintenance on the datab…

  bubby

  14 replies

  11 years, 8 months ago

  By: bubby

• Sorting Records

  colleagues, I have tables similar to the table below and I want to sort the records according to Ch…

  vsamuel

  5 replies

  11 years, 8 months ago

  By: vsamuel

• CPU cycles

  Hi all, I just wonder if someone has experience with measuring CPU cycles regarding users or applic…

  gkramer 23701

  9 replies

  11 years, 8 months ago

  By: Jacob Wilkins

• Objects and Filegroups

  By joining sys.filegroups and sys.indexes on data_space_id, I can find the specific filegroup in wh…

  alex_pixley

  3 replies

  11 years, 8 months ago

  By: alex_pixley

• DB will become read only. We cannot make any modifications here, How to avoid this scenario

  Hello Folks, Suppose, there are 1 million records, if we insert all these records in the log file, …

  sankepalli

  6 replies

  11 years, 8 months ago

  By: SQLBuddy123

• Installing SQL Server 2008 R2 on Windows Server 2012

  Hi, I am trying to do an installation, but Windows Server 2012 requires that I install SQL Server 2…

  dajonx

  9 replies

  11 years, 8 months ago

  By: SQLBuddy123

• Trying insert long data into OLEDB to excel

  Hi, I am trying to insert data from SQL to excel destination,but I am getting error as below:I have…

  Arjun SreeVastsva

  3 replies

  11 years, 8 months ago

  By: MyDoggieJessie

• restore database from another database script

  I would like to set up automated job to restore a database from another live database nightly. I ca…

  sqlfriend

  2 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Partitioning Error

  Using SQL 2008 R2 Enterprise I am trying to partition a pair of existing 200 million row tables to …

  dan-572483

  4 replies

  11 years, 8 months ago

  By: Gail Shaw

• Performance issue with a single database

  Hi, Im using the SQL 2008 R2. Iam required to perform two tests on one of our database as anything …

  mJai

  12 replies

  11 years, 8 months ago

  By: Gail Shaw

• Cannot access default instance set up by previous owner of computer

  Hello, I first ran a search for on the Internet and then on SQL Server Central for this situation, …

  grantbanjo

  5 replies

  11 years, 8 months ago

  By: Lowell