SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Find the txt File size from SQL

  Hi, Please look into the following job. Which is failing at Step 2. Is there any alternate to find …

  Pulivarthi Sasidhar

  2 replies

  15 years ago

  By: Geoff A

• Identify duplicate indexes

  Hi! I hope you can help me out on this one. We have identified several indexes on the same columns…

  Håvard

  2 replies

  15 years ago

  By: Håvard

• Attach and Detach Database history

  Hi There, Is there any way I can find Attach and Detach Database history in SQL SERVER ? Actually …

  hemss007

  3 replies

  15 years ago

  By: hemss007

• SQL Server Error Log - A significant part of sql server memory has been paged out...

  Hello, I have been facing this issue since past few weeks. My SQL Server Logs show this message "A…

  Sachin Vaidya

  22 replies

  15 years ago

  By: getoffmyfoot

• Creating Clustered Index on SQL2008

  The DB table I ran this on has about 44,000,000 rows of data and already has 5 non-clustered indexe…

  MyDoggieJessie

  4 replies

  15 years ago

  By: paul.knibbs

• DMV Plan_Handle translation

  In SQL 2008, how can I get the "plan_handle" value listed below returned as a radable value? (the …

  Express12

  1 replies

  15 years ago

  By: Grant Fritchey

• Changing sql server default port caused reporting services to stop working

  Hello all, I recenty changed my sql 2008 r2 dev edition (64 bit) default port from 1433 to a difere…

  Low Rider

  1 replies

  15 years ago

  By: Geoff A

• Does Index rebuild re-insert rows?

  Hi everyone, We currently have a SQL 2008 Enterprise instance chugging along no problem. We recent…

  GabyYYZ

  5 replies

  15 years ago

  By: GabyYYZ

• Clustered Index - UniqueIdentifiers

  I want to change from UniqueIdentifier to VarChar and then update the existing Guid to a Numeric(te…

  digdave7

  9 replies

  15 years ago

  By: Johan Bijnens

• Problems uninstalling a clustered instance

  I upgraded a SQL 2005 named instance to 2008. After this succeeded, I started adding two other ins…

  WayneS

  2 replies

  15 years ago

  By: WayneS

• Maintenance plan error

  Hi all, I have a maintenacne plan that is doing backups of the logs (TRN) of the user databases eve…

  ico-601891

  3 replies

  15 years ago

  By: ico-601891

• Basic question - Where SSRS stores the data retirived from remote data source?

  Hi, I am kind of unsure that if I am connecting to a remote datasource to get the data for my repor…

  Sachin Vaidya

  1 replies

  15 years ago

  By: ben.rosato

• Security for Jobs Importing data betweenServers

  We have been running SQL 2000 for 8 years but just now moving over to SQL 2008. I have generated i…

  wawork

  1 replies

  15 years ago

  By: ben.rosato

• migrating from sql 2000 to sql 2008

  Hi all, i am planning to move a database from sql 2000 to SQL 2008. My question is can i just tak…

  BBSR

  13 replies

  15 years ago

  By: Nadrek

• Failover options

  Here's a situation: 2 sites, 1 primary and 1 backup. 1 unreliable, fairly slow connection between t…

  david_wendelken

  7 replies

  15 years ago

  By: McSQL