Viewing 15 posts - 136 through 150 (of 692 total)
I'll add that recursion isn't much better than a While loop and is sometimes worse.
I beg to differ. Recursion (in T-SQL) is always worse than a while loop!...
November 24, 2008 at 6:44 pm
Ed W. (11/24/2008)
November 24, 2008 at 11:37 am
Joe Celko (11/24/2008)
CREATE TABLE Sequence (seq INTEGER NOT NULL PRIMARY KEY);
WITH Digits (i)
AS
(VALUES (0), (1), (2),...
November 24, 2008 at 10:36 am
jeffery.baynard (11/24/2008)
Itzik uses RECURSION, even faster.With nums as
(
Select 1 as n
Union all
Select n+1 from nums where n < 10
)
Select n
From nums
Sorry,...
November 24, 2008 at 8:41 am
CheeseMan316 (11/24/2008)
Adam Machanic (11/24/2008)
Just throw the CTE into an inline TVF. In my tests it almost always performs equally fast, and sometimes is even faster, than using a table.
Adam...
November 24, 2008 at 8:18 am
Just throw the CTE into an inline TVF. In my tests it almost always performs equally fast, and sometimes is even faster, than using a table.
November 24, 2008 at 7:59 am
Not only is the feature deprecated, but barely anyone used TEXTPTRs anyway 🙂
By the way, when I saw "text data pointer" I thought the question was talking about the 24...
November 3, 2008 at 2:25 pm
As others have mentioned, a sort is not the only option, and the NULL may or may not come first... No one actually showed this yet, though, so here you...
October 30, 2008 at 12:49 pm
sandeep.pote (9/23/2008)
We can add constraints on table variable like primary key, unique key and chekc constraints etc ......
We cannot create non clustered index on table variable ...
Just to clarify this...
September 24, 2008 at 8:15 am
Grant Fritchey (9/23/2008)
While our team has chosen nHibernate and not Entity Framework ...
Just keep thanking your lucky stars that they didn't choose EF... Here's a thread someone sent me yesterday...
September 23, 2008 at 9:02 am
Timothy (9/22/2008)
September 22, 2008 at 11:29 am
Timothy (9/22/2008)
In those cases you'd have to write some code yourself in the designer, it wouldn't be automatic...meh, never mind.
Exactly; doing that work would defeat the whole purpose of LINQ....
September 22, 2008 at 10:30 am
Timothy (9/22/2008)
Adam Machanic (9/22/2008)
Now if we could just get stored procedures that exposed well-defined output contracts, the sweet spot would be clear: LINQ to SQL to stored procedures.
Unless I'm missing...
September 22, 2008 at 9:56 am
Matt Miller (9/22/2008)
The overhead I'm talking about is comparing LINQ-enabled perf vs not. From what I can tell - there's a non-negligible perf penalty, just by adding in LINQ....
September 22, 2008 at 9:21 am
Matt Miller (9/22/2008)
September 22, 2008 at 8:59 am
Viewing 15 posts - 136 through 150 (of 692 total)