From what I can make out, it is a serialized file of your db model and is used as a cache for improving the performance of deployment. It is unique per user thus should not be checked into source control. 

Why is `SELECT *` bad practice? Wouldn&#39;t it mean less code to change if you added a new column you wanted?

I  understand that `SELECT COUNT(*)` is a performance problem on some DBs, but what if you really wanted every column?

Why is SELECT * considered harmful?

I wonder, what&#39;s the easiest way to delete a directory with all its files in it?

I&#39;m using `rmdir(PATH . &#39;/&#39; . $value);` to delete a folder, however, if there are files inside of it, I simply can&#39;t delete it.



Delete directory with files in it?

What is the function of the DBMDL file in a visual studio database project?

What is the function of the DBMDL File in VS database project

<p>What is the function of the DBMDL file in a visual studio database project?</p>


What&#39;s the keyboard shortcut for Visual&amp;nbsp;Studio to display the IntelliSense box if one accidentally hits &lt;kbd&gt;ESC&lt;/kbd&gt; and wants the box come back again? 


Visual Studio keyboard shortcut to display IntelliSense

Using C#, Visual Studio 2010.

There is a namespace called [System.Web.Mvc](http://msdn.microsoft.com/en-us/library/system.web.mvc.aspx) documented on MSDN. The documentation for all the types in that namespace says that they are in `System.Web.Mvc.dll`.

However, when I go to Add Reference, “.NET” tab, this assembly is missing from the list. Why?

Why is System.Web.Mvc not listed in Add References?

I&#39;ve just been beaten (rather hardly) on the head by some non-trivial warning from Visual Studio 2010 (C++).

The compilation gave the following output:

&gt; 1 Debug\is.obj : warning LNK4042: object specified more than once; extras ignored  
&gt; 1 Debug\make.obj : warning LNK4042: object specified more than once; extras ignored  
&gt; 1 Debug\view.obj : warning LNK4042: object specified more than once; extras ignored  
&gt; 1 identity.obj : error LNK2019: unresolved external symbol `void __cdecl
&gt; test::identity::view(void)` (?view@identity@test@@YAXXZ) referenced in function `void __cdecl test::identity::identity(void)` (?identity@0test@@YAXXZ)  
&gt; 1 identity.obj : error LNK2019: unresolved external symbol `void __cdecl test::identity::make(void)` (?make@identity@test@@YAXXZ) referenced in function `void __cdecl test::identity::identity(void)` (?identity@0test@@YAXXZ)  
&gt; 1 range.obj : error LNK2019: unresolved external symbol `void __cdecl test::range::is(void)` (?is@range@test@@YAXXZ) referenced in function `void __cdecl test::range::range(void)` (?range@0test@@YAXXZ)  

Linker errors are always a pain to debug... but there were unresolved references, and so I checked... but the source is well-formed... and finally it hit me:

My folder hierarchy looks like so:

    src/
      identity/
        is.cpp
        make.cpp
        view.cpp
      range/
        is.cpp
        make.cpp
        view.cpp

and so does the hierarchy in the Solution (I always set it up so that it mimicks the &quot;real&quot; folder structure).

And the diagnostic outputs:

    Debug\is.obj
    Debug\make.obj
    Debug\view.obj

Along with a warning which says that the `.obj` has been passed twice to the linker and that one will be ignored.

Search no more: Visual has neatly flatten my folder hierarchy, and therefore is unable to neatly compile the source.

At the moment, I am simply thinking of renaming the files, that should cover the issue...

... but is there a way to have Visual Studio NOT flatten the file hierarchy ?



Visual Studio 2010&#39;s strange &quot;warning LNK4042&quot;

I am working on a C project and can not figure out how to pass command line arguments to my main function in Visual Studio 2010 Express Edition. I want to debug - how do these command line arguments work?

Passing command line arguments in Visual Studio 2010?

What is the real difference between these two options? What I know is:

**Register for COM Interop**  
This options executes regasm on the assembly and registers the assembly as an COM component(or maybe not) in the registry with all COM like registry entries.
Does this step generates a TLB file? What else is done?

Sometimes I see a tlb is generated when I compile the project but sometimes not, why is this? 

**Make assembly COM visible**  
What effect does this one has on an assembly? If I have the following type inside this assembly, do I still need to specify the &quot;Make assembly COM Visible&quot; even though my type is marked as ComVisible?

    [GuidAttribute(&quot;02810C22-3FF2-4fc2-A7FD-5E103446DEB0&quot;), ComVisible(true)]
    public interface IMyInterface
    {
    }


&quot;Register for COM Interop&quot; vs &quot;Make assembly COM visible&quot;

I&#39;m in the research phase trying to adopt 2012 Database Projects on an existing small project. I&#39;m a C# developer, not a DBA, so I&#39;m not particularly fluent with best practices. I&#39;ve been searching google and stackoverflow for a few hours now but I still don&#39;t know how to handle some key deployment scenarios properly.

1) Over the course of several development cycles, how do I manage multiple versions of my database? If I have a client on v3 of my database and I want to upgrade them to v8, how do I manage this? We currently manage hand-crafted schema and data migration scripts for every version of our product. Do we still need to do this separately or is there something in the new paradigm that supports or replaces this?

2) If the schema changes in such a way that requires data to be moved around, what is the best way to handle this? I assume some work goes in the Pre-Deployment script to preserve the data and then the Post-Deploy script puts it back in the right place. Is that the way of it or is there something better?

3) Any other advice or guidance on how best to work with these new technologies is also greately appreciated!

**UPDATE:** My understanding of the problem has grown a little since I originally asked this question and while I came up with a workable solution, it wasn&#39;t quite the solution I was hoping for. Here&#39;s a rewording of my problem:

The problem I&#39;m having is purely data related. If I have a client on version 1 of my application and I want to upgrade them to version 5 of my application, I would have no problems doing so if their database had no data. I&#39;d simply let SSDT intelligently compare schemas and migrate the database in one shot. Unfortunately clients have data so it&#39;s not that simple. Schema changes from version 1 of my application to version 2 to version 3 (etc) all impact data. My current strategy for managing data requires I maintain a script for each version upgrade (1 to 2, 2 to 3, etc). This prevents me from going straight from version 1 of my application to version 5 because I have no data migration script to go straight there. The prospect creating custom upgrade scripts for every client or managing upgrade scripts to go from every version to every greater version is exponentially unmanageable. What I was hoping was that there was some sort of strategy SSDT enables that makes managing the data side of things easier, maybe even as easy as the schema side of things. My recent experience with SSDT has not given me any hope of such a strategy existing but I would love to find out differently.

How to properly manage database deployment with SSDT and Visual Studio 2012 Database Projects?

I&#39;ve got a database project as part of my solution in Visual Studio 2013. Been working perfectly for the last 3 weeks and now suddenly today it won&#39;t build and so I cannot publish any changes. I&#39;m getting an MSBuild error: 

&gt; &quot;C:\Program Files
&gt; (x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(513,5):
&gt; Error:  MSB4018: The &quot;SqlBuildTask&quot; task failed unexpectedly.
&gt;     System.MethodAccessException: Attempt by method &#39;Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.OnCreateCustomSchemaData(System.String,
&gt; System.Collections.Generic.Dictionary`2&lt;System.String,System.String&gt;)&#39;
&gt; to access method
&gt; &#39;Microsoft.Data.Tools.Components.Diagnostics.SqlTracer.ShouldTrace(System.Diagnostics.TraceEventType)&#39;
&gt; failed.&quot;

Anyone got any ideas? All I did this morning was pull down the latest changes from source control. I can&#39;t see how that would mess up the actual `MSBuild` process, and the guy who checked in last doesn&#39;t have any issues at all. 


Visual Studio 2013: Database Project MSBuild error

I created a new SQL Server Database Project in VS2013 (Update 3) and attempted to build but it fails.  The only build output I receive follows:

    ------ Build started: Project: Database1, Configuration: Debug Any CPU ------
    	Creating a model to represent the project...
    Done building project &quot;Database1.sqlproj&quot; -- FAILED.
    
    Build FAILED.
    ========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

If I build the project via MSBuild.exe with detail verbosity I see the following inner failure:

    Task &quot;SqlBuildTask&quot;
      Creating a model to represent the project...
    Done executing task &quot;SqlBuildTask&quot; -- FAILED.

After searching the web I have tried the following to resolve this to no avail:

-Restart VS 

-Restart machine

-Repair VS Update 3 and reboot

-Repair VS2013 and reboot


What am I missing?

VS2013 Database Project fails to build

Assuming we have a database project called `MyDatabase` then a file called `MyDatabase.jfm` appears in the root of the project directory.

- It is exclusively locked while the project is open in Visual Studio
- It is a binary file
- It has only started appearing recently (past couple of days)

I have done a Google search, which has not offered any insight. There are some references to some old software, but most of the results are spam/trojanware. I have also looked in SO, but that has not produced any results either.

**Does anyone know what it is and why it&#39;s there?**

The plan is to add it to the [gitignore file for Visual Studio][1], but I need to know what it is first to submit the PR...

**UPDATE**

This is now breaking the Team Explorer Changes view. There are no changes being shown with the following from the Output window:

[![Screenshot of the error from the output tab][2]][2]

As such I will be adding the file to the .gitignore file and [submitting the PR][3]. It would be good to eventually learn what this file is and where it came from...


  [1]: https://github.com/github/gitignore
  [2]: http://i.stack.imgur.com/wUWHC.png
  [3]: https://github.com/github/gitignore/pull/2028

Content Type	Original Author	Original Content on Stackoverflow
Question	Jet Basrawi	View Question on Stackoverflow
Solution 1 - Visual Studio	Cameron McGrane	View Answer on Stackoverflow

What is the function of the DBMDL File in VS database project

Visual Studio Problem Overview

Visual Studio Solutions

Solution 1 - Visual Studio

Delete directory with files in it?

Why is SELECT * considered harmful?

Attributions