SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Merge Publication and Subscription in one database

  Hi I have a situation where I need to create a Merge Publication and Subscription in one database. …

  SQLback

  3 replies

  14 years, 2 months ago

  By: SQLback

• Dynamic Index Drop Create Script

  Morning All I have the following script so far to check for any indexes which have not been used in…

  Ant-Green

  1 replies

  14 years, 2 months ago

  By: Gail Shaw

• best auditing option

  what is the best auditing option available for SQL Server 2008. “If your actions inspire others to …

  Pyman

  1 replies

  14 years, 2 months ago

  By: SQLArcher

• Find all sql statements in a xaction which deadlocked from memory dump

  I want to find all sql statements in my deadlocked transaction using memory dumps. For more details…

  Nikhil Shikarkhane

  6 replies

  14 years, 2 months ago

  By: Nikhil Shikarkhane

• Uninstall SQL Server 2008 SSIS Service

  How can I cleanly uninstall SQL Server 2008 SSIS Service from our server ?

  LOOKUP_BI-756009

  6 replies

  14 years, 2 months ago

  By: SQLRNNR

• What are the technique to reclaim space on SQL 2005?

  Hi, Am new to MSSQL 2005, i've read some article about shrinking datafile which result as follow: S…

  Khinkin

  1 replies

  14 years, 2 months ago

  By: cindyaz

• how to tell that X index on X database is above 80% fragmented

  hi Friends, i need help on that X index on X database is above 80% fragmented.. here is my full req…

  madhuu1905

  5 replies

  14 years, 2 months ago

  By: Ninja's_RGR'us

• Went from a 3 file DB to a 6 file DB MDF,NDF

  Hello all, We migrated from an older server with 3 logical drives which had MDF, NDF1, NDF2 and ND…

  dbdmora

  3 replies

  14 years, 2 months ago

  By: cindyaz

• SQL service domain account as local admin group member ?

  Put service account as local admin group will save lots of permission issue , so. wondering besid…

  awu

  4 replies

  14 years, 2 months ago

  By: Welsh Corgi

• Migration

  Hi everyone, I'm planning to migrate 15 tables(really huge) from SQL 2000 to SQL 2008? Backup/Resto…

  sunny.tjk

  4 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• Heap Table

  Hi I know that Heap Table means table with No clustered Index.My question is if a table has only no…

  Akkare

  6 replies

  14 years, 2 months ago

  By: cindyaz

• Alert not firing

  Thanks in advance for any help on this!! I set up a performance alert to fire when the counter [Loc…

  heb1014

  1 replies

  14 years, 2 months ago

  By: heb1014

• Trying to find long-running jobs from dm_exec_requests, dm_exec_sessions and sysjobhistory - what a pain!

  I have been trying to come up with a script that detects long-running jobs (over a specified thresh…

  Marios Philippopoulos

  7 replies

  14 years, 2 months ago

  By: Marios Philippopoulos

• SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x59f6e189; actual: 0x59fae189). It occurred during a read of page (1:40) in database ID 22 at offset 0x00000000050000 in file 'd:\data\ms\sample.mdf'

  Hi All, One of our databases got corrupted. It is throwing following error: SQL Server detected a l…

  vamshikrishnaeee

  23 replies

  14 years, 2 months ago

  By: david.bradley

• SQL Memory question - Query plan cache and buffer pool

  Hi all I was recording plan_handles last night that were being used in TempDB with the hope I would…

  Kwisatz78

  6 replies

  14 years, 2 months ago

  By: Marios Philippopoulos