Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rtantek

    joining multiple tables

    i have 3 tables: accounts, bank1, bank2. i need to sum the field [mybalance] from both bank1 and bank2 where acctnum from bank1 and bank2 exist in accounts. all acctnum in bank1 are in accounts; all of acctnum in bank2 are in accounts; none of acctnum in bank1 are in bank2 and vice versa...
  2. rtantek

    (MDF and MDF) versus (MDF and NDF)

    Terry, the scenario is to put data in one MDF and the index on another MDF. It was suggested that SQL may use one thread to accessing the data and another to access the index. or that SQL may use only one thread to access the index if the it is located on an NDF file.
  3. rtantek

    CasheHitRatio

    look into DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE.
  4. rtantek

    (MDF and MDF) versus (MDF and NDF)

    in creating a db where there are multiple physical files, is there an advantage to changing the file extension of the extended physical file from .NDF to .MDF? if so, is there a white paper on it?
  5. rtantek

    Listing objects in filegroups

    is there a way to list all objects in filegroups?
  6. rtantek

    index calculation utilities

    can anyone suggest some utilities to calculate index size.

Part and Inventory Search

Back
Top