473,326 Members | 2,134 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

default filegroup for creating indexes

As some readers of this newgroup can recall, I use Cognos' program
called Data Manager to build my data warehouse. I has the ability to
create indexes, however I cannot add other arguments to its command.
It has a basic command such as
CREATE INDEX PERSONNEL_ID ON
"dbo"."F_Personnel_Detail" ( "PERSONNEL_ID" )
The index by default is built in the PRIMARY filegroup.

I am testing out putting the indexes in their own filegroups and
testing performance and fragmentation management and I thought it
would be great if I could configure the database to use a filegroup
other than PRIMARY to build the index if the ON [INDEXES] argument is
not provied.
TIA
Rob

Mar 13 '07 #1
0 1255

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: el emperador | last post by:
I have a big table (heap)... well, not so big, I have a small server and I want to spread access to it across several new disks dedicated only to that table. I known its possible to do that...
14
by: LineVoltageHalogen | last post by:
Greetings All, I was hoping that someone might be able to shed some light on this issue. I am trying to add a FileGroup/Datafile to an existing SQL database. The code below compile and it runs in...
4
by: csomberg | last post by:
I have a SQL Server 2000 database and want to now split up the tables onto seperate file groups as well as some indices. How do you breakup an existing table to move it from one filegroup...
2
by: mchang | last post by:
Hello, I have been trying to figure out how to temporarily change the max filegroup size of a SQL 2000 database I "inherited" when our DBA quit. I just need some breathing room until I can...
4
by: Dr Warehouse | last post by:
Hi, I am expanding our data warehouse solution with new filegroups on several subsystems. I want to know which idea is better! - create clustered indexes on tables to 'move' them to new...
0
by: Takpol | last post by:
Hello, I have several archived filegroups that have data in them partitioned based on the date. These filegroups have been removed from database after archival. For example two months ago....
0
by: raj.raghavan | last post by:
Hi, I have a database were all the indexes are in a seperate filegroup a few large tables are in a seperate filegroup. We take backup at different times and I have backup of primary, two filegroup...
0
by: tz71 | last post by:
If a new filegroup is created on a new disk drive, is there a way to migrate a specific clustered index to the new filegroup? SQL Server 2005 SP2 kb
1
by: akshaycjoshi | last post by:
Default filegroup is the one in which all database files are created when created without specifying a filegroup, all books say. I did this CREATE DATABASE Akshay_DB ALTER DATABASE Akshay_DB...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.