Proportional fill - Microsoft SQL Server

Danny

All,

SQL Server uses a proportional fill method to add data to file groups where
a file group has multiple files. In general this is a good thing.
Unfortunately, the method appears to get switched off when new file(s) is
added. Other than exporting the data out of the filegroup, recreating the
filegroup and putting the data back in, is there a way to respread the
existing data back out and switching the proportional fill method back on?

Thanks,
Danny

Jul 23 '05 #1

Subscribe Reply

2094

Simon Hayes

As far as I know, there's no way to influence where MSSQL places data
within a filegroup. I'm not sure what you mean by "switched off" - if
you can give more details of what you're seeing, and what problem it
causes, then someone may have a suggestion.

Simon

Jul 23 '05 #2

Gert E.R. Drapers

You can not turn this behavior off. I think what you mean is that when you
add a file to the filegroup the data is not re-balanced to evenly distribute
the data across all files including the new one. This is the way the system
is designed. You would have to force it by rebuilding indexes, but this
introduces a space requirement and a period in which the table is offline
during the rebuild.

Ge***@SQLDev.Ne t

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

"Danny" <so*****@nowher e.com> wrote in message
news:9dRke.1781 $5T2.877@trnddc 01...

All,

SQL Server uses a proportional fill method to add data to file groups
where a file group has multiple files. In general this is a good thing.
Unfortunately, the method appears to get switched off when new file(s) is
added. Other than exporting the data out of the filegroup, recreating the
filegroup and putting the data back in, is there a way to respread the
existing data back out and switching the proportional fill method back on?

Thanks,
Danny

Jul 23 '05 #3

Similar topics

10232

<pre> and proportional vs fixed width fonts

by: Headless | last post by:

I've marked up song lyrics with the <pre> tag because it seems the most appropriate type of markup for the type of data. This results in inefficient use of horizontal space due to UA's default rendering of <pre> in a fixed width font. To change that I'd have to specify a proportional font family, thereby falling into the size pitfall that is associated with any sort of author specified font family: a) If I specify a sans serif font...

HTML / CSS

258

8775

Asking if elements in struct arre zero

by: Terry Andersen | last post by:

If I have: struct one_{ unsigned int one_1; unsigned short one_2; unsigned short one_3; }; struct two_{ unsigned int two_1;

C / C++

1037

non proportional fonts

by: Tina | last post by:

I need to do some left alignment in code and I need to use a fixed space (nonproportional) font. I know that Courier is such a font, but what other fonts are also non proportional. How can I tell which ones are so? Thanks, Tina

ASP.NET

10996

Does SqlDataAdapter.Fill() always close the connection?

by: M | last post by:

Hi, Does SqlDataAdapter always close the connection (assuming connection was closed before calling Fill()), even if an exception occurs while calling Fill()? Example: try { myDataAdapter.Fill(myDataTable);

ASP.NET

3322

Real-world use cases for map's None fill-in feature?

by: Raymond Hettinger | last post by:

Proposal -------- I am gathering data to evaluate a request for an alternate version of itertools.izip() with a None fill-in feature like that for the built-in map() function: >>> map(None, 'abc', '12345') # demonstrate map's None fill-in feature The motivation is to provide a means for looping over all data elements

Python

2102

Do you have real-world use cases for map's None fill-in feature?

by: Raymond Hettinger | last post by:

I am evaluating a request for an alternate version of itertools.izip() that has a None fill-in feature like the built-in map function: >>> map(None, 'abc', '12345') # demonstrate map's None fill-in feature The movitation is to provide a means for looping over all data elements when the input lengths are unequal. The question of the day is whether that is both a common need and a good approach to real-world problems. The answer to...

Python

3714

textarea automatic resize and proportional fonts

by: petermichaux | last post by:

Hi, I have been experimenting with some textarea automatic resize scripts. Most that I have found count the number of characters in the textarea and divide by the number of columns. This works will with monospaced fonts or with just wide letters like 'M'. However if I fill the text area with proportional font 'i' characters then a lot of white space builds up at the end of the text area. Is there a way to account for proportional fonts...

Javascript

4937

Setting Proportional Width of Bound GridView

by: Andrew Hayes | last post by:

In a C#.NET web page, I'm using the GridView control bound to a ObjectDataSource and the binding and data reading works fine. It auto generates the columns from the SelectMethod and makes the drid wide enough to show them all. The problem comes when I have an asp:Panel control around the grid (to generate scrollbars if the GridView is larger than the screen size). It always make the encompassing control as wide as the GridView.

ASP.NET

2340

Picture Box proportional to original image.

by: watashi | last post by:

Hello, I have 3 things to consider here, one is source image, form and picture box. My picture or image on the form must be proportional in size to the original image.This image on form should be proportional even during resizeing of the form. For example if the origianal image is square in shape, my image on form must always be square . if original image is rectangle with width > height by 10 times, my image on form ,nothing but

.NET Framework

9793

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10774

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10202

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7746

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6950

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5617

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5780

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4411

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3076

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General