SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SQL server agent restart by itself

  Recently we have two SQL servers 2008R2 (SP1) experiencing a random restart of SQL agent. We are s…

  sqlfriend

  2 replies

  13 years ago

  By: sqlfriend

• Getting Error when trying to start the SQL Agent

  I even tried manually through below command EXEC XP_SERVICECONTROL 'START','SQLSERVERAGENT' StartSe…

  bubby

  2 replies

  13 years ago

  By: Hemant.R

• Migraton of SSIS Packages

  Can any one give me the step by step process of how to migrate SSIS 2005 pakckages to SSIS 2008 pac…

  sri2015

  1 replies

  13 years ago

  By: Koen Verbeeck

• SQL 2008 R2 SSIS package execution using Proxy account

  Unusal issue during SSIS package execution using proxy account. I am guessing it is related to mem…

  Sam77

  1 replies

  13 years ago

  By: Koen Verbeeck

• another index question, large table indexing

  I've been looking for information on how to handle a large tables index. I haven't found a similar …

  Bill (DBAOnTheGo)

  7 replies

  13 years ago

  By: Bill (DBAOnTheGo)

• Filegroup and number of files per FG questions - Redesign of 2 TB DB with 2,000+ batches per second

  Hi all, We're currently under going an exercise to re-design the storage structure of our productio…

  jkelly95z@yahoo.com

  6 replies

  13 years ago

  By: jkelly95z@yahoo.com

• sys.dm_exec_query_memory_grants

  hello experts, got a server with 32GB of RAM, configured max memory as 28GB. with this query -->…

  Art-251407

  3 replies

  13 years ago

  By: Gail Shaw

• Error, not sure where to start: Attept to fetch logical page... failed. incorrect checkum

  i hope this is the right forum 😀 i've been going through my sql logs and have noticed that every 10…

  davidandrews13

  3 replies

  13 years ago

  By: Gail Shaw

• Reduce size of BAK file after deleting database table records?

  Hi All, Firstly wanted to wish everyone a Happy Christmas and I hope someone may be able to help m…

  craig.dixon

  6 replies

  13 years ago

  By: Perry Whittle

• Whydoes 'N before the WHERE value causes an Index SCAN

  Hello, I am trying to work out why an N' before the value in the WHERE clause would make a differen…

  uncle_boris

  8 replies

  13 years ago

  By: CapnHector

• What Metrics to you monitor on your SQL Server? And now often do you check?

  We use SQL Monitor to keep tabs on two of our bigger production servers, but given we have about 12…

  samalex

  3 replies

  13 years ago

  By: Grant Fritchey

• instance port number

  I have a SQl SERVER that has a default instance and a named instance. Do I have to configure the na…

  sqlfriend

  6 replies

  13 years ago

  By: sqlfriend

• service pack for analysis service

  We have an instance that has only analysis service installed. No database engine installed. How can…

  sqlfriend

  1 replies

  13 years ago

  By: sam-770000

• How did you accumulate and where do you keep your administration scripts (or other scripts for that matter)

  I have a question for the more experienced DBA's out there. im starting to develop queries and scr…

  CapnHector

  7 replies

  13 years ago

  By: CapnHector

• Restore master db using a red gate backup file

  I need to restored the master db file from one of my red gate backup files. I'd like to know the r…

  HildaJ

  6 replies

  13 years ago

  By: HildaJ