Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Full Potential of SQL 2000


The Full Potential of SQL 2000

Author
Message
Tony Davis
Tony Davis
Mr or Mrs. 500
Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)

Group: Administrators
Points: 591 Visits: 1148
Comments posted to this topic are about the item The Full Potential of SQL 2000
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9438 Visits: 9517
Tony:

I see some UDF's in the Matrix workbench: They're not going to work on SQL Server 7.0. Smile

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45147 Visits: 39923
Heh... you know I'd show up with the idea that it "can all be done in T-SQL". Now, if we can just get Microsoft to stop deprecating stuff! Tongue

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Salvador S. Scardua
Salvador S. Scardua
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 79
Hello for All,

About Potencial of the Versions of SQL Server, in my company we migrated SQL Server 2000 for 2005, but all databases run in 8.0 compatibility mode.

I study Report Service 2008 and until now, any new feature did not maked a difference, and I´m think in implement the Report Service 2005.

Thanks,

Brazil
sausage.dog
sausage.dog
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 36
Why build using managed languages? Why build using object oriented languages? Why build using high level languages? Let's all go back to assembler.

The editorial is inane. Why would you want to do things the hard way when you've been given a productivity tool to do things simpler, faster. Why would you want to build anything on a platform at its end of life?

I get that the article is rhetorical, but most people don't jump on new features because they're new. They do it because it provides a simple framework to be more productive, more agile, cheaper to build, and easier to maintain. Just imagine what would happen to your proprietary SQL Server 7.0 framework the moment a body walks out the door.
steve dassin
steve dassin
SSC-Enthusiastic
SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)SSC-Enthusiastic (174 reputation)

Group: General Forum Members
Points: 174 Visits: 2077
Hello Steve,

I agree with you that while excitment sells it doesn't necessary mean progress. And not everyone wants to blow the same whistle and reach for the newest brass ring. But when it comes to things like matrix work benches there seems a need for a reality check too. What you are encouraging is to go where there is absolutely no intent. Yeah, you can play around. You can also try to manage an enterprises data with fortran. So it's not surprising that some spacecadets think nothing of using the server for factor analysis. If this is for 'real' and for 'real' data, then here's the check mate - that's crazy. Professionals know the tools for their trade, or should. You don't play chess with checkers. If you want to deal with matrices or multivariate analysis you go with the software where that's the intent. You check out the IMSL library, SAS, SPSS or BMDP. They've been around a hell of a lot longer than sql server and their stuff is burned in. You don't go cobbling together select and backdoor update statements. MS users should learn more about broads, as in horizons.

best,
steve dassin
www.beyondsql.blogspot.com
P.S. If you want real arrays in real data management you need look no further than the combination of Dataphor/Sql Server.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36166 Visits: 18751
SQL 2000 is a great, stable platform and it's served me well in many situations. I've had all kinds of businesses run well on it, including this one. We upgraded to 2005, but we didn't need to and SQL 2000 would likely run this site for a long time to come.

That being said, I'm not sure I'd continue to develop on this platform since support (mainstream) is essentially done and you never know when you'll run into an issue you need help on. People continue to find bugs all the time with new development.

SQL 2005 and 2008 are great evolutions of the product and I'd recommend them to anyone. However I'm not sure I'd upgrade existing applications without a good reason. Continuing development might be a reason to do so.

And thanks for the editorial, Tony. Nice to have a break.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Rudy Panigas
Rudy Panigas
SSC-Addicted
SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)

Group: General Forum Members
Points: 440 Visits: 1303
I like your question " Have I even got close to exploiting the full potential of SQL Server 2000?" This could also be asked of SQL 2005. With SQL Server or any other software, you will never see its full potential as long as new version get pumped out every 2-3 years. It's all about business and making money not about making SQL Server better...until the next version.

I really enjoy working with SQL Server as most of you, I only wish that instead of making new versions, why not just continues and add to existing foundation? Add features, functions, processes. All these could be additional dollars and you would only pay for the upgrades needed.

Just my cents worth.

Rudy



Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45147 Visits: 39923
That's exactly what SQL Server 2008 is... the ultimate service pack for 2005 Wink

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36166 Visits: 18751
It's always a balance. We complain and ask for things to be fixed, stabilized, sped up, and there are changes made in those areas, but it's a business and there is a push to implement new features to create sales.

I'm with you for the most part. I wish we'd get more stable every 2 years and then every 4 years a new version, but it looks like the other way. A new version every 30 months or so.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search