SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• What columns should be chosen when partitioning a table?

  Hello all, I am reviewing a table which get poor performance and has approximately 20GB of data. I…

  kwoznica

  17 replies

  15 years, 1 months ago

  By: Sioban Krzywicki

• Software to monitor databases by using query on multiple servers

  Hi everyone. I'm in a bad position, that our developers are making lots of software, which when the…

  michael-753984

  10 replies

  15 years, 1 months ago

  By: Steve Jones - SSC Editor

• Could not find database id 3

  I made a really n00b error on my SQL Server 2008 R2 installation. Instead of referring to the prop…

  JohnnyDBA

  3 replies

  15 years, 2 months ago

  By: chandan_jha18

• Can not create new database. Error: Could not obtain exclusive lock on database model. Retry the operation later.

  This server has very little activity. Does anyone know what would cause this error? Thanks! Michael

  maas149848

  2 replies

  15 years, 2 months ago

  By: chandan_jha18

• Slow Performance after side by side SQL Server upgrade from 2005 to 2008 R2

  Hi Experts, We have upgraded sql server 2005 enterprise edition to SQL Server enterpise edition R2 …

  Bipsy

  7 replies

  15 years, 2 months ago

  By: andrewkane17

• Missing options during upgrade?

  Hello, I'm tring to test the upgrade process to migrate from SQL server 2005 SP3 to SQL Server 2008…

  MikeRen

  3 replies

  15 years, 2 months ago

  By: MikeRen

• Maintenance Plan wont run from package

  Hi there, wondered if anyone could help me with a very frustrating issue: I have created a maintena…

  learningdba

  2 replies

  15 years, 2 months ago

  By: 456789psw

• Multi-instance SS2008 Enterprise and R2 Enterprise Memory Issues

  I have two instances on a win2k8 enterprise x64 box (virtualized). The default instance is 2k8 and…

  phoenixrisign1599

  5 replies

  15 years, 2 months ago

  By: Syed Jahanzaib Bin hassan

• Upgrade sql server 2005 cluster on win 2003 to sql server 2008

  AM I correct that I can upgrade a Windows 2003 SQL Server 2005 active passive cluster to SQL Server…

  timscronin

  1 replies

  15 years, 2 months ago

  By: ravikanth.

• Linked Servers

  I am aware that table Sys.SysServers gives us the list of all linked server on the particular serv…

  Bala'

  3 replies

  15 years, 2 months ago

  By: Bala'

• Role management via AD groups

  Hello, i managed to have an AD group controled access to my server. My only problem is the the set …

  Digeling

  1 replies

  15 years, 2 months ago

  By: Digeling

• HOW to use the FILENAME statement

  I am creating a data base and i am using the ON statement to create the logical name and i specify …

  mandycandy07

  1 replies

  15 years, 2 months ago

  By: george sibbald

• Unable to debug

  I have installed SQL Server 2008 Enterprise Edition. AM using it now but I am unable to create new …

  derejetaffese

  1 replies

  15 years, 2 months ago

  By: M&M

• How can a SQL AGent Job command call it''s own JOb ID?

  I"m trying to run a sql agent job that would pass it's own id in the stored proc as a parameter. Wo…

  sunshine-587009

  3 replies

  15 years, 2 months ago

  By: sunshine-587009

• Job failure - detailed description in email notification

  I have a user who needs to know the details if certain jobs fail; however we do not give him access…

  Shaira

  3 replies

  15 years, 2 months ago

  By: Shaira