You searched for the word(s):
Showing page 1 of 4 (35 total posts)
< 1 second(s)
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.
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.
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 ...
I am missing one "RBAR3" version where there is no string cutting at all, just moving pointers.. Do you have the time to test "RBAR3" too?
CREATE FUNCTION dbo.fnParseList
RETURNS @Result TABLE (RowID SMALLINT IDENTITY(1, 1) PRIMARY KEY, Data VARCHAR(8000))
DECLARE @NextPos ...
Already ahead of you. Posted here
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 http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the-sql-of-relational-division/
The problem is that they are not very efficient ...
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 ...
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
RowID INT IDENTITY(1, 1) PRIMARY KEY ...
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 ...
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