SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• deadlock victim checking?

  Hi, first enable DBCC traceon (1204, -1), deadlock trace flag. I have tested deadlock victim manual…

  SQL Galaxy

  5 replies

  13 years, 3 months ago

  By: Gail Shaw

• Database going into suspected mode !!! Urgent

  Primary server databases are working fine but my secondary databases are going into suspected mode.…

  samsql

  5 replies

  13 years, 3 months ago

  By: samsql

• Index Rebuild Question?

  Hi All, I am doing some R&D on Indexes. I have a table as follows: CREATE TABLE SINGLEINTVARCH…

  SQL*

  1 replies

  13 years, 3 months ago

  By: Gail Shaw

• Reporting services+sharepoint

  I am using SQL Server Reporting Sevices 2008 R2, and is in SharePoint Integrated Mode, whenver tryi…

  pooyan_pdm

  4 replies

  13 years, 3 months ago

  By: saifbd3344

• Where to find SP2 for SQL Server 2008 R2 Avanced?

  Hello, I have the Advanced Services edition for SQL Server 2008 Express R2. I like to find the SP2 …

  pbyrum

  2 replies

  13 years, 3 months ago

  By: dan-572483

• REstore DB from Enterprise to Standered

  Hi All, I am trying to restore enterprise database (compressed) on standered edition, but I am not.…

  ARUN KUMAR AGUNURU

  3 replies

  13 years, 3 months ago

  By: Lynn Pettis

• Import data from a Source database which does not have the indexes.

  Hi, I am importing whole data (with out any where condition) from a database, and that database tab…

  SQL*

  3 replies

  13 years, 3 months ago

  By: Animal Magic

• Plan Cache Performance

  Hi All I'm using the below query to investigate plan re-use on my SQL Server How accurate are the c…

  SQLSACT

  13 replies

  13 years, 3 months ago

  By: pooyan_pdm

• Basuc question about High Availability solution.

  Hi, I am very new to the DBA scenarios, i am learning the things from the Online stuff. For high av…

  SQL*

  7 replies

  13 years, 3 months ago

  By: SQL*

• Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times

  Hello (SQL Server 2005) I have a problem with scheduling a Maintenance Plan (MP) with 3 subplans (S…

  j_wentu

  1 replies

  13 years, 3 months ago

  By: j_wentu

• How to setup TSX/MSX servers

  I manage a large number of SQL servers (~180) in a test lab environment. I have configured a Master…

  stiv

  1 replies

  13 years, 3 months ago

  By: aubrey_nicholson

• Delete files older than 5 days

  I would like to create a sql agent job to run operating system cmd, as a step for a job. I tried to…

  sqlfriend

  9 replies

  13 years, 3 months ago

  By: sqlfriend

• How to know the current settings for a server?

  How to know the current settings for a server for the following: Remove Builtin\Administrators from…

  nagkarjun1

  4 replies

  13 years, 3 months ago

  By: SQL Show

• Quick way to move a bunch of databases?

  I'm looking to move the database file location from one drive to another on my machine for about 20…

  Rob-350472

  14 replies

  13 years, 3 months ago

  By: Perry Whittle

• SAN LUN shared storage questions/discussion

  Another post got me thinking, so I figured I should post.... What do you think about SAN LUNs? My …

  scogeb

  2 replies

  13 years, 3 months ago

  By: david.ashby