Hello all !
I have a susdb.mdf file 55 GB size.
How do I reduce the size of the db ?
Windows 2003 Server with SQL server 2005
View Complete Post
How to reduce the image weight using
asp.net, without lose of image quality and image pixels. For example i
have an image with the size of 4 MB (3024*2045), so how to reduce the
image weight ie 4 MB to 1 MB without lose quality in the same pixels
ie(3024 * 2045) using asp.net.
MSDN Magazine January 2001
MSDN Magazine May 2000
Thank you for Advance.
currently we are configured execution Timeout="1200" (The default is 110 seconds) and maxRequestLength="12288" (The default is 4096 KB)
but some times users upload files above 12MB so we are getting "Maximum request length exceeded" error.
Jacescript Code are
var fso=new ActiveXObject("Scripting.FileSystemObject");
how can i check the file size before uploading process with support all the browser.
any posiblities for checking file size before server side script/object?
SQL 2005 Standard.
I want to restore a database from a .bak file. This bak file is referred to a database with fixed size datafile but they are bigger than I need for the new database.
Is there a way to reduce datafile size, during restore process ? I ask this because I will have to do this operation programmatically.
Ive just done BACKUP LOG against particular database and found no changes in size for the appropriate LDF file. It is shrunk only after I issue:
But this approach breaks all logs chain. Is there any way to shrink the LDF file for FULL backup model without destroying the whole sequece of log backups?
I have a multi databases SQL instance with a total size of 886GB.
I ran a large delete records and drop tables script in a purging process, Then I ran shrink script on all databases.
The size went down to 517GB, Yet after running the re-indexing job it went up to 635GB.
Does re-indexing job increase log file size? or else what cause this size increase?
When sending email with attachments to SharePoint list, if one of the file attached to the email is of size 0, then none of the files will be saved and NO new item will be created in the list.
The SPEmailHandler's ProcessAttachment method should check the length of the "contentStream". If the length is 0, it should return immediately.
As you can see in the ProcessAttachment method none of the arguments are validated before they are used. This an example of poor quality code.
It should do at least
if (contentStream == null || contentStream.Length == 0) return;
if (string.IsNullOrEmpty(fileName) || item == null) return;
private static void ProcessAttachment(Stream contentStream, Finding client file size before uploading I need to upload images from client to server as follows:1. Server is passing the client a file name 2. Client is checking file extensins to ensure it's an image then issues a __dopostback to the server. 3. Server uses the FileUpload control to save the image on the server.I have that all covered, but, if image is too large, the upload fails with the following error: 'System.Web.HttpException: Maximum request length exceeded.'Is there a way to check file size on the client (without the use of ActievX which also errors out), before it is passed back to the server?
Sample code will be greatly appreciated.
I need to upload images from client to server as follows:1. Server is passing the client a file name 2. Client is checking file extensins to ensure it's an image then issues a __dopostback to the server. 3. Server uses the FileUpload control to save the image on the server.I have that all covered, but, if image is too large, the upload fails with the following error: 'System.Web.HttpException: Maximum request length exceeded.'Is there a way to check file size on the client (without the use of ActievX which also errors out), before it is passed back to the server?
Sample code will be greatly appreciated.
We have a SSAS server 2005 running on a 64 bit server.
This server generates a error log file under D:\MSSQL\MSSQL.2\OLAP\Log\Error_Log.Log
This file is growing enormously. its current size is around 112 GB which is 5 times the size of the cube itself.
Is there any way we can control the size of this file by setting any max size property in the SSAS server.
any help would be highly appreciated.
I am little bit confused about multiple tempdb files.
Suppose i want to place tempdb on its own disk of 100 gb, and want to set the size of tempdb to 100 gb. So in near future it probably do not need to autogrow. To impliment multiple tempdb file i.e. 8 (as per MS recommendation), because we have 4 quadra core
processor that is total 16 processors. So how to set size for 8 tempdb file.
Pl provide detail with step.
I have an application that lets the use upload a pdf, I wanted to put a limit on the size the pdf can be. If the user tried to upload something too big I wanted to display a message to the user. I am trying to use a custom validator where it checks the size of the file and if it is too big it will set the "IsValid" to false. Is this the correct way to go about doing this? Is there a better way? When I test it, everything works in IE 8 and FF, but it does not work in IE 7 and can't figure out why.
Here is what I have so far, this is on my aspx page:
<td>Upload Board Book PDF:</td>
<td><asp:FileUpload runat="server" ID="PdfFileUpload" /></td>
<asp:RequiredFieldValidator runat="server" ControlToValidate="PdfFileUpload" ErrorMessage="*PDF is required" Display="Dynamic" ForeColor="Red" ValidationGroup="add" /><br />
<asp:CustomValidator ID="FileUploadCustomValidator" runat="server" ControlToValidate="PdfFileUpload"
OnServerValidate="FileUploadCustomValidator_ServerValidate" ErrorMessage="*File must be less then 20mb