The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
40 views

Moving Clustered Index to new filegroup results in excessive filegrowth

I've Moved the clustered index on large tables to new filegroups to defrag, compress, and to recover space more easily from the original "primary" filegroup. Problem: A 315GB compressed Clustered ...
1
vote
1answer
75 views

Partition : understanding files and file groups

We are trying to partition a large history table. Being new to partitioning, I was trying to understand the concept of files and file groups. File groups can be set up in following three ways : 1. ...
3
votes
0answers
292 views

Query to find optimal filegroups for objects

I have been assigned a task to create four file groups (one per volume) locate tables so that they are located in a manner that during an ETL process no filegroup is being read and written to at the ...
0
votes
0answers
94 views

“Text/Image Filegroup” is not working

I have created a file with the Logical Name 'Connection' and file group from database properties window. Now I want to assign this file to 'connection' table. So I have done the following steps:- ...
0
votes
0answers
61 views

file extension of the file types cdump, incident, trace

I need to know the file extension of the file types cdump, incident, trace, alert. Actually I want to create files of the above types manually using mkfile command. There are no existing files of ...