.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 Space due to Queries

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
HI All,   I have a table which is pretty big- couple of billion rows. When I do a select on this query, I run out of disk-space on C drive. However, neither data nor log files on C drive so why would C drive run out of space? Any thoughts? Thanks in  advance.

View Complete Post

More Related Resource Links

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!

know the hard disk's SQL Server space available from SQL Query



I would be able to determine how much hard disk space is available on the Server with a SQL Query, and from an other computer on the LAN.


How can I do something?


Thanks for your help.

Not enough space on disk


Why did I get Error 6022: Not enough space on the disk. File: Model.edmx if I have more than 1GB space on the disk where project is located and 200GB on the system disk where Windows and Visual Studio was installed?

Backup SharePoint 2010 farm configuration settings only get an error for not enough disk space when



I am trying to do a backup the Backup using the Backup and Restore feature in SharePoint 2010 Central Administration.  I just want to backup only the farm configuration settings only.

so I followed the GUI 

Open CA Backup and Restore, checked the Farm checkbox,  click Next 

I chose the following:

Backup Type :  Full

Data to backup:  Back up only configuration settings

Backup File location  :   use an UNC shared location   \\servername\sharedname

at this point,  I see the Estimated disk space required is:   1.2 GB 

the server hard disk available space is  30 GB

but when i click the Start Backup,  i got an error in RED saying "There is not enough disk space. Free additional space on your hard disk and then try again. Approximate amount of space needed is 40 GB.   Amount of space free on disk:  30 GB."

Why is this happened?  and the estimated disk spaced required still showed at 1.2GB

If anyone had experience this problem and have a solution, please advice









Error displaying like not enough available memory or disk space for adding the excel



I am creating excel file and adding the values to the cells thorugh code.

Application is working fine without deployment, but when I deployed this web application in both in my local system  and server 2003 system I am getting the following  error.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

Then I changed the settings by going into component services and  for the "COM Security" tab I have added everyone,network,aspnet,interactive accounts and given full permissions.

Then I got the following error at this line "Workbook WB = app.Workbooks.Add(Type.Missing);"

System.Runtime.InteropServices.COMException: Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space 

disk space everything is fine. I am not getting what to do?

If any pointers please suggest me.


SSEE Dump Files eating up my disk space


Hi all,

I have SQL Express 2005 installed and 40G worth of logs in c:\windows\sysmsi\ssee\mssql.2005\mssql\log

When I delete all logs in starts to fill up again straight away..

Files are SQLDump001.log , SQLDump001.mdmp , SQLDump001.txt..

Thousands now appearing again.

How do I turn this off ?


There is not enough memory or disk space to complete the operation



When I try many times to open a word document I receive an error - 

Server Error in '/' Application.
There is not enough memory or disk space to complete the operation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: There is not enough memory or disk space to complete the operation.

Source Error:
Line 1994: word = new Application();
Line 1995: object fileName = filePath;
Line 1996: doc = word.Documents.Open(ref fileName,             //error here!
Line 1997: ref missing, ref missing, ref missing, ref missing,
Line 1998: ref missing, ref missing, ref missing, ref missing,

all code:

protected void Button1_Click(object sender, EventArgs e)

Disk SPace Alert.


Hi Everyone,

Is there any way to create the Disk Space Alert using SSMS. Till now, I seen many procedure to capture and trigger the net send to mail the recepients. Please any one let me know, is there any ways to create an alert using SQL Server 2K8 SSMS.

Thanks In Advance.


Ranjith Kumar Mohandas

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?


Which tier do Linq queries belong?


Started in middle of a new project.  Our design architecture uses an n-tier (not MVC - no controllers) structure with Presentation, Data, Business and Service tiers.  However the lead analyst has the majoriety of code all in the Business tier claiming it all contains Business logic.  Our data tier is nothing more than a single .dbml model of the primary database to support all of the Linq queries in the Business tier.  To my mind Linq queries and classes they use are data access and belong in the data tier  but our lead analyst says they contain business logic therefore have to be in business layer.  

Combining two LDAP queries


Hey guys, I have these two queries I'd like to combine into one.  Is there any way of doing it?
Query 1: (&(!cn=SystemMailbox{*})(&(&(ou>="")(name=executive*)(objectCategory=organizationalUnit)(ou=*operations))))
Query 2: (&(!cn=SystemMailbox{*})(&(ou>="")(name=50*)))
Thanks in advance.

Hey guys, I have these two queries I'd like to combine into one.  Is there any way of doing it?


Image processing, determine white space and crop



I have created a image upload for our ID card system to allow users to upload new images, edit them and submit for approval.  This is all working well with a combination of asp.net (c#) and jquery to give a seemless editor etc.

We have had a few users who I cannot believe have scanned a photo of themself and then just submitted it with the A4 page of white and little photo.

I am wondering if anyone can help with a suggestion on how I could possibly reduce the load of these coming through (I can't believe they can be this stupid), it stipulates UK passport standards.

Would my only option be to check for a single continues colour that occurs and if it reaches a certain percentage point say 60% then to just send back an error stating they need to crop the image.

Can anyone help with providing sample or that I can use to move this one on.

I am still in disbelief on this one.  the other one is they take a photo of whole body and other in it and cut straight down middle chopping the people out but supplying a photo that no use for an id photo card....but that I can't imagine being solved programatically as I need to determine where their face dimensions are and what percentage of the actual photo is taken up by it and if it below a threshold reject it.

Bitmap FromFile space "file not found"


I am using aspose.slides to create PPTx's. Some of the process involves loading jpg's from another server and including them in the presentation. This works fine in my development environment. When I upload the site to its server, the jpg loading fails.

I am trying to access jpg's on the other server by:

   oFS = New FileStream(sFile, FileMode.Open, FileAccess.Read)

This causes an access violation error when run from the server.

I also boiled the code down to reading the file directly:

   oImg = System.Drawing.Bitmap.FromFile(sFilePath)

This causes a file not found error.

We have narrowed the problem down to the fact that the File Path has a space in it. How does one solve this problem (while still keeping the space, there is a lot of legacy data)? I have tried replacing the space with %20 or +. I have tried using Server.UrlEncode. The error message always comes back with the encoding in place (like no decoding

Data Points: LINQ Projection Queries and Alternatives in WCF Services


LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It's great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.

Julie Lerman

MSDN Magazine May 2010

Data Points: Precompiling LINQ Queries


Did you know that by precompiling LINQ queries you might actually be degrading your app's performance if you're not careful? Julie Lerman explains how to ensure you're not re-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.

Julie Lerman

MSDN Magazine March 2010

Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

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

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