SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• excessive spids in msdb

  I have a server that has hundreds of spids connected to msdb that are sitting idle ( awaiting comma…

  rgretz

  4 replies

  10 years ago

  By: rgretz

• Database in use

  We have a weekly job that restores a database from a copy downloaded from a vendor. It occasionall…

  dan-572483

  11 replies

  10 years ago

  By: SQLRNNR

• Trying to restore a database with STANDBY/READ ONLY

  I have this database backed up as test.bak from primary server and want to restore on secondary ser…

  bubby

  5 replies

  10 years ago

  By: Gail Shaw

• How to control Deadlock?

  Hi There is one OLTP SQL Server 2008 database affected deadlock issues on daily basis.. Here I have…

  SQL Galaxy

  5 replies

  10 years ago

  By: SQL Galaxy

• DBCC REINDEX.. vs. ALTER INDEX ALL

  We use Ola Hallengren’s maintenance on all of our servers, which is a really nice, robust package. …

  chudman

  7 replies

  10 years ago

  By: Gail Shaw

• Encryption of the SQL Server objects

  Hi, I am a SQL DBA for the middle size Company in Florida. We are a software Company running SQL Se…

  AER

  2 replies

  10 years ago

  By: Lowell

• SQL Server SP upgrade

  SQL Server SP1 keeps coming up in my optional Windows Updates. SELECT @@VERSION returns: Microsoft …

  robin.pryor

  2 replies

  10 years ago

  By: george sibbald

• I cannot finish COUNT (*) query on a table with more than billion records.

  hi, I have a table in PRODUCTION server with more than a billion records. I am running the below qu…

  TJDBA

  8 replies

  10 years ago

  By: chudman

• Migrating from one server to another while keeping data on same Lun

  I am migrating a server instance from one server to another with much better hardware, while keepin…

  lyle.schow 28602

  9 replies

  10 years ago

  By: Perry Whittle

• CPU load history

  Is there a query to get CPU load history for the past 6 months or so for a SQL server? Thanks,

  ANn -425914

  1 replies

  10 years ago

  By: Eirikur Eiriksson

• LOG JOB FAILURE

  We have a log job that is scheduled to run every 15 minutes. This job uses red gate and has been fa…

  david.foli7

  1 replies

  10 years ago

  By: JeepHound

• SSMS Standard Reports Permissions - how to allow devs to view those?

  Is there a way to allow developers to view the Standard Reports in SSMS 2008 without granting them …

  Marios Philippopoulos

  4 replies

  10 years, 1 month ago

  By: SQLMan1

• Possible Corruption of SQL 2008 R2 Install

  I Cannot load sql server logs. I cannot even make an odbc connection to the box. From what I learn …

  Paresh Motiwala

  2 replies

  10 years, 1 month ago

  By: Steve Jones - SSC Editor

• sys.dm_os_buffer_descriptors and sys.dm_os_performance_counters

  Hi All, If I run the below query on my SQL 2008 server I get a result of: 2621440 SELECT cntr_value…

  PhilipRobinson

  1 replies

  10 years, 1 month ago

  By: zyzzxeosnar

• SQL Server 2008 R2 SP3 Upgrade Fail!!!!

  Hello Folks, Hope All Is Well! I am performing SP3 patching on SQL server 2008 R2 instance (hosted …

  lohithkschalam 92184

  1 replies

  10 years, 1 month ago

  By: Summer90