Viewing 15 posts - 31 through 45 (of 70 total)
Matt Miller (#4) (11/16/2009)[
Not that I care to get in the middle of a good brawl, but where is the presumption that a running total MUST be deterministic come from?...
November 16, 2009 at 7:30 pm
"Buying a DBMS like SQL Server (or Oracle or PostgreSQL or ...) to use only the standard features is like buying a scientific calculator and just use plus and minus"...
November 14, 2009 at 2:07 pm
Similarly I would like to see something like this possible into constraints as well (vertical constraints if you will). Setting check constraints relative to a preceding row is something quite...
November 14, 2009 at 2:06 pm
Joe Celko (11/13/2009)
November 14, 2009 at 1:22 pm
Tom Garth (11/13/2009)
I don't want to stir up a controversy so I'll word this carefully. I have never noticed a temp table or table variable that didn't return its data...
November 13, 2009 at 12:36 pm
Jeff Moden (11/10/2009)
Alexander Kuznetsov-291390 (11/10/2009)
In my experience, if we need running totals, then we have some unique order of rows to calculate those totals with respect to. Because we know...
November 10, 2009 at 3:59 pm
Jeff,
In my experience, if we need running totals, then we have some unique order of rows to calculate those totals with respect to. Because we know the running totals before...
November 10, 2009 at 1:52 pm
Jeff Moden (11/10/2009)
Alexander Kuznetsov-291390 (11/10/2009)
November 10, 2009 at 9:42 am
These are incredibly smart techniques, but after playing with such approaches I decided that I don't want to put it into production - they are just a little bit too...
November 10, 2009 at 7:48 am
I would avoid such approaches as overly complex. I don't even want to think if this is secure or not. It is so very much easier to just reuse code...
October 29, 2009 at 10:25 am
The following is incorrect:
"One warning - if you buy a SQL Server 2005 book, ensure you consult Books Online after reading through a subject. For instance, there are only four...
August 21, 2009 at 7:59 am
I want all these features completely out my way, disabled, invisible, so that there is no chance I can ever use them. Direct quote from Joel Spolski:
"But wait!" you say....
July 8, 2009 at 8:53 pm
I want all these features completely out my way, disabled, invisible, so that there is no chance I can ever use them. Direct quote from Joel Spolski:
"But wait!" you say....
July 8, 2009 at 8:49 pm
Very interesting. Yet this raises a lot of questions:
1. IMO a very big problem with database unit testing is its sheer slowness:
How does an SP call
EXEC dbo.TestEquals 1.5, @MyVar
perform...
June 30, 2009 at 8:57 am
Viewing 15 posts - 31 through 45 (of 70 total)