• Deleting Nightly Database Backups (dumps)

    How do you set up a maintenance plan to delete or overwrite daily database backups (*.bak) file. My maintenance plan in SQL 2005 does not work...it doesn't do the cleanup it continuously appends to folder and I have to manually delete the files everyday

    637815 pointsBadges:
  • Rebuilding Logical Files

    What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

    Dcantwell470 pointsBadges:
  • In-Memory Database

    What do you mean by In-Memory Database? Is it like loading of database data along with application? Please explain me how the In-memory database get loaded along with the application.

    Techy001340 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Fastest “get duplicates” SQL

    What is an example of a fast SQL to get duplicates in datasets with hundreds of thousands of records. I typically use something like: select afield1, afield2 from afile a where 1 < (select count(afield1) from afile b where a.afield1 = b.afield1);

    Mm201010 pointsBadges:
  • Problem with slow loading database after delete record/data

    currently facing problem in loading my database after i delete some record from the database..i have compact for the database but still have the slow accessing problem..kindly assist..many thanks

    Tmlife5 pointsBadges:
  • Table size in SQL Sever 2000

    Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

    Yunior5 pointsBadges:
  • Implementing DBMS

    My company does not have information services staff and I am not planning to ave one at this moments because of the expanses. We have 12 WINTEL microcomputers that we used for variety of tasks withing the organization. We use Microsoft Office for words and financial application and power point, but...

    Mis15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following