.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

Can I use folders instead of logical drives to separate data from logs if all data is on a RAID10 di

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

I've got six clustered SQL Instances storing data on a SAN, a SAN that is all RAID10.  It has one RAID10 disk pool.   Did it make any sense for me to create separate iSCSI initiators for data and log volumes?  I have no RAID5 space on which to store the data.  All the information gets the same high-quality access.


Could I have saved myself some time and just made one big disk for each instance, separating logs, data, backup, temp and master in folders?


When the data is sent, via iSCSI, to the SAN, the SAN director takes the data and does what it wants, irrespective of the operating system that sent it.  I think all the old rules of thumb go out the window.

View Complete Post

More Related Resource Links

Restore Data only after failed drives, Log file is good on a separate drive array

We have a 2000 sql server.  Our drive array housing the mdf file has taken a dump.  The drive array housing the ldf file is fine.  I have a full backup as of 2 hours ago.  I know I can restore to that point in time.  However, the transactions sitting in the ldf file are critical to get applied the the restored mdf file.  In reading I see I can restore log files using the "With NoRecovery" option, however, I don't wan't to restore any log files, as I'm thinking the one I have is good.  I want to be able to restore the mdf file and then have the database apply the transactions in the log file on the mdf file. (I want the "redo" phase to use the current ldf file, not a restored ldf file) Any Ideas?

Need to upload images with data, but image url's are in separate db table

Hello, I'm making a simple homes classifieds section and when a home ad is created, a HomeID is automatically created for it in the db.  I need the images to upload and enter the associated HomeID with each image automatically.  What I tried isn't working, because it looks like it's looking for the HomeID in the codebehind before it gets entered into the db.ASPX CODE<asp:SqlDataSource ID="SqlDataSource1" runat="server"         ConnectionString="<%$ ConnectionStrings:ConnectionString %>"         InsertCommand="INSERT INTO [Homes] ([UserName], [Street], [Details], [Contact], [Phone], , [Thumb], [Price], [Approved], [Posted]) VALUES (@UserName, @Street, @Details, @Contact, @Phone, @Email, @Thumb, @Price, @Approved, @Posted)"         SelectCommand="SELECT [HomeID], [UserName], [Street], [Details], [Contact], [Phone], , [Thumb], [Price], [Approved], [Posted] FROM [Homes]" >        <InsertParameters>            <asp:Parameter Name="UserName" Type="String" />            <asp:Parameter Name="Street" Type="Str

Import a flat file with combined data into separate SQL tables using SSIS

I have a flat text file (comma delimited) that is essentially multiple files, each with its own format, combined into one file. The file is coming from an external software vendor so unfortunately we don't have much choice but to work with what we are receiving. Here is an example of what the file could look like: Customer Data CustID,FName,LName,PhNum,Email 12345,John,Smith,,jsmith@gmail.com 12346,Jane,Doe,8001111111,jdoe@hotmail.com Customer Plan CustID,PlanType,PlanName,PlanStart 12345,0,Plan1,01/01/2010 12345,2,PlanVis,01/01/2010 12346,3,PlanLf,04/01/2010 12346,0,Plan1,01/01/2010 Customer Payment CustID,LastPayment,Amount 12345,09/01/2010,100.00 12346,05/01/2010,50.00 There is an empty line between each 'section' of data. I adapted a VB script I found online that can take the incoming file and save off each section as its own file so that each one can be separately imported, but this seems inefficient. I'm really new to SSIS in general, but it seems like it shouldn't be that difficult to take the data, split it where there is an empty line, and then import each section into the appropriate SQL table. Any ideas would be most welcome. Thanks!  

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

Why separate account data and user info?



If I'm correct the membership functionality separates account and user (profile) data in two tables. Why not one table? What's the design priciple behind this?


Cannot drag an Entity Framework Data Source (created in a separate solution) onto WPF Design Surface


I receive the error Cannot add the control to the design surface or bind to the contol because the type Pec.CustomerEntity.Carrier, Pec.CustomerEntity,Version=, Culture=neutral, PublicKeyToken=null cannot be resolved.  Please try to build the project or add necessary assembly references  (I have rebuilt and it still doesn't work)   -  when I try to drag the data source onto the window. 

If I create an entity framework project within the wpf application solution and create a data source and reference to it, it works fine when I drag the data source onto the window.  I only get the error when I create a reference to an EF project .dll created outside of the wpf project.  I am using Visual Basic 2010.    I have also tried adding the project to the wpf solution and it still gives me the error. 

C# data bound combobox: display selected item text in separate label.content


I am new to C# but I'm resisting the urge to run screaming back to VB.NET. I'm working with a WPF application using C# code-behind and a lot of binding to a SQL 2005 database backend.

GOAL: I have a comboBox bound to a tbl_Systems entity which provides a list of systems for user selection. When the User selects a system from the comboBox I want to display the selection's text in a separate Label. The big picture is that several comboBox selections will be used to build a query string that will populate a listbox. So, I want to display these selected values in the Label so the user can see the query string they have dictated.

PROBLEM: When I set the Label content property to the comboBox SelectedItem property the entity tbl_System is displayed in the Label not the comboBox selection text.

SUSPICION: From reading similar examples in VB I suspect that the comboBox SelectedItem is actually a "datarowview" or the C# equivalent. But I don't know how to translate this explanation to C#.

The UI XAML comboBox properties are set as such:


What new in XML Data Type if we can store data into separate columns?


Being new to XML Data Type I want to know what is the need to store our data in XML format if we can save it into separate Columns?

1. Is this practice being widely using in creating databases and maintaining information more efficiently?

2. Does this process follows Normalization rules?

3. What are the pros & cons?


Data Access tracing - No logs being generated.


I have configured tracing for sqljdbc_xa.dll as described in the msdn article 


The article provides steps for enabling tracing for 

Microsoft ADO.NET 2.0
   Microsoft MDAC 2.8 SP2
   Microsoft SQL Server Native Client
   Microsoft SQL Server 2005 JDBC Driver
   Microsoft SQL Network Protocols
   Microsoft SQL Server 2005 SP1

But after following the steps mentioned in the article, I have found that the Out.etl which is the file in which logs are added is not updated. It seems that logging is not being done. The article mentions that even opening up visual studio will add events to the log, but I have found that the log file is never updated. I basically want to enable logging for sqljdbc_xa.dll, but looks like even basic logging is not being done. 

Any one who has tried this ? or facing similar issues ?


Using Data View Web Part to access Documents in Separate Web Application


MOSS 2007 SP2
SharePoint Designer 2007

I am currently trying to display the contents of a document library within a separate site collection (different Web Application). The source document library is hosted on a Records Center on a Web Application with a name of records.example.com. The destination site (where the documents need to be displayed) is on a Web Application named teamsite.example.com

I am thinking web services is the way to go, but when I setup a connection to records.example.com/_vti_bin/Lists.asmx, I receive an error when trying to get the data:

The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again.

Any help will be greatly appreciated!

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.
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