when i run xp_fixeddrives command to the drive that contains my tempdb, I obtain 10mb of free space, but the following query return other thing (45000 mb free).  other query :  USE tempdb; GO SELECT SUM(unallocated_extent_page_count) AS [free pages],  (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB] FROM sys.dm_db_file_space_usage;   this drive only contain my tempdb db.  what is my error?
We have a fairly big MS SQL 2008R2 database that resides on a SSD drive. The drive itself only has ~110Gb of space, and the database files are the only files on the drive.  The database is in "Simple" recovery mode, and only has two files, .MDF and .LDF.   The disk is now nearly full: the MDF is currently 109Gb in size. However, SSMS tells me there's nearly 18Gb of "Space Available" (in the 'General' properties page), and if I go through the motions of Shrinking the file it also tells me there's 18Gb of space free. SSMS also tells me the database size is around 132Gb, which surprises me - that wouldn't fit on the drive!  From what I've read, shrink is a really bad idea. However, I'm starting to see replication errors (could not allocate space for object). We've previously tried shrinking the database, but within a few hours the file was back to it's original size.  How should we proceed - given there's apparently 18Gb of free space, should SQL automatically use that free space? Or is it as simple as: we really need more disk space?
So, the spiffy new wi-fi thermostats want power on the C wire from thermostat, but the old thermostat doesn't have a C wire at it.  What's the easiest way to add the C wire/24 volt to the thermostat location? Apple Magic Trackpad multitouch configuration Word for a task which is flawed or doomed to failure but which you have to do anyway? Show that $\arctan\frac{1}{2}+\arctan\frac{1}{3}=\frac{\pi}{4}$ Show that $\arctan\frac{1}{2}+\arctan\frac{1}{3}=\frac{\pi}{4}$.   Attempt:  I've tried proving it but it's not equating to $\frac{\pi}{4}$. Please someone should help try to prove it. Is anything wrong with the equation? If there is, please let me know. Use of Website Category Landing Pages OK, here's the situation: A reasonably simple website with a primary navigation menu including drop-down list of sublevels on hover. Each navigation level may have 3 - 6 sublevels below it, none more important than the other. For example see this mockup:    My question is: What should happen if the user Clicks on one of the primary navigation options (such as 'News') instead of just hovering over and choosing a sublevel?  My instinct tells me that I should allow a click of this navigation option; it's expected user behavior to be able to click navigation options. If clicked then a landing page of some sort will be present listing all the sublevels (latest news, blog posts, case studies'). However there is no content to add to this landing page other than presenting a list of links, which is pretty useless. I could pad it out by adding iconography and descriptions of the sublevels, but that's just content for the sake of it; does 'Latest News' really need a description in order to understand what it is?  If I don't include a landing page then clicking this primary navigation will have to open something but if I open the 'Latest News' page that risks the user not knowing about the other sections of the site.  (The landing page will be useful for breadcrumb navigation too, so I don't really want to do away with it).  Is my thinking that a landing page showing the list of sublevels actually useful even though there is no actual content to display, or is there a better alternative to go with? I found this interesting problem in :     Given a point $P$ in space, and given a piece of malleable material of constant density, how should you shape and place the material in order to create the largest possible gravitational field at $P$?   Any ideas? I've been using mac for years, but prefer to do software development on windows. I'm really used to is using the folowing shortcuts on windows very much:  &lt;CTRL&gt;  + INSERT: Copy &lt;SHIFT&gt; + INSERT: Paste &lt;SHIFT&gt; + DELETE: Cut   Of late, I've taken to doing even my development work on the Mac. However, as a matter of habit, I'm missing these shortcuts very much. Actually, I find these a lot more convenient than COMMAND + (C/V/X) combo.  Is there a way to reassign these three shortcuts at least?   I've look all over the internet and in the "Keyboards" system preferences but I did not find anything.  PS: If you're wondering where I find the INSERT keys on a mac book pro, I use a wireless keyboard. Is it standard for graduate students to get gifts for their advisors? Is it standard for graduate students to give their advisors gifts around Christmas, like chocolates or bottles of wine?  What about other important people, such as their thesis committee members, or department secretaries? Interview: How to ensure that a thread runs after another? How can I set the default terminal used in Unity?  I would like to use the Ctrl+Alt+T hotkey to start a non-default terminal. The default terminal is gnome-terminal.   Where can I change the default terminal value? For some reasons, I would like to do an explicit quoting of a string value (becoming a part of constructed SQL query) instead of waiting for implicit quotation performed by cursor.execute method on contents of its second parameter.  By "implicit quotation" I mean:  value = "Unsafe string" query = "SELECT * FROM some_table WHERE some_char_field = %s;" cursor.execute( query, (value,) ) # value will be correctly quoted   I would prefer something like that:  value = "Unsafe string" query = "SELECT * FROM some_table WHERE some_char_field = %s;" % \     READY_TO_USE_QUOTING_FUNCTION(value) cursor.execute( query ) # value will be correctly quoted, too   Is such low level READY_TO_USE_QUOTING_FUNCTION expected by Python DB API specification (I couldn't find such functionality in  document). If not, maybe Psycopg2 provides such function? If not, maybe Django provides such function? I would prefer not to write such function myself... $16$ rooks on a chess board. Place $8$ pairwise non-attacking white rooks and black rooks on a $8\times8$ chess board. If one can swap rows and columns, is it possible for the black rooks to take the initial position of the white rooks and vice versa?  My attempt:  Let the rows be $a_1,a_2,...,a_8$ and columns $b_1,b_2,...,b_8$. If there are white rooks at ($a_i$,$b_j$) and ($a_j$,$b_a$) as well as black rooks at ($a_i$,$b_i$) and ($a_j$,$b_j$), then we can reduce it to a $2\times2$ and a $6\times6$.   I don't know what to do next. Any help appreciated. Why does my pilot light keep going out? My furnace pilot light keeps going out so I changed the thermocouple. Now the furnace will come on and heat up to the degree set on my thermostat, then the pilot light will go out and the furnace will not come back on.    Could the thermostat be bad and cause the pilot light to go out? MySQL INT meaning How to use an alpha map in Blender Render? using $$ in a post causes strange number series to appear pattern of moving electrons in wire under AC My webcam just came on "out of the blue" Meaning of backtick in floating-point literal I have critical low storage level and can't understand what takes much of it and how that's possible that the installed applications can use 7 GB? I only use a few social media clients without any games or soft like Photoshop. Also on the second screenshot it indicates that the apps are using just 1.13 GB and so I can't understand the situation. Also what is the "Other"?