What version of SQL Server are you using? That is this poll. If you are not using a database listed on the poll, feel free to comment in this thread what database you are using.
Printable View
What version of SQL Server are you using? That is this poll. If you are not using a database listed on the poll, feel free to comment in this thread what database you are using.
SQL Server 2000
SQL Server 6.5
No poll response for that.
I also daily use MySQL, Oracle and Access besides SQL Server 6.5
I added a '6/5 or older' option.Quote:
Originally Posted by DHillard
This poll also allows for multiple selections.
Brad!
Databases not listed I use are from SQLite and equi4.
SQL server 6.5
I use Sybase Adaptive Server (Interprise edition) on Sun workstations
I use the Desktop Engine of MS SQL Server 2k...
SQL Server 2000.
Also MySQL for an older application (MySQL was a client requirement).
I use :
MS access
MySQL
MS SQL Server 2000
I choose from these products according to the requirements
from mini applications / sites to large applications that need a powerful DB with replication support etc...
I plan to use SQL Server 2005 when I find some time to try the beta.
I use SQL Server 2000 and SQL Server 7.0,
BTW :rolleyes: I have a question for Brad .... how come Database came in to picture in Core VC++ Forum :confused:
:D Of course you must have plan something GOOD :D
x8086
These surveys are for general interest to see what everyone is doing and using. There is no grand scheme on any of them (other than the first one I did). This forum contains a good portion of the core CodeGuru audience, hence why they are posted here.Quote:
Originally Posted by x8086
(As an FYI, I was talking with some of the SQL Server guys at Microsoft last night. They are really pumped up on SQL Server 2005.
Brad!
And what about BDE it has own SQL like routines and may work as SQL server
Quote:
Originally Posted by Brad Jones
Brad,
Since I have used SQL Server 6.5 to SQL Server 2000, most of the times
In new version Microsoft has added few 1 or 2 advance functionalities and other 90% are cosmetic changes, so I don’t think so that SQL Server 2005 will have something very different.
Bottom Line Is it doesn’t matter what the DATABASE Is or you are working on BESIC concepts Remain same in all the databases and across all the platforms , :rolleyes: Of course I don’t know whether other forum member will be agree with me or not !!!!!! :D
x8086
ok..Quote:
Originally Posted by x8086
I don't agree.
SQL Server 2005 has new features that I consider real changes...
CLR intergration,MARS,Web services support,native XML support and other T-SQL improvement...
I'm not a microsoft fan...But good things are good!!!
Check this article about new improvements in SQL Server 2005..You may change your mind;)
Sorry, but I also have to disagree for the most part. SQL Server 2005 is bringing lots of changes and improvements. I'll see if I can get an article created with some of the details for our site.Quote:
Originally Posted by x8086
Having said that--
If you are using a database in very minor ways -- accessing small amounts of data in simple table with no concern for speed -- then you are correct in that there is probably no need for a leading-edge database. If, however, you are using advanced features such as DTS, BI, replication, and using large quantities of data in complex fashions, then I believe you'll find upgrading to newer databases can be evolutionary. If you use things like Reporting Services and Analysis Services, then you're goingto probably want to upgrade.
SQL Server 2005 Express Edition is also the replacement for MSDE. This should also be a great improvement for those needing a small engine in their apps.
I just got back from Microsoft and part of what I did there was to be presented details on the features coming in SQL Server 2005. There is some very cool stuff in this release. There are CTP versions available if you want to check it out.
Brad!
This is interesting. What are the system requirments for SQL Server 2005? Does it require the .net framework installed on the system running it? If not, GREAT! If so, useless.Quote:
Originally Posted by Brad Jones
Personally, I avoid anything (feature) of one DBMS that makes porting my database applications from one DMBS to another. It's more work in the application development, but it doesn't tie me to one database vendor.
Being that stored procedures can be written in C# or VB.NET rather than T-SQL, I'd guess that .NET is required. (T-SQL can still be used, but C# and VB.NET let you do queries much more efficiently -- (less lines of code).
I'll see if I can find a list of requirements and post them.
Brad!
Seems yes..Quote:
Originally Posted by DHillard
Check the system requirements
Seems yes, and seems like it requires version 2.0 of the Framework (which is the current beta version).Quote:
Originally Posted by hspc
Brad!
SQLite