SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• List of features/ differences b/n 2k5,2k8, 2k8R2 for DBA

  please post the difference/new features/comparisions between SQL SERVER 2005,2008 and SQL SERVER 2…

  jamessdb

  3 replies

  14 years, 12 months ago

  By: cashmanifesto

• DBAs Change Management Best Practice.

  Hi All, I have to give presentation on DBAs Change Control Best Practice. Does anyone has any mater…

  Imran-Yasir

  1 replies

  14 years, 12 months ago

  By: GSquared

• Hardware Specification or Proposal Document

  I'm putting together a hardware document for a new enterprise data warehouse environment I'll be bu…

  Ken Overton

  2 replies

  14 years, 12 months ago

  By: Ken Overton

• installing sql problem - it is stalled on "Generating Native Images"

  I'm installing a SQL Server 2008 Express instance on a demo machine, vista 64 bit, and during the i…

  jbennett-614925

  2 replies

  14 years, 12 months ago

  By: jbennett-614925

• Create partition on a table with difference in partition key and primary key

  Hi All, Can we create a partition on a table which is having primary key different and partition ke…

  roshanmaugustine

  1 replies

  14 years, 12 months ago

  By: nigelrivett

• IO Statistics

  I am trying to produce some IO statistics for one of my SQL Server DBS. For that I am using the fol…

  Minnesota - Viking

  2 replies

  14 years, 12 months ago

  By: Minnesota - Viking

• 2 processors, 4 cores but 8 threads

  Hi all Our new environment has 2 processors each of which are quad core. When I went to the server…

  Kwisatz78

  12 replies

  15 years ago

  By: Derrick Smith

• Migrating from SQL Server 2005 standard to SQL 2008 Enterprise

  Hi We are planning to migrate our SQL Server 2005 standard version to SQL Server 2008 Enterprise in…

  lenrigby

  1 replies

  15 years ago

  By: Meet George Jetson

• Disabling Adhoc Distributed Quries

  I am asked by the security team to disable the ad hoc distributed queries option.But i have the tra…

  AK1516

  1 replies

  15 years ago

  By: Lowell

• How do I connect to SQL Server remotely ?

  How do I connect to SQL Server remotely and administer my datbase objects? I have an installation …

  SQL006

  8 replies

  15 years ago

  By: Greg Edwards-268690

• sys.configurations not showing 'common criteria compliance enabled' row

  I recently discovered an oversight in my knowledge of SQL Server security (I am still a neophyte): …

  johnzabroski

  3 replies

  15 years ago

  By: johnzabroski

• Open DTS packages in SQL Server 2008 R2

  I am trying to open SQL Server 2000 DTS packages in SQL Server 2008 R2 but I keep getting the error…

  sduduzo02

  3 replies

  15 years ago

  By: Henrico Bekker

• SSPI Handshake error

  Logon Error: 17806, Severity: 20, State: 2. 2010-10-12 04:00:09.99 Logon SSPI handshake fail…

  zeenister

  9 replies

  15 years ago

  By: chetanr.jain

• Error: 17806, Severity: 20, State: 2.

  Logon Error: 17806, Severity: 20, State: 2. SSPI handshake failed with error code 0x8009030c while …

  Minto Minto(quendans)

  1 replies

  15 years ago

  By: Meet George Jetson

• SQL Server Row based compression

  Hi we want to upgrade our system from sql server 2005 to sql server 2008. we have some large sized …

  ocolakoglu

  8 replies

  15 years ago

  By: SQLBalls