.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT
Post New Web Links

Avg_fragment_size_in_pages low numbers

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server


We have newly installed Fast track Server for SQL Server 2008 R2.

I have created a table with partition function and scheme.  I am loading data "Contiguously" to the table like "Order by Pk_Column option(MAXDOP 1). So the data getting loaded, but when I check the fragment values at the sys.dm_db_index_physical_stats table , I am getting low numbers for the avg_fragment_size_in_pages column. As microsoft recommed that this column value should be more than 400 means, good numbers and performance also will be good other wise low performance.

 when you look at sys.dm_db_index_physical_stats, a high value number for fragment_count or a low value for avg_fragment_size_in_pages can indicate lack of contiguousness.

View Complete Post

More Related Resource Links

Generate Random Numbers

SQL Server has a built-in function that generates a random number, the RAND() mathematical function. The RAND math function returns a random float value from 0 through 1.

Two numbers after dot



How to do this:

10 becames 10.00

12.3 becames 12.30

14.23 becames 14.23

Thanks you

accept numbers only , telephone validation



my requirement is textbox has to accept only numbers and  " ( ) - " symbols only.

any code plz


Add page numbers for paging in data view web part


Hello all,

Has anyone found a solution that will allow me to have page numbers for paging in a data view web part. For instance, if I have 40 items/rows and I set the paging to display 10 items, I'd like the paging to show 1 2 3 4 rather than showing 1-10 and having to click next over and over to get to a specific item.

I found this article, but it is for 2003 and doesn't seem to apply to 2007 or if it does I am not able to really figure out how.


Please help!

Thanks in advance.


Last numbers from a string


I need a vb function to determine the last numerical characters in a string. For example, if the string is Step1, I need it to return 1. If the string is Step32, I need it to return 32.

I'm aware of the string functions like Right, Instr, etc but I'm just not sure how to get what I need. Any suggestions?

get the string of 6 numbers following a dash and a space

I need to retrieve a string of 6 numbers which following a dash and space e.g - "John Smiley - 023112 - California" I would like to get the "023112" part

Help: Rounding off numbers

I'm having some problems when it comes to rounding off numbers. In the reports I build the users wants to see the numbers in M$ or k? . that is Million$ or kilo?. So what I do is take the money and divide it by 1.000.000 or just by 1.000. The thing is that if a number is 750.000 and I divide it by 1.000.000 it should say 0,75M? for example. But nooo, it says 1M?, and that's not right. Any suggestions?  Thanks in advanced

How to skip page numbers?

I have a SSRS (2005) report with multiple subreports inside of it. Page numbers are displayed on the footer of the "outer" report. After one specific subreport, though, the user wants to have space to insert three pages from a different source, so she wants the page number on the footer to be increased by three. I tried a gazillion things, but it seems that the only possible way is to print three empty pages and replace them (what a waste) before distributing the report. Any suggestion?

Prefix in Numbers

how can i determine prefix of numbers in SQL? for example i want to select records that their ids starts with "123".

RegEx for numbers, letters & underscores only

I have this code:public bool IsAlphaNumeric(String strToCheck){  Regex objAlphaNumericPattern=new Regex("[^a-zA-Z0-9]");  return !objAlphaNumericPattern.IsMatch(strToCheck); } how do I modify the Regex to also accept underscores? 

Order the numbers by value

This seems very basic but I can't seem to find a fast way to do it..I have the following numbers:5, 3, 10, 52, 1I want to order them in the correct format from 1 to 52 and be able to point out which one is the highest, which one is the lowest, which one the second to highest, etc.

Subtracting debits from credits when they are all positive numbers and credit/debit is indicated in

Hi,   I have a table with four columns - InvoiceCreditLineID, SOPOrderReturnLineID, InvoiceCreditQuantity, SOPInvoiceCreditType. The third contains only positive numbers. The fourth contains a 1 for credits and a 2 for debits.   I need to show summed credit quantities minus the summed debit quantities, grouped by SOPOrderReturnLineID. I tried using a sum in a subselect in the select clause for the credit quantities and another for the debit quantities, but this just shows me the totals for the whole table.   Any idea how I do this?

Count numbers of days (no time table in datasource)

I read the following regarding adding a measure for counting the number of days: The trick is to create new measure group, which will have only one dimension - Time, and a measure with Aggregation Type 'Count' bound to the Day attribute of Time dimension (or any other attribute if we need to count something different from days). The most important setting on this new measure group is to leave IgnoreUnrelatedDimensions=true - this will allow to use this measure across any other dimension in the cube. Howerver, this solution assumes that one has a time dimension based on a table in the datasource. I have a Time dimension that created was by the BIDS wizard that is not in my source database but appearantly invisibly hidden on the AS server without direct access to it. (If I try to add a new measure group (as needed according to the post above) then I can only choose from tables that have nothing to do with time). Can somebody explain how I can do this without a specific timetable in my datasource? Do I need to add a timetable just for this purpose? Can it be stand-alone or do I need to add a relationship with all current tables that have date-columns in them? (I am a finance manager that is building a sales cube based on Navision 3.6, which is already working quite nicely, but still very much a newby)

Javascript numbers only, & format it to Decimal

Hello Experts, I need some help guys ;( I want some javascript code that make sure that end user must enter only numbers on textbox (currency,number), no characters, also typed number will be formated to be decimal number, I mean if user type (22222), javascript should format the number to be (22,222.0) javascript function should be called while end user typing on Textbox. so if he enter character, then the character should be removed automatically. I read many posts that talked about this, but most of them are using the onkeypress(event), so if the user paste the text that code will not work. Please help me guys, I need this urgent

changing negative numbers

I have negative numbers in my report and I wish to display them with a "<" sign. How shld i go about doing it?

Use letters instead of numbers for document versions

Is it possible to use letters instead of numbers for document versions? In sharepoint, drafts are numbered 0.1, 0.2,... 1.1, 1.2, 1.3, etc. and published versions are 1.0, 2.0, etc. But due to company's procedures we should use a different system using letters (A, B, C...). Is that possible? If not, would it be possible to add some property to the documents to add the version letter? I know it may be difficult because the letter can be calculated just after sharepoint assigned the version number... :-(

Column Autonumbering in Doc Library: different numbers in different folders

Hi All, I am trying to develop an automunbeing column following the following post: http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/867bcacd-d378-411a-849a-fc040de9e5da/ This looks great, but unfortunately I have to develop something more specific. I have a doc library with specific folders and subfolders. I need to have an autonumbering code for each folder and subfolder. for example, given the following doc library structure: Doc Librery     - 01 Engineering     - 02 Design     - 03 Procurement         - 01 Onshore         - 02 Offshore each document should have the following autonumbering: in 01 - Engineering   -> 01ENG-0001, 01ENG-0002, 01ENG-0003 etc. in 02 - Design   -> 02DES-0001, 02DES-0002, 02DES-0003 etc. in 03 - Procurement -01 Onshore   -> 03PRO01ONS-0001, 03PRO01ONS-0002, 03PRO01ONS-0003 etc. in 03 - Procurement -02 Offshore   -> 03PRO02OFF-0001, 03PRO02OFF-0002, 03PRO02OFF-0003 etc. in this way I can easy identify where the document is stored. how can I do this? a custom workflow or a custom field developed in Visual Studio? Any suggestion would be good. Thanks Vit  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend