Administering

• Topics

  Started by

  Posts

  Last post

• how to strore table backup on database

  Hi all, I have one database bank-db in that 10 tables are there i took backup out of 10 tables 2 t…

  rajeshn29.dba

  17 replies

  14 years, 7 months ago

  By: Welsh Corgi

• SQL 2005 - DTS - Run latest version as a Default

  We have an DTS with a number of versions. After making changes, I saved the package and it is the l…

  balasach82

  4 replies

  14 years, 7 months ago

  By: balasach82

• DBA Steps to Restore Database.

  Hi Can some one provide me a query for Steps 2,4,5,6?and Moreover if any suggestions for the below …

  Steve Dell

  2 replies

  14 years, 7 months ago

  By: matt.newman

• DTS Packegs migration

  Hi, I need migration DTS packages all from sql server 2000 to New sql server 2000 server? Totally 2…

  solomon.jernas

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• Does SQL Server issue when we shut down windows/SQL Server ?

  hi Does SQL Server issue CHECKPOINT when we shut down windows/SQL Server ? Thanks in advance.

  Joy Smith San

  4 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• Sharepoint deleting/dropping link to Data Source for SSRS reports

  Hi there, Has anyone ever receive this message on sharepoint. The report server cannot process the…

  sukruti.patel

  1 replies

  14 years, 7 months ago

  By: Brandie Tarvin

• how to all table which indexes are useing in database

  Hi, i have bank database in that 10 tables is there i want to know each table wich index is using i…

  rajeshn29.dba

  5 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• Clustered index scan vs Clustered Index seek

  I was looking at the execution plan of a query but I'm not able to understand why it's doing a clus…

  sunny.tjk

  4 replies

  14 years, 7 months ago

  By: TheSQLGuru

• SQL Server is slowing down.

  I am using SQL Server 2005. From one day last week the server is taking too much tim to run a routi…

  hammad_siddiqui

  6 replies

  14 years, 7 months ago

  By: hammad_siddiqui

• Rolling back already commited data..?

  Got this email from one of the devs... Not sure if you can help with this? I’m writing some Unit T…

  krypto69

  14 replies

  14 years, 7 months ago

  By: krypto69

• Data Modeling Tool that Reverse Engineers an existing database

  I'm looking for a tool that will reverse engineer an existing database into a data model. I know th…

  ericwenger1

  3 replies

  14 years, 7 months ago

  By: Grant Fritchey

• DBCC Shrinkfile & Shrinkdatabase

  Hi there, When running sp_spaceused on a database I get the following: Database Size: 108 493.94 MB…

  Skandalis

  36 replies

  14 years, 7 months ago

  By: Skandalis

• blocking and locking?

  Hi All, Want to know the basic difference between blocking and locking? Thank You.

  Oracle_91

  4 replies

  14 years, 7 months ago

  By: Oracle_91

• avoid the failure alerts from decommisioned server

  please assist what steps i need to take. One my old server had been decommissioned and we have new …

  narasimhareddy.dba

  15 replies

  14 years, 7 months ago

  By: Evil Kraig F

• wait_type : CXPACKET - suspended

  Hi session_id : 53 status : suspended blocking_session_id : 0 wait_type …

  SQL Galaxy

  13 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us