Viewing 15 posts - 1,426 through 1,440 (of 5,590 total)
I seem to recall reading that there is an example of this in the AdventureWorks database... it's also used when you are joining multiple tables, and the tables don't have...
May 3, 2011 at 2:03 pm
Nadrek (5/3/2011)
Craig Farrell (5/3/2011)
B'narg! Whaaaa? After a point I'd have expected the Perm table to stabilize more to the memory build.
Wow.
Try one of the two double-CTE versions I...
May 3, 2011 at 1:59 pm
Craig Farrell (5/3/2011)
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.10 to 20 Characters per Element:
B'narg! Whaaaa? After...
May 3, 2011 at 1:57 pm
This MSDN link might help explain it a bit better
May 3, 2011 at 1:35 pm
May 3, 2011 at 11:03 am
Jeff Moden (5/2/2011)
WayneS (5/2/2011)
mtassin (5/2/2011)
WayneS (5/2/2011)
May 3, 2011 at 10:46 am
ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
+10!
Yes, please do write a...
May 3, 2011 at 9:46 am
GilaMonster (5/2/2011)
Woot!!!!!!!!!!http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Congrats Gail!
May 3, 2011 at 9:29 am
GilaMonster (5/2/2011)
[Jim].[dba].[Murphy] (5/2/2011)
I understand 'the last one' (after BI) might have a 'M' both before and after the 'C'.You know, it just might. 🙂
Good luck with that! You're one...
May 2, 2011 at 2:07 pm
ramadesai108 (5/2/2011)
I am trying to store the number in a char field. Wayne has the correct answer. Thanks Wayne, that works.
I'm glad that it works... but you really shouldn't store...
May 2, 2011 at 1:05 pm
RIGHT('0000' + convert(varchar(4), MyNumberToConvert),4)
Edit: note that it's now a string, not a number.
May 2, 2011 at 11:33 am
mtassin (5/2/2011)
WayneS (5/2/2011)
Mark, the only possible explanation that I can give is the elimination of the disk IO. When I ran this test, I fully expected the physical tally table...
May 2, 2011 at 10:57 am
SQLRNNR (5/2/2011)
Stefan Krzywicki (5/2/2011)
WayneS (5/2/2011)
Stefan Krzywicki (5/2/2011)
And now I feel like I'm talking about breath mints...
So... what's the difference between a person with an alphabet soup of certs, and a...
May 2, 2011 at 10:43 am
Stefan Krzywicki (5/2/2011)
And now I feel like I'm talking about breath mints...
So... what's the difference between a person with an alphabet soup of certs, and a breath mint?
May 2, 2011 at 10:25 am
mtassin (5/2/2011)
WayneS (5/2/2011)
May 2, 2011 at 10:02 am
Viewing 15 posts - 1,426 through 1,440 (of 5,590 total)