|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:54 AM
Points: 7,395,
Visits: 15,209
|
|
|
|
|
|
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 3:28 AM
Points: 4,977,
Visits: 3,926
|
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Thursday, March 18, 2010 2:19 AM
Points: 2,022,
Visits: 3,594
|
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:54 AM
Points: 7,395,
Visits: 15,209
|
|
Absolutely. The R2 release of GDR is a must. The GDR itself created the situation that allows the compound projects to work. The R2 release ironed out a lot of bugs.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of SQL Server 2008 Query Performance Tuning Distilled
For better & quicker help read:
How to Post Performance Problems
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:54 AM
Points: 7,395,
Visits: 15,209
|
|
Florian Reischl (6/24/2009)
Nice article Grant.
I'm still not the best friend of SQL integration in Visual Studio but I think the new database projects become better and better and it seems to be a good way to maintain base structure. Anyway I hope it will become better in Visual Studio 2010 and/or SQL Server 2011...
Thanks
Thanks Flo. I think there's nothing but improvements on the horizon for this. One thing that will cause... friction, is that in 2010, it's no longer a seperate product, but built right into the Developers Edition of Visual Studio Team System.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of SQL Server 2008 Query Performance Tuning Distilled
For better & quicker help read:
How to Post Performance Problems
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:54 AM
Points: 7,395,
Visits: 15,209
|
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 8:29 AM
Points: 46,
Visits: 342
|
|
Grant,
What do I need Active solution configuration and Active solution platform for?
This is a database project, not a C# one, so why am I exposed to and maybe even allowed to select Any CPU/x86/64 at all? These settings are completely irrelevant to my database development, are they not?
How does creating a server project speed up my development?
Could it be faster not to create it at all?
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:54 AM
Points: 7,395,
Visits: 15,209
|
|
Alexander Kuznetsov (6/24/2009)
Grant,
What do I need Active solution configuration and Active solution platform for?
This is a database project, not a C# one, so why am I exposed to and maybe even allowed to select Any CPU/x86/64 at all? These settings are completely irrelevant to my database development, are they not?
Yes, the CPU is irrelevant to your project (although I've never tried switching it). But the configuration works to allow you to set up environments and have the settings change on projects to match the environments.
How does creating a server project speed up my development?
Could it be faster not to create it at all?
Creating a server project doesn't speed or slow your development. It acts as a placehoder for server level objects, such as Logins. When you make a compound project using the server project, you can then create users that map to logins without errors within the project. Otherwise, if you try to map users to logins, you will get errors.
----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of SQL Server 2008 Query Performance Tuning Distilled
For better & quicker help read:
How to Post Performance Problems
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 8:29 AM
Points: 46,
Visits: 342
|
|
Grant Fritchey (6/24/2009)
Alexander Kuznetsov (6/24/2009)
Grant,
What do I need Active solution configuration and Active solution platform for?
This is a database project, not a C# one, so why am I exposed to and maybe even allowed to select Any CPU/x86/64 at all? These settings are completely irrelevant to my database development, are they not?
Yes, the CPU is irrelevant to your project (although I've never tried switching it). But the configuration works to allow you to set up environments and have the settings change on projects to match the environments.
I guess I know how and why configuration works, but IMO it is completely irrelevant so it shouldn't be there at all. Why do I need to waste my time to "have the settings change on projects to match the environments." Who cares?
How does creating a server project speed up my development?
Could it be faster not to create it at all?
Creating a server project doesn't speed or slow your development. It acts as a placehoder for server level objects, such as Logins. When you make a compound project using the server project, you can then create users that map to logins without errors within the project. Otherwise, if you try to map users to logins, you will get errors.
Well as a database developer I don't know and I don't need to know what the logins are, at least in the environment I work for. I create roles and grant permissions to them, and that's it, and that ends at the database level. Having to create a server project that I don't need seems to be a waste of time.
Having an unnecessary project sit in my solution is an even bigger waste of time, as it clutters my screen, slows down my searches, check ins, check outs etc.
Am I missing something?
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Thursday, March 18, 2010 2:19 AM
Points: 2,022,
Visits: 3,594
|
|
Alexander Kuznetsov (6/24/2009)
I guess I know how and why configuration works, but IMO it is completely irrelevant so it shouldn't be there at all. Why do I need to waste my time to "have the settings change on projects to match the environments." Who cares?
Me 
Since this project types are usually used for SQL Server 2005 or later the CPU configuration becomes really important if you start to develop CLR modules for your database. Maybe this information is a missing part but the configuration is not irrelevant in my opinion.
The more I learn, the more I know what I do not know
How to Post Data/Code to get the best Help"Numbers" or "Tally" Table
How to Post Performance Problems
|
|
|
|
