.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

Disk Stripe Width

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
Since SQL Server uses 64K pages, isn't it MORE advantageous to use a larger stripe width, say, 1MB?  This would allow for multi-page reads. Doc  

View Complete Post

More Related Resource Links

file upload in chunks or not buffering in memory before writing to disk?


What are the options for handling file uploads to reduce the memory footprint?  Is there a way to upload in chunks?  Is there a way to stream upload directly to disk instead of loading entire file in server memory?


Windows With C++: The Virtual Disk API In Windows 7


This month we look inside the Windows 7 beta to examine the Virtual Disk API and the Microsoft Virtual Hard Disk (VHD) format.

Kenny Kerr

MSDN Magazine April 2009

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create th

I received the following error...*****System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 2739929088 additional free bytes, while only 801185792 bytes are available. (Microsoft.SqlServer.Smo)*****I have looked at the solution recommended on this forum http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79848 but I am still baffled as to why it says that I don't have enough disk space?  I ran the RESTORE FILELISTONLY command and it told me that the "size" was 1.4 GB and I've got 60GB left. I am starting to resolve that my .BAK is corrupt.  Are there any other reasons as to why I am unable to restore my backup?Thanks for any help in advance!

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

Confused about Disk Alignment/ Partition Offset

I am all confused by disk alignment, partiton offset.Why do we need to calcualte offset which most of the articles talk about, This is from White Paper  Disk Partition Alignment Best Practices for SQL Server where its stressed that Partition_Offset ÷ Stripe_Unit_Size-- should be an integer 'The performance question here is usually not one of correlation per the formula, but whether the cluster size is the NTFS default of 4,096 bytes or has been explicitly defined at 64 KB, which is a best practice for SQL Server.' Also how do we calculate Stripe Unit Size for SAN. Thanks all for your replies !!  

How large do you make your MSDTC Physical Disk Resource?

MSDTC requires a physical disk resource for the 4mb log it uses.  How large do you typically make the disk used as the MSDTC Physical Disk resource?  I don't know if there is a need to go beyond 4MB.  I'm guessing 100MB is a safe number.  Do you agree? Thanks,    Dave

getting the width of a text

a markup extension for getting the width from the number of characters in a text   public class TextWidthExtension : MarkupExtension { static TextWidthExtension() { try { var culture = CultureInfo.GetCultureInfo("en-us"); var font = Application.Current.TryFindResource("_Font") as FontFamily; var typeface = new Typeface(font, FontStyles.Normal, FontWeights.Normal, new FontStretch()); double fontsize = (double)Application.Current.TryFindResource("_FontSize"); double sum = 0; for (char c = ' '; c <= '~'; c++) { var formattedText = new FormattedText(c.ToString(), culture, FlowDirection.LeftToRight, typeface, fontsize, Brushes.Black); sum += formattedText.WidthIncludingTrailingWhitespace; } AverageWidth = (sum / ('~' - ' ')); typeface = new Typeface(font, FontStyles.Normal, FontWeights.Bold, new FontStretch()); sum = 0; for (char c = ' '; c <= '~'; c++) { var formattedText = new FormattedText(c.ToString(), culture, FlowDirection.LeftToRight, typeface, fontsize, Brushes.Black); sum += formattedText.WidthIncludingTrailingWhitespace; } AverageWidthBold = (sum / ('~' - ' ')); } catch { } }

reading excel file without saving to disk first

Having an issue.  I need to be able to read an excel file from a file upload control but I can not save the file to disk first, it must be done in memory.string excelConnectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; excelConnectionstring += filePath.Replace("/", "\\"); excelConnectionstring += ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'"; OleDbConnection con = new OleDbConnection(excelConnectionstring); OleDbDataAdapter da = new OleDbDataAdapter();Above is my code for reading the data file if it IS saved to disk, but again, I have to be able to do this without saving the file to disk, it must be done in memory.  I have not been able to find any sample code anywhere on how to do this from memory, everything seems to force the file be uploaded, saved to disk, and then read in the connection string, which again I can not do.Any advise would be great, thanks in advance.  I'm really in a bind here.

Does SharePoint support the Full Width Asterisk within urls?

The Full Width Asterisk (U+FF0A) can be entered for folder names in document libraries and file names.  Yet when you attempt to open files with this character, or files in a folder with this character, the url does not resolve. I have tried all of these, but none work. http://server/Shared%20Documents/%EF%BC%8A/Test%20Document.txt http://server/Shared%20Documents/%uFF0A/Test%20Document.txt http://server/Shared%20Documents/*/Test%20Document.txt

Hard disk

My laptop is Lenovo T400, 320G without partition and installed Window Vista. Recently, the hard disk space around 100G missed and can't display by using the Lenovo thinkVantage toolbox which only classified as no scaned. May I find the missing and release to normal use? Since it only remain 4x G. for further use.

Dependency of IP , n/w , Disk in MSDTC.

have installed sql server 2005 cluster but never 2008 ,now I have got this chance but I am not understanding how to create dependency of IP , n/w , Disk in MSDTC. What are the domain user rights ?Actually my previous site was given the writes of domain admin to the sqluser now it is giving me problem.??"SQLSERVER DBA" "INDIA"

How to set the width of column on GridView

How to set the specific the width of each column, the columns are created automaticly 

What is the best way to nest Listviews together and have all listivew columns retain the same width

I have 3 listviews that I need to be come one.  Each listview has a different source, but information from each is used in the other for totals. I have no problem nesting the listviews one after another to look as if they are actually one listview in the end, but I need to figure out a way to make the  columns identical.  What is the easiest way to do that? Thanks 

find and replace linebreaks in file read from disk

I have a css file which I want to read from disk and in that content I want to find and replace all linebreaks (do I look for vbCrlf or ...?)   Public Shared Function GetFileContents(ByVal FullFilename As String) As String        Dim filecontents As String = ""        If File.Exists(FullFilename) Then            Dim objStreamReader As StreamReader            objStreamReader = File.OpenText(FullFilename)            filecontents = objStreamReader.ReadToEnd()            objStreamReader.Close()        End If       Return filecontents    End FunctionSo in the returned variable "filecontents" I want to find and replace any linebreaks.        FILE: style.css#progress{color:#000;width:500px;height:30px;padding:0px;clear:both;}#progress ul{list-style:none;padding:0px;margin: auto;display:block;}#progress ul li{list-style:none;display:inline;float:left;width:auto;height:30px;padding:0px;line-height:30px; font-family:Arial, Helvetica, sans-serif; font-size:13px;}

How can I set the width property the LayoutTemplate in a listview through codebehind

Taking the following simplified layout for a listview, how do I get and set the width property of the columns. Using Codebehind, how do I set the width of Th2 to Th1. <LayoutTemplate> <table ID="itemPlaceholderContainer" runat="server"> <tr ID="Tr1" runat="server"> <th ID="Th1" runat="server"> </th> <th ID="Th2" runat="server">                         </th> <th ID="Th3" runat="server">                         </th> </tr> </table> </LayoutTemplate>    

WPF control size is larger than explicitly set width and height values.

I created a Canvas with fixed Width and Height (256x256). Next to it I put an Image control displaying a 256x256 texture without stretching. How is it possible that actual sizes of both controls on the screen differ so much? Here - is the screenshot illustrating size mismatch. And here - the TestLines256.png in case someone liked to check it (and maybe point out that I'm stupid and this texture is 180x180 and not 256x256 as I claimed). XAML with creation of the controls:   <Window x:Class="OversizedQuad.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" SizeToContent="WidthAndHeight"> <StackPanel Orientation="Horizontal"> <Canvas Width="256" Height="256" Background="Red" /> <Image Stretch="None" Source="TestLines256.png" /> </StackPanel>

copy the image from table to disk drive

i have 2000  image he saved in the table "Employee" and i want to copy this pictures from table to diskdrive and save file name by the ID
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