THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2000   (RSS)
Showing page 1 of 2 (20 total posts)
  • Why people think some SQL Server 2000 behaviors live on... 12 years later

    A long, long time ago in a galaxy you can reach out and touch right now, ORDER BY in a VIEW meant something. If you had a view like the following: CREATE VIEW dbo.RubbishAS    SELECT TOP 100 PERCENT Trash        FROM ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 28, 2012
  • SQL Server v.Next (Denali) : Restoring a SQL Server 2000 database

    I guess the title should be, ''You can't restore a SQL Server 2000 database on Denali.''  I had the occasion just today to recover some data from a backup I took way back in 2008 (!) for a colleague who was still on 2000 at that time (again, !).  When I tried to restore the backup on my local Denali instance, I received this error ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 18, 2010
  • Which Edition of SQL Server 2008 R2 should you use?

    SQL Server 2008 R2 has just released to manufacturing (RTM’d) as I write this. With each new release, we make changes to the “Editions” we offer. A SQL Server “version” deals with the major changes in the product – and “edition” is a set of features and capabilities within that version (you’re welcome). So… definitely run over to ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 21, 2010
  • Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running on SQL Server 2000. Now, don’t get me wrong ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 6, 2010
  • SQL Server Best Practices: Protect CmdExec

    In SQL Server, there are times that you need to do things in the operating system, and to allow that there is a feature called CmdExec. This is not always a good thing –whenever you leave the confines of SQL Server and go out to the operating system, you can cause issues, not the least of which are security-related. This best practice is ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 3, 2009
  • If you are upgrading from SQL Server 2000 to 2008 and you never touched SQL Server 2005, then I feel sorry for you

    “I sense you skipped SQL Server 2005 in you...  Skipping SQL Server 2005 leads to a bigger learning curve...  A bigger learning curve leads to not knowing the product as well...Not knowing the product as well leads to suffering..Running in compatibility mode 8.0 is the path to the darkside.. SQL Server 2008 (mode 10.0) is the force...May ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 9, 2008
  • Not An April Fool’s Joke: SQL Server 2000 Mainstream Support Ends In A Week

    April 1st 2008 is the day on which support for SQL Server 2000 ends (and it is also my birthday)     SQL 2000 SP4 - currently supported; support ends on either 12 months after SP5 is released or on 4/8/2008 whichever comes first. Extended support under which you get only break-fix assistance via Premier ends on 4/9/2013. I am not ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on April 1, 2008
  • A year in review, The 21 + 1 best blog posts on SQLBlog

    A year in review, The 21 + 1 best blog posts on SQLBlog Best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 posts I enjoyed the most. But wait the year is not over yet. Doesn't matter no one will write anything good till next year anyway (prove me wrong and I WILL update ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on December 27, 2007
  • The Sad State Of Programmers Part 1 : The Phone Interview

    This is going to be a three part series. Part 1 The phone interview. Part 2 The face to face interview. Part 3 Some tips and observations   A while back I posted that we are looking for a SQL/.NET/FoxPro developer. I did this because we had a real hard time finding this person. I am happy to inform you that we did find this person and he ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on December 2, 2007
  • Return Null If A Value Is A Certain Value

    You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIFDECLARE @1 char(1)SELECT @1 ='D' SELECT NULLIF(@1,'D')REPLACEThis should not really be used, I just added it here to demonstrate that you can in fact use it.DECLARE @1 char(1)SELECT @1 ='D' SELECT ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on November 6, 2007
1 2 Next >
Privacy Statement