THE SQL Server Blog Spot on the Web

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


You searched for the word(s):
Showing page 1 of 4 (34 total posts) < 1 second(s)
  • re: Do people want help? I mean, real help?

    I've been in the database businees for 18 years now, and I have never seen an application that is not longer supported due to a database version upgrade. Also, for this particular user, he has expressed frustration about deprecated features in the past.
    Posted to Peter Larsson (Weblog) by Peso on July 26, 2011
  • re: Do people want help? I mean, real help?

    A. Guru, I hear you but in this case it was about a deprecated procedure, so OP's code will fail and throw an error when upgrading to Denali at a later point. Even if you change the compatibility level, the old code will cease to work.
    Posted to Peter Larsson (Weblog) by Peso on July 26, 2011
  • Do people want help? I mean, real help?

    Or do they just want to continue with their old habits? The reason for this blog post is that I the last week have tried to help people on several forums. Most of them just want to know how to solve their current problem and there is no harm in that. But when I recognize the same poster the very next day with a similar problem I ask ...
    Posted to Peter Larsson (Weblog) by Peso on July 24, 2011
  • re: Splitting a list of integers : another roundup

    I am missing one &quot;RBAR3&quot; version where there is no string cutting at all, just moving pointers.. Do you have the time to test &quot;RBAR3&quot; too? CREATE FUNCTION dbo.fnParseList ( @Delimiter CHAR, @Text TEXT ) RETURNS @Result TABLE (RowID SMALLINT IDENTITY(1, 1) PRIMARY KEY, Data VARCHAR(8000)) AS BEGIN DECLARE @NextPos ...
    Posted to Aaron Bertrand (Weblog) by Peso on July 12, 2010
  • re: Relational division

    Already ahead of you. Posted here
    Posted to Peter Larsson (Weblog) by Peso on July 2, 2010
  • re: Relational division

    Oh, I thought the title said it all. The problem is to find an efficient query to deal with relational algebra. Mr Celko has a wonderful description of Relational Division and some examples here The problem is that they are not very efficient ...
    Posted to Peter Larsson (Weblog) by Peso on June 30, 2010
  • Relational division

    I came across an interesting post on Microsoft SQL Server forum this afternoon. It was a question about Relational algebra and the poster wanted to have an efficient query to solve his problem. The original title was ''Select parent ids that have exact match on child values (no more, no less)''. The problem could be solved with relational ...
    Posted to Peter Larsson (Weblog) by Peso on June 30, 2010
  • Another bin-packaging algorithm using recursion and XML

    This time I will show you an algorithm to do the dreaded bin-packaging using recursion and XML.First, create some sample data like this -- Prepare sample data DECLARE @Sample TABLE &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;( &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;RowID INT IDENTITY(1, 1) PRIMARY KEY ...
    Posted to Peter Larsson (Weblog) by Peso on June 30, 2010
  • Ten days left

    As some of you know, I was awarded Microsoft Most Valuable Professional (MVP) for SQL Server in July last year. Now it's time to see if I get my MVP renewed, or if I lose the award.I honestly believe it's a good thing MVP status only lasts for one year at a time. Knowledge is fresh. Things that worked in the past may not work any longer due to ...
    Posted to Peter Larsson (Weblog) by Peso on June 20, 2010
  • re: Bad habits to kick : relying on undocumented behavior

    Relying on documented (and well-known) functions is not that safe either. The change for REPLACE function broke our application when the behaviour for REPLACE changed in SQL Server 2008. We had the assumption the functionality was guaranteed, but it wasn't. See REPLACE here
    Posted to Aaron Bertrand (Weblog) by Peso on February 9, 2010
1 2 3 4 Next >
Privacy Statement