SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• In Place upgrade rollback

  Hi - I will be performing an active/active in place upgrade from SQL 2008 to SQL 2012 in two nodes,…

  lsalih

  5 replies

  10 years, 10 months ago

  By: lsalih

• Unable to open the physical file

  I have a problem with two SQL Server 2008R2 SP3. I get the following error when i try to add a da…

  jayoub

  6 replies

  10 years, 10 months ago

  By: jayoub

• Do DDL triggers cause any considerable performance impact ?

  Hi, Do DDL triggers cause any considerable performance impact ? Thanks, Smith.

  Joy Smith San

  2 replies

  10 years, 10 months ago

  By: Gail Shaw

• Set up a linked server from SQL 2005 to 2008 Express

  I'm hoping someone can help with this because I'm stumped. I'm an experienced developer but only a…

  FunkyDexter

  1 replies

  10 years, 10 months ago

  By: Shafat Husain

• Changing NAME and IP ADDRESS of machine where SQL Server is hosted.

  Hi All, App team wants to change the NAME and IP ADDRESS of machine where SQL Server is hosted. Apa…

  Joy Smith San

  21 replies

  10 years, 10 months ago

  By: Perry Whittle

• Profiler Permission?

  Hi All, If I want to give the access the Profiler to a new login what Permission do i have to give?…

  Chowdary's

  3 replies

  10 years, 10 months ago

  By: Grant Fritchey

• Linked Server not reading

  All, I have a SQL job that reschedules month end jobs across 3 servers, 1 local, 2 remote. We've re…

  Brandie Tarvin

  3 replies

  10 years, 10 months ago

  By: Will Assaf

• VARBINARY(MAX) to XML

  I have a column in VARBINARY(MAX) and I want its data to convert it to XML Can someone please prov…

  Jai-SQL DBA

  3 replies

  10 years, 10 months ago

  By: spaghettidba

• Equal Data file size question.

  I have 3 data files on my database. 1. .mdf is 300 gb. 2. .ndf is 250 gb 3. .ndf is 75 gb all have …

  Tac11

  6 replies

  10 years, 10 months ago

  By: Tac11

• SORT_IN_TEMPDB with multiple Tempdb files

  I am with a dilema in using SORT_IN_TEMPDB in my indexes maintenance. It is because I have multiple…

  daniel_munhoz

  1 replies

  10 years, 10 months ago

  By: Grant Fritchey

• Put databases offline before applying Service Pack

  Hi there, My team is studying methods for faster patching ways in SQL Server (2008 R2, Enterprise E…

  Radiance

  8 replies

  10 years, 10 months ago

  By: Radiance

• Index Job (rebuild & Reorganize) and Log space used question

  Hi there, I have a Index job (reorganize and rebuild) runs every week, it generates 20-30 GB (accor…

  Tac11

  2 replies

  10 years, 10 months ago

  By: Tac11

• MSDB is growing larger than usual days--- MSDB is full log is 102% used spaces

  Reason in DBCC opentran is " WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue)…

  Saravanan_tvr

  2 replies

  10 years, 10 months ago

  By: Grant Fritchey

• Help on upgrade 32bit SS 2005 to SS 2008 R2 on a 64 bit machine

  Hi, I'm looking to upgrade 32bit SS 2005 to SS 2008 R2 on a 64 bit machine. Should I try and inst…

  mattech06

  3 replies

  10 years, 10 months ago

  By: mattech06

• 2005 to 2008 R2 upgrade hasn't upgraded 2005

  Hi there, I have a 64 bit os with a 32 bit 2005 ss and wanted to upgrade it to 2008 r2. After seeki…

  mattech06

  2 replies

  10 years, 10 months ago

  By: mattech06