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 TouchToneTommy 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: *

  • Users: druer
  • Content: Threads
  • Order by date
  1. druer

    Indexes on Secondary Filegroup

    I haven't come across anything which would tell me for certain what would happen if I move some of my hardest hit (non-clustered) indexes to a Secondary Filegroup that is on a new (non-raided) hard drive that was added to the server. I am using SQL Server 2000 on a Windows 2000 box. Currently...
  2. druer

    Filegroup for Indexes on Raid? Is it worth it?

    My system is about 50 gig and is a large RAID-5 system. Since I can't really control which "disk" a filegroup is on is there still any internal benefit to creating a separate filegroup for certain "heavily hit" indexes? (I've "optimized" the heck out of the indexes themselves at this point and...
  3. druer

    Performance of Insert .. Values vs Insert Select UNION ALL

    I came across a newly released stored procedure from development that has several branches in the stored proc where it does a bunch of INSERT INTO using the values clause. Each block is similar to the following and has between 5-10 inserts: INSERT INTO popup_single (name, result) VALUES...

Part and Inventory Search

Back
Top