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

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

Benefits of moving nonclustered indexes to another filegroup on SAN

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

We have a newSAN raid 5 array which I am moving some of our databases too.  Is there any benefit to moving the nonclustered indexes to a separate file group than the data files even though they will still be on the same disks/lun's on the san SAN?  I could see the benefit if the SAN was zoned where we had separate disks allocated so that I could move the index filegroup to different disks than the data files,  but that does not appear to be an option. Running SQL 2005 standard, dual quad core with 24 gig of RAM. Thanks!

View Complete Post

More Related Resource Links

The Polyglot Programmer: Reaping The Benefits Of Cobra


Cobra, a descendant of Python, offers a combined dynamic and statically-typed programming model, built-in unit test facilities, scripting capabilities, and much more. Feel the power here.

Ted Neward

MSDN Magazine June 2009

CLR Inside Out: The Performance Benefits of NGen.


T ypically, methods in managed executables are just-in-time (JIT) compiled. The machine code generated by the JIT compiler is thrown away once the process running that executable exits; therefore, the method must be recompiled when the application is run again.

Surupa Biswas

MSDN Magazine May 2006

OpenMP and C++: Reap the Benefits of Multithreading without All the Work


Having more than one CPU core on a single chip makes a system with a processor with two cores operate just like a dual-processor computer, and a system with a processor with four cores operate like a quad-processor computer, so you get much better performance. But if your application does not take advantage of these multiple cores, you may not reap the benefits. OpenMP helps you create multithreaded C++ applications more quickly so the benefits of multithreading can be realized.

Kang Su Gatlin and Pete Isensee

MSDN Magazine October 2005

Cutting Edge: Moving DataGrid Rows Up and Down


Imagine opening your Inbox one morning and finding a message that reads "Dear Mr. DataGrid, I urgently need an ASP.NET DataGrid that lets my users move rows on the client. You're my last hope. Will you please help me?"

Dino Esposito

MSDN Magazine March 2005

Do not see the table in Database after moving the project folder



I created a ASP.NET project under Visual Web Developer 2008. Under that project I had a Database (along with ASPNETDB.MDF) which has about 3/4 tables (I had SQL server 2008). Everything was working fine (like insert, delete, etc.). And I was able to view the tables in database explorer view.

Then I had to format my computer for some reason and I copied the whole project in a USB drive and then after formatting the computer I copied the folder and tried to open it in Visual Web Developer (now I have VWD 2010). I can see the both Database under App_Data folder (ASPNETDB.mdf and the DB I created). ASPNETDB has all the tables and data as expected. But I do not see the tables under the DB I created.

I also tried in one of my friends computer who has Visual Web Developer 2008. But same result.

I am just wondering if anyone can help me with retreiving the table. I have a bad feeling that I might needed to do something to backup the data (not sure though). But the tables should be still there ... isn't it ?

Any help will be appreciated. Thank you in advance.

Moving a website - URL aliasing question


Hi we are migrating a website from a proprietary system  to a new system built inSQL 2008.

The old  system has about 6,000 pieces of content with individual hard-coded aliases. How could we go about creating a match table to ensure these resolve with our new system (based on Intellgentsia URL rewriter)?

Any pointers would be helpful.

Problems moving an InfoPath form from a DEV system to QA environment


We developed an InfoPath form using a local DEV environment.  The site collection under which the form was developed was http://server1/.

We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely http://server2/sites/sitecol1.

In both cases the site that contains the form is /fin (so we were using http://server1/fin in DEV and want to use http://server2/sites/sitecol1/fin in TEST). 

The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:

1. Publish the form against the TEST server using InfoPath Designer

2. Upload the form using Central Administration > Application Managment > Manage Form Templates

3. After upload, we activate the form for the site collection http://server2/sites/sitecol1/

4. The form is then associated with a Form Library

When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:

The following location is not accessible, because it is in a differ

WSS 3.0 - problem with moving the database


My company wants to move a database included with WSS 3.0 installation to a *separate* server.
We want to have the database completely separated, on a different computer, on SQL Server 2005 installation.

Unfortunately, I'm not sure If the sharepoint is configured as a "Web Front End" or  "Stand-alone".
All I know, everything currently is on the same computer, and we can connect to the live database using the following path: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

The question is, how can we move the database to SQL Server 2005, on very different server, leaving the application untouched?

Quick summary, we currently have:

--- Server A: (WSS 3.0) + [windows internal database / SSEE (not sure!)] + DOMAIN X

and we want t

Moving to Vs2010


hello all!,

I'm trying move a class library project to VS2010 and I got problems with one  reference to this project. For some reason the reference look fine in the solution explorer but in the Object Explorer I can't to see the referenced assembly :(. I tried rebuild the solution but nothing :(

The message what I got in the code is:

"Namespace or type specified in the Imports 'MyCompany.common.services.Utilities' doesn't contain any public member or cannot be found."

Any help! :(

SharePoint 2010 Benefits for Developers

Software developers can use the SharePoint 2010 developer platform to build business collaboration applications for the enterprise and the Web, all with familiar tools and a rich set of interoperable, out-of-box features.

Moving SharePoint 2007 from Domain to a Workgroup


For development purposes, we have SharePoint 2007 installed on a virtual server (Wind 2003) on a company desktop (Vista Business ed.).  The SharePoint is using Active Directory and company domain. For learning purposes, we want to copy the virtual machine on another Vista machine that is outside the domain and is not using AD:

Question 1 : How can we move the SharePoint from a domain to a Workgroup
Question 2: Is it possible to still be able to use emails (through local installation of Outlook) on the same computer that is not on the domain? If, yes, what are the possibilities (any articles on it? Etc.)?


ArrayList indexes not set properly


I have some basic code to fill items in an ArrayList as follows:

Dim intSteps As ArrayList = New ArrayList()
Select Case Session("type")
Case 1
Case 2
Case Else
End Select

Dim j As Integer
	For j = 0 To intSteps.Count - 1
        Response.Write(intSteps.IndexOf(j) & " : " & intSteps.Item(j) & "<br />")

The issue is that for Case 1 the output is:

0 : 0
1 : 1
2 : 2
-1 : 6
-1 : 11
-1 : 12

For Case 2, it's:

0 : 0
1 : 1
2 : 2
-1 : 5
-1 : 6
3 : 11
4 : 12

And for Else, it's:

0 : 0
1 : 1
2 : 2
3 : 3
4 : 4
5 : 5
6 : 6
7 : 7
8 : 8
9 : 9
10 : 10
11 : 11
12 : 12

Why is the index being set as -1 for a few items?

Moving Datarow from datagridview to textboxes

Hi , I need to know how to copy a datarow from datagridview to subsequent textboxes.I have three textboxes and three fields in datagridview .

How to remove indexes

How to remove indexes..as it is created by mistake I have read that if it will be deleted then data will be deleted also...PLease clear the case of removal of clustered and non clustered indexes..."SQLSERVER DBA" "INDIA"

questions about files in filegroup

in SQL Server 2005 . . . how can i see the content of files in a filegroup ?

Moving Membership tables to production; empty

Hi all: I'm currently moving my application from my testing environment, onto our live environment.  I've moved my database, including all membership tables over, and everyting is empty.  Again, this is what I wanted.  The test environment had far too much "crap" data, including fake user, so I wanted to just start from scratch on the production environment.  I don't know how to re-create the application or the first user though in these membership tables??  I'm sure this isn't an odd thing to do, but I havent' had any luck yet with finding an answer of how to do this.  Any help is greatly appreciated! Thanks, Terri-Lynn 
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