SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Violin Flash Memory Array

  Hi - Currently, I'm using a substantial number of FusionIO cards on our production environment. We'…

  cheshirefox

  1 replies

  13 years, 5 months ago

  By: sklinga

• multiple instance on same server?

  Hi, First I had installed one SQL 2K8 with default instance on server, I need installed one more na…

  SQL Galaxy

  5 replies

  13 years, 5 months ago

  By: Ant-Green

• TempDB Performance

  Hi All After searching online for troubleshooting TempDb contention issues, I found the following s…

  SQLSACT

  2 replies

  13 years, 5 months ago

  By: Suresh B.

• High Memory usage

  Hello, one of our Prod sqlserver is taking 6.5gb memory out of total 8gb of the system.It is 2008R2…

  DBA_007

  5 replies

  13 years, 5 months ago

  By: BrainDonor

• How to schedule a job to run a command once a month?

  Our vertex is installed on sql server 2008R2. Our security policy is that the password will expire …

  eileen.gu

  1 replies

  13 years, 5 months ago

  By: winston Smith

• Trace not grabbing database info

  I've been using the below script to create traces on SS 2005 and SS 2008 R2 servers. For some reaso…

  jeff.wenker

  3 replies

  13 years, 5 months ago

  By: jeff.wenker

• default database for a login

  Hi there some body dropped a database which was the default database for a specific login(a windows…

  pooyan_pdm

  25 replies

  13 years, 5 months ago

  By: pooyan_pdm

• VERY small Table, VERY poor performance

  I have a dba question regarding a small small table. Size is .008mb, 6 columns, 5 records total. Se…

  CptCrusty1

  3 replies

  13 years, 5 months ago

  By: Vikrant S Patil

• Alter table script

  In Microsoft SQL Server 2008 R2 Management Studio it's possible to generate scripts for a particula…

  Alberto Vásquez

  6 replies

  13 years, 5 months ago

  By: Alberto Vásquez

• model database stuck on Restore

  Last night my backups failed on my maintenance plan and looks like my Model database was corrupted.…

  gkuiper

  26 replies

  13 years, 5 months ago

  By: jalbertss

• Backing up 100 databases

  I'm using the below procedure to backup the databases. When I implemented this script, we have 5 da…

  Mani-584606

  2 replies

  13 years, 5 months ago

  By: David Benoit

• SQL Query Performance

  Hi All I want to investigate Query Performance on my SQL Instance I've been looking at the sys.dm_e…

  SQLSACT

  17 replies

  13 years, 5 months ago

  By: pooyan_pdm

• How to trouble shoot and restore the access?

  Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQ…

  nagkarjun1

  2 replies

  13 years, 5 months ago

  By: winston Smith

• Database corruption on a merge replication subscriber

  Merge replication is being used to provide inter-site high availability for a 7*24 database with 99…

  FishNChipPapers

  3 replies

  13 years, 5 months ago

  By: FishNChipPapers

• Full DB Backup of filestreamed database slow after restart

  Dear all, I have a database on SQL Server 2008 R2 enterprise edition whose backup suddenly running …

  arr.nagaraj

  2 replies

  13 years, 5 months ago

  By: winston Smith