SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server detected a logical consistency-based I/O error:

  I Checked the database in MS Query Analyser. I am getting the following error when trying to sort …

  charipg

  11 replies

  14 years ago

  By: Jo Pattyn

• Error 0xC0014049. Cannot find folder "Maintenance Plans\

  I am working with an existing MS SQL 2008 R2 Standard instance (10.50.2500) running on a Windows Se…

  murphyreedus

  8 replies

  14 years ago

  By: murphyreedus

• BCP Error

  Hello All, I am using the following link, to import the data from csv files to database. So, …

  DBA_Learner

  15 replies

  14 years ago

  By: Jared

• Measuring performance

  Hi, I m trying to analyze performance metrics on one of our servers. Basically we are planning to r…

  ssismaddy

  9 replies

  14 years ago

  By: ssismaddy

• Creating Credential for Proxy Account used to allow SQL Server Authenicated Users to Schedule SSIS Jobs

  I have three external users that are using SQL Server Authentication. They want to be able to creat…

  Welsh Corgi

  1 replies

  14 years ago

  By: Welsh Corgi

• Better Memory Utilization needed

  So I have some basic stored procedures that I can run which show me the seeks vs. scans on the inde…

  JDM623

  11 replies

  14 years ago

  By: JDM623

• Dependencies on a Column

  Hello Everyone I know that one can use sp_depends, sys.dm_sql_referencing_entities and sys.dm_sql_r…

  AndrewSQLDBA

  1 replies

  14 years ago

  By: AndrewSQLDBA

• production is slow than staging

  I have a database of 50 GB running on quad-core dual processor with 32 GB RAM. The application is r…

  irumman

  1 replies

  14 years ago

  By: Sean Lange

• Generate DDL of all objects to filr

  Subject should have been: "Generate DDL of all objects to file" Hi, I am trying to find a way to au…

  Rem70Rem

  8 replies

  14 years ago

  By: nthammareddy

• Sql Server 2008R2 installation...

  Hi, I want to know that is it possible to install sql server 2008R2 on windows ultimate? and what …

  bandarimohan 57273

  1 replies

  14 years ago

  By: Ant-Green

• Data File and Log File

  Hi I am newbiew to SQL server DBA. what does DATA FILE and Log File contains? What does Primary Fi…

  SQL_Surfer

  1 replies

  14 years ago

  By: Gail Shaw

• Log shipping Restore job failed

  Hi, Log shipping restore job failed with below message.We are using litespeed. Please advise 2012-…

  madhu-686862

  2 replies

  14 years ago

  By: Suresh B.

• log in to SSMS, only show database name

  We upgrade our SQL server windows operating system, and then I reattach the mdf files and ldf files…

  sqlfriend

  20 replies

  14 years ago

  By: george sibbald

• partitioning column

  What is meant by partitioning column? Can any one explain me I'm confused. Thanks, Raghu

  RaviShankar1234

  1 replies

  14 years ago

  By: Geoff A

• Management Studio - Maintenance Plan error

  I am trying to do some modification in SQL Server Management studio - Maintenance plans, but I am g…

  s*1918

  3 replies

  14 years ago

  By: s*1918