SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Is it possible to reduce the unwanted Scan count and Reads in Tsql when Query Toggling happens

  The Problem : declare @toggling int = null Select * from Table1 a inner join Table2 b on a.id = b.…

  Saravanan_tvr

  2 replies

  13 years, 3 months ago

  By: Saravanan_tvr

• TCP/IP Error while restoring a Database through network

  Hi, I'm unable to restore a database through network. Server A: Host of backup copy.Hosted in 8 nod…

  Mac1986

  3 replies

  13 years, 3 months ago

  By: Gazareth

• How to change the SA login password using powershell.

  Hi Experts, I’m looking To Alter the SA logins in more than 50 MSSQL servers. Each server has diffe…

  Eswin

  3 replies

  13 years, 4 months ago

  By: raju400

• Add multiple users and give permissions to many databases

  Hi everyone. I have a list of logins that I need to add to SQL Server 2008. We need to give each o…

  PHXHoward

  9 replies

  13 years, 4 months ago

  By: Orlando Colamatteo

• what is CPU ? Physical or logical ?

  When SQL Server runs on a computer with more than one microprocessor or CPU, it detects the best de…

  awu

  2 replies

  13 years, 4 months ago

  By: Orlando Colamatteo

• Excessive recompiles

  I see several entries of "UPDATE MSDB.DBO.SYSJOBSCHEDULES SET NEXT_RUN_DATE = ...." in cache. You c…

  Venkat Satya

  5 replies

  13 years, 4 months ago

  By: Orlando Colamatteo

• Changing the clollation settings for MASTER DB

  Please tell me how to change the database collation settings for master DB

  santhosh411

  2 replies

  13 years, 4 months ago

  By: spaghettidba

• Join making conflict....

  SELECT @MSGOUT = @MSGOUT + ' <tr> <td>' + ss.ServerName +'</td> <td>' + ss.…

  Sgar...

  9 replies

  13 years, 4 months ago

  By: Sgar...

• Adding Secondary Data Files (ndf)

  I have a 310GB mdf for my warehouse database. I have just added three more data files to it in orde…

  Motomoto

  3 replies

  13 years, 4 months ago

  By: Gail Shaw

• SELECT @@ServerName returns Null after renaming a Server

  sp_dropserver <old_name>; GO sp_addserver <new_name>, local; GO Restart the instance of…

  Welsh Corgi

  4 replies

  13 years, 4 months ago

  By: Gail Shaw

• How to find last accessed date time of a SQL Server 2008 database?

  How we can find last accessed date time of a SQL Server 2008 database apart from using the DMV sys.…

  sqldba4u

  5 replies

  13 years, 4 months ago

  By: bassman7463

• overwriting backup devices in a maintenance plan

  Hi, I'm setting up a backup plan using UNC paths to a thecus drive. I plan to create a device for e…

  mjwlufc

  1 replies

  13 years, 4 months ago

  By: Michael Valentine Jones

• it's easy Not being able to enable AlwaysOn(how to enable the AlwaysOn??) - SQL 2012 Evaluation---WSFC HOTFIX KB 2494036

  Hi Friends, We're working on SQL server 2012 AlwaysOn Availability, but we're hitting an issue whil…

  Database admin(DBA)

  4 replies

  13 years, 4 months ago

  By: Perry Whittle

• Recovery Mode Simple when Mirroring Session Already UP SQL SERVER 2008

  Hi everybody, I didn't find any previous post about that point, so if there is already one, please …

  yannick.dinger

  2 replies

  13 years, 4 months ago

  By: yannick.dinger

• Index Design

  Hi All After reading a few articles on Clustered/NonClustered Index design, I want to comfirm my un…

  SQLSACT

  15 replies

  13 years, 4 months ago

  By: SQLSACT