Viewing 15 posts - 1 through 15 (of 20 total)
CELKO (10/3/2011)
Instead of writing procedural code, why not do it with declarative set-orientated code?
thanks for the post and script, celko.
does your question refer to writing a...
October 3, 2011 at 10:58 am
I'd like to see the solution 'learning' about numbers that it knows will eventually reach 1 and therefore cutting corners
great idea, jamie. well worth having a go.
October 3, 2011 at 8:41 am
Carla Wilson-484785 (10/3/2011)
October 3, 2011 at 8:33 am
ABHILASH DHONGDI (10/3/2011)
might find this interesting...
IF OBJECT_ID('dbo.fn_TestCollatzConjecture') > 0DROP FUNCTION dbo.fn_TestCollatzConjecture
etc...
most impressive abhilash, thanks. just to be curious, did you write...
October 3, 2011 at 7:36 am
dennis.hafstrom (10/3/2011)
I do realize this was not the purpose of the article but it made me think of it so here's a recursive version.
nice 🙂
October 3, 2011 at 2:04 am
matt.bowler (10/3/2011)
It is when the problem space gets too large and complex that we need some of the more formalised structures to help manage the project.
Yep, agreed. ...
October 3, 2011 at 2:00 am
hi paul/gianluca,
thanks for your reponses.
the syntax i am using is
[font="System"] from TableOne t1 left outer hash...
September 7, 2011 at 9:07 pm
during a very technical interview, i was once asked to 'name three words that describe yourself'.
perhaps because my head was in technical mode, i stuttered and fumbled...
August 12, 2011 at 2:09 am
rob mcnicol (1/31/2011)
what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition, the 'For...
February 1, 2011 at 6:56 pm
great article, thanks.
what tweaks to this process are required to run a server-side trace on analysis services? when i export my Script Trace Definition, the 'For SQL...' options...
January 31, 2011 at 9:58 pm
choice names for the students
chur!
December 21, 2010 at 12:02 am
great article - thanks heaps.
oh, might it benefit from the addition of this little tweak near the start?
'you tell your boss he's off his rocker for suggesting that you work...
March 17, 2010 at 12:18 am
I am not sure whether or not you are stating that you are referring to licensing or referring to processor allocation. In a cluster I would not consider processor affinity...
July 6, 2009 at 4:31 pm
problem solved. turned out to be combination of the query design and bad data. specifically, a field that was joined to itself in a memory table...
July 6, 2008 at 9:06 pm
thanks ivanna, alas we've already tried that. the execution plan looks identical to "select * from ViewName" and has the same problem when it runs. ...
July 2, 2008 at 12:06 am
Viewing 15 posts - 1 through 15 (of 20 total)