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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Search DB, Multiple File Groups & Sizing Guidelines?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#


The following two articles cover the use of a second file group for the Search database however there's no indication of sizing. Are there any guidelines on how large each file group will end-up?

For example, if my Search database is 100GB and I split this out into two file groups will each file group end-up as 50GB each, 60GB in one, 40GB in another, etc...any ideas?





View Complete Post

More Related Resource Links

Upload Multiple File using JQuery in asp.net

In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Code Name WinFS: Revolutionary File Storage System Lets Users Search and Manage Files Based on Conte


One of the monumental problems organizations face today is aggregating information that's stored in disparate formats. Knowledge workers have long wanted to be able to search for content independent of format. The next version of the Windows operating system, code-named "Longhorn," boasts a new storage subsystem that makes that task easier. That subsystem, code-named "WinFS," allows the user to perform searches based on the metadata of the stored item, regardless of what type of file it is or which application created it. This article covers the basic architecture of WinFS and explains how to use the WinFS managed API.

Richard Grimes

MSDN Magazine January 2004

search multiple words into textbox and populate all records in gridview related those keywords


I have a textbox and a gridview which is bound to a table

what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;

1. Book

2. Red

I have set up the sql data source and everything and my like operator is this...

LIKE '%' + @record + '%'

how can I solve this problem?

Filter search over multiple text columns


Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?



Excel file not showing in search results

We have a strange issue. I have one Excel document (or at least one that I am aware of) that will not show up in search results for content within the document. I can find the document by title just fine, but when I search for words within the document I do not see it. The document was originally a 2003 Excel document and was recently converted to 2007. Other than that there isn't really anything unusual about it (some formatting stuff, but mainly just background colors and whatnot, nothing fancy). The crawl log shows the document was crawled without error. Anyone know anything else I can check on?

How to do wide search and export the records to excel file in ASP.net C# ?


This is my MYSQL  database connection :-

public static OdbcConnection Connection = new OdbcConnection("Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=jdmcrm; User=root;Password=admin;");

My table name is "customer" and  fields liek customerId , companyName , address and date ;

How to do wide search and export the records to excel file ? im quite new in asp.net .

Pls advise . Thanks





Using the single *.rpt file with multiple data sources


I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
CrystalReportViewer_ClientLetter.Visible = true;

ConnectionInfo con = new ConnectionInfo();
con.ServerName = Constants.ServerIP;
con.DatabaseName = Constants.DatabaseName;
con.UserID = Constants.UserID;
con.Password = Constants.Password;

CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
ParameterField batchdate = new ParameterField();
batchdate.Name = "@BatchDate";
ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);

foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
tlf.ConnectionInfo = con;

Multiple groups of roles in membership

Hi,I am developing this website which requires multiple groups of roles inside membership.Here is an example:I want to create a group of states (would be the first group of roles):* Oregon* California* Kansas* Texas* OhioAnd then a second group of profiles:* Admin* Section 1* Section 2* Section 3Then I want to comine these groups, so for example:* Patrick has Oregon and Section 1 role, so he can only access the state of Oregon and Section 1 module on the website.* Laura has Kansas and Section 2 role, so she can only access the state of Kansas and Section 2 module on the website.* John has Ohio, Texas and Admin and Section 1 roles, so he can only....Do you understand what I mean? How can I achieve this with .net memberhip?

Error using multiple webconfigure file in ASP.Net 3.5

when i using mutiple webconfigure file in .net 3.5 ,error Comes t is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS.

SSIS multiple data flows accessing the same raw file

I have multiple data flow tasks accessing the same raw file at virtually the same time.  I would like to know if the data flow tasks lock the raw file during read?  Can multiple data flow tasks read the same raw file at the same time.  I'm currently developing with a very small data set, but I would like to know if I should be concerned with the possibility of the data flow tasks competing for access to the same raw file. Thanks.

File search - Asp.Net 4.0

Hello everybody. I am developing a new project to list files and directories under an specified location on disk. I use normal methods like Directory.GetFiles() to achieve this task but the amount of files is getting very big (> 300000) and the site is becoming terrible slow. I worked with Index server with previous versions of Asp.Net but I was wondering if there is a new way for my website running Asp.Net 4.0. Also I heard something about Index Server is obsolete to achive file listings and search. Is there any new alternative? Many thanks

ssis 2008 Loading MULTIPLE EXCEL file

HI it is possible for me to load multiple text file using for each loop,but if i try the same process for EXCEL file then my excel source throws an error. Also when i created my variable in value  i have given the path of my excel file ,still it didnt help me..because the moment i map the variable with the connection string of source excel connnection(property->expression->connection string) it start giving error if you could help me or provide some reference it will be of great help http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html i tried this link but got stuck with it on step 12 and 14 (below  is my connection string) and variable is @Filename which i have created Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\mushtaq.sheikh\Desktop\ForEach\New Microsoft Excel Worksheet1.xlsx;Extended Properties="Excel 12.0;HDR=YES"; The moment i try to edit my connection string by comparing connection string provided in link it gives error(an OLEBD error has occured with error code 0x80040E73) on excel source Thanks in advance

Search cannot find contents of the PDF file

I have small SharePoint 2010 Server with 2 servers. Steps I made: 1. I have Downloaded and installed Adobe’s 64-bit PDF iFilter to the Front-End machine 2. I have downloaded Adobe PDF icon and inlucluded to the DOCICON.XML. 3. I have added PDF as supported file type 4. I have restarted IIS 5. I have made full crawl 6. Crawl log showed no errors. All items were succesfully crawled. Results: A) PDF icon displayed b) Search based on PDF document name works fine C) Search based on words inside PDF document is not found. What should I do? Reference: http://www.sharepointsharon.com/2010/03/sharepoint-2010-and-adobe-pdf/Kenny_I

Multiple File Uploads and blocked file types.

Hi hopefully someone can help me with this. I have removed a few file type extensions from the blocked file type administration interface (.ascx, ashx, dll) etc. If I browse to my shared folder I am able to load files of these types into my shared folder on a file by file basis, if however I try and use the drag and drop activex control facility for multiple files provided for IE8, files of these types are still blocked. If I also map a network drive from my PC to the shared folder and attempt to copy files of the above types, they're also being blocked. Perhaps someone has come across a similar issue and can shed some light on what they did to overcome this problem. Kind regards Paul

window file search pattern to regular pattern

  I get files by file search pattern( "bat_2006*.dat.gz") for a directory, and then get a file name from txt file list like below, How can get match filename by file search pattern  "bat_2006*.dat.gz"? Thanks. bat_20061010.dat.gz bat_20061023.dat.gz bat_20070011.dat.gz  

search on multiple lists

Team, I have a situation where i have to do a search on multiple lists at once. List A - Field A, Field B List A - Field A, Field C List A - Field A, Field D When a user searches by Field A i want to pull all records from all lists. How do i present it after u have done the search. What web parts should i use? Is is possible to search on multiple lists. How to do it through designer? Do i need to a roll up view and search on it. If its possible.. Should i do join of lists and try to filter it based on FIELD A? Can we filter on joined lists? Any ideas on this .... Thanks a lot in advance.      
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