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


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

This is getting silly

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :Sql Server
 
I have a database that I need to change one of the table values from INT to BIG INT because it no longer can count higher.  The database when created as a backup and I remove the indexes etc, is 109 gigabytes. I changed the database to be BIG INT and after it churned for hours, it ran out of disk space.  There was no drive space avalable. So, I removed stuff, had 300 gig free, and once again tried to change the datatype to big int. It ran out of disk space.  How can a 109 gig database require 300 gig, just to change to BIG INT for one table. So, I transferred it to another computer, restored and tried again.  And again it failed for using all the disk space.  This happened twice, at both 400 and 500 gigs of free space at the start. So, I cleared 700 gigs, and it is at 42 gigs of free space and still whirring.  What could possibly be going on that a database that is only 109 gigs, could require 600+ gigs just to redo from INT to BIG INT on one table?  I am thinking, whatever is going on is definitely not something that should be happening with a world class database. While I wait to see if 700 gigs is enough space free, or if it is once again going to use all of the free space, I am starting to get irritated and think that it is perhaps not the case that this is a world class database.  It shouldnt take so much disk space just t


View Complete Post


More Related Resource Links

Silly sintax question

  

I'm just discovering MVC with Visual 2010 using MS Training kit.

Can somebody explain me why we can always seefor the index view

<h2><%=ViewData["Message"] %></h2>


And the code generated by visual studio

<h2><%: ViewData["Message"] %></h2>


Is there any difference between %= and %: with any document on that

Regards

Alain



system tray icon !!!!! silly problem...a quickkkkkk help!!

  
hi all, BACKGROUND: I have created a windows service that runs a UI application .the UI application is a client that uploads file to a WCF service (hosted on IIS)..The requirement is ,that when the UI application runs it should fit into a system tray icon..and then work from there itself.. PROBLEM: I have used notify icon and  created a system tray icon.i used the below link  http://www.developer.com/net/net/article.php/3336751/C-Tip-Placing-Your-C-Application-in-the-System-Tray.htm My problem is ,when i click the icon in system tray,the windows main forms opens(normal size).when i minimize the window,it minimizez and goes to the left side and the title bar of the UI application is seen just above the START button of our windows.the title bar is movable as well !.. I read many articles but didnt help me out..i was happy when i saw the above link which is so simple to wrk with tray icon.. I would really appreciate any ones help...waiting eagerly for a simple solution guys!!! thanks MumtazMumtaz Surani

system tray icon !!!!! silly problem...a quickkkkkk help!!

  
hi all, BACKGROUND: I have created a windows service that runs a UI application .the UI application is a client that uploads file to a WCF service (hosted on IIS)..The requirement is ,that when the UI application runs it should fit into a system tray icon..and then work from there itself.. PROBLEM: I have used notify icon and  created a system tray icon.i used the below link  http://www.developer.com/net/net/article.php/3336751/C-Tip-Placing-Your-C-Application-in-the-System-Tray.htm My problem is ,when i click the icon in system tray,the windows main forms opens(normal size).when i minimize the window,it minimizez and goes to the left side and the title bar of the UI application is seen just above the START button of our windows.the title bar is movable as well !.. I read many articles but didnt help me out..i was happy when i saw the above link which is so simple to wrk with tray icon.. I would really appreciate any ones help...waiting eagerly for a simple solution guys!!! thanks MumtazMumtaz Surani

system tray icon !!!!! silly problem...a quickkkkkk help!!

  

hi all,

BACKGROUND: I have created a windows service that runs a UI application .the UI application is a client that uploads file to a WCF service (hosted on IIS)..The requirement is ,that when the UI application runs it should fit into a system tray icon..and then work from there itself..

PROBLEM: I have used notify icon and  created a system tray icon.i used the below link 

http://www.developer.com/net/net/article.php/3336751/C-Tip-Placing-Your-C-Application-in-the-System-Tray.htm

My problem is ,when i click the icon in system tray,the windows main forms opens(normal size).when i minimize the window,it minimizez and goes to the left side and the title bar of the UI application is seen just above the START button of our windows.the title bar is movable as well !..

I read many articles but didnt help me out..i was happy when i saw the above link which is so simple to wrk with tray icon..

I would really appreciate any ones help...waiting eagerly for a simple solution guys!!!

thanks

Mumtaz


Mumtaz Surani
Categories: 
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