New Functionality
-
I currently am having SS 2000 and I am also having Visual Studio 2005 Beta 1. They both seem to work well together. From what I hear VS 2005 is going to be released before SS 2005. I know that I am going to gain a lot if I swithch to VS 2005. Am I going to gain a lot if I switch from SS 2000 to SS 2005?
-
What makes you feel otherwise. I see loads and loads of T-SQL and functionality enhancements made to the SQL Server 2005 edition. I was really impressed. Can you tell me what is that you were looking forward in SS 2005?
Vinod Kumar (MVP-SQL Server)
-
One of the main things I am looking forward to is the ability to create SPs in languages that you are comfortable with. For example, I am comfortable with VB hence I can write my SPs in VB and I don't have to remember T-SQL. I am new in SS arena so I am not very familiar with T-SQL. I have more exposure to VS and VB. The new feature made available in VS are an absolute must for me. I have tried VS with SS 2000 and have felt that I can live with SS 2000. The thing is that I don't think I have enough knowledge about SS 2000 shortcomings that have been addressed in SS 2005. So I am unable to make an educated decision.
-
boy oh boy .... You really scare me on this. Understand that writing code on VB or C# is a great feature to have. But having said that T-SQL still exists and you cannot tell you will write anything and everything on VB or C#. I am not a big supporter of this. You can read my article on the very same subject: http://www.extremeexperts.com/SQL/Yukon/ManagedExecution.aspxI am an developer too. I like this feature. But I would use it with caution ONLY. Dont just exploit a feature for the very reason that it exists. There will be performance implications when you write only managed code in Yukon. As said in my article, I see the FCL has an amazing usage for string manipulation, RegEx, Crypto API's etc. These are fantastic candidates for writing Managed code. But T-SQL is best and great when it comes to SET based operations. So weigh each of the technology and then jump into implementation.
Just my $0.20
. I would leave the choice now to you ...Vinod Kumar (MVP-SQL Server)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply