SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Learn SQL Server Administration

  Hi All I want to lear SQL Server Asministration, please guide me how can I achieve my goal in term …

  muzokh

  7 replies

  14 years, 2 months ago

  By: muzokh

• Copy only backups

  i am trying to restore a database which was taken using "copy_only". regular log backups were runni…

  Ry-SQL

  1 replies

  14 years, 2 months ago

  By: Devendrakumar

• install SQL server client managment studio, but also see integaration service as a shared feature

  I often need to install SQL management studio for people that need to query a production database. …

  sqlfriend

  14 replies

  14 years, 2 months ago

  By: Elliott Whitlow

• How a shrinkfile works in my database.

  Hi people, Thanks again for your time. I have a misconception about how SHRINKFILE works, i read t…

  islas.tonatiuh

  2 replies

  14 years, 2 months ago

  By: islas.tonatiuh

• Query

  I need a query to find out a user query which is utilizing the maximum memory/CPU usage.. Thansk fo…

  Mvs2k11

  6 replies

  14 years, 2 months ago

  By: Mvs2k11

• There is insufficient system memory in resource pool 'internal' to run this query.

  I'm getting the above error. We have a SQL 2008 server that has 3 databases on it. 1. IM (Compatibi…

  checkai

  3 replies

  14 years, 2 months ago

  By: Gail Shaw

• Unable to open or read TSX cache file - TSX Server

  I'm getting an error in the SQL Server Agent log when starting up the agent and haven't been able t…

  ImYourDBA

  1 replies

  14 years, 2 months ago

  By: okbangas

• Page verify - Backup with checksum

  We are in the process of migrate our SQL Server 2K to a new box with SQL Server 2008. We intend to …

  beppe_30

  9 replies

  14 years, 2 months ago

  By: Gail Shaw

• Missing Index suggested in execution plan even though index with same exact columns already exists!

  OK, this is weird. I was analyzing the cached exec plan of a stored proc and found this missing ind…

  Marios Philippopoulos

  4 replies

  14 years, 2 months ago

  By: Marios Philippopoulos

• Effect of .net on sql server

  Please let me know if we remove .net 2.0 from server then any effect on sql server 2005.

  asheesh pandey

  3 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• New application / database questionairre

  Our lucky DBA group gets to support a wide variety of 3rd party applications/systems in addition to…

  Pam Brisjar

  5 replies

  14 years, 2 months ago

  By: Pam Brisjar

• Graphical execution plan does not display in SSMS when clicking on plan hyperlink - instead I get the XML

  I am running a DMV query to get current activity on a server and, as part of that query, I get the …

  Marios Philippopoulos

  14 replies

  14 years, 2 months ago

  By: Marios Philippopoulos

• Splitting files

  We are going to migrate a SQL 2000 database to SQL 2008. There is a file used by this database that…

  sunny.tjk

  3 replies

  14 years, 2 months ago

  By: Johan Bijnens

• Query to find out the tables which have clustered and non clustered indexes

  Can someone please send me a query to find out the tables which have clustered and non clustered in…

  sunny.tjk

  1 replies

  14 years, 2 months ago

  By: Lowell

• how to exclude connections from a computer ?

  We need to stop connections from a web server, I just created a job running every minute to kill a…

  awu

  4 replies

  14 years, 2 months ago

  By: Nchax Phoku