Viewing 15 posts - 4,576 through 4,590 (of 7,484 total)
SQL Kiwi (4/18/2012)
Jeff Moden (4/18/2012)
He's done some awesome testing against some of the new LEAD functionality of SQL Server 2012.
An efficient algorithm out-performs an inefficient one? Who knew! ...
April 19, 2012 at 2:28 am
Lynn Pettis (4/18/2012)
Here is a our first challenge. No one should post again until we get what has been requested.
And for once CELKO posts something that seems eminently sensible...
April 18, 2012 at 2:20 pm
If you get into trouble with this sort of thing it's probably best to use the ISO datetime string format: yyyy-mm-ddThh:mi:ss.mmm - note that there is no space anywhere...
April 18, 2012 at 2:09 pm
Nice question. It's good to see some SQL 2012 stuff now and again.
I saw 0, 1, min(int), min(bigint) presented as options and decided I would have to find it...
April 18, 2012 at 1:44 pm
Henrico Bekker (4/16/2012)
got it wrong, as the correct answer wasn't listed.your syntax is wrong in, sequence wouldn't be created to start of with...no increment value, no 'AS'..etc.
The CREATE SEQUENCE...
April 18, 2012 at 1:31 pm
Koen Verbeeck (4/17/2012)
Carlo Romagnano (4/17/2012)
I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.
They will all be...
April 18, 2012 at 1:27 pm
Nice interesting question. Keep the 2012 stuff coming.
I answered it (correctly) on the basis of common sense (that works quite a lot for SQL server, perhaps more with each...
April 18, 2012 at 1:18 pm
Ernie Schlangen (4/17/2012)
April 17, 2012 at 3:00 pm
Evil Kraig F (4/16/2012)
Lynn Pettis (4/16/2012)
SQLRNNR (4/16/2012)
Sean Lange (4/16/2012)
Lynn Pettis (4/16/2012)
1. Get out a blank piece of paper.
2....
April 17, 2012 at 12:59 pm
Lynn Pettis (4/16/2012)
SQLRNNR (4/16/2012)
Sean Lange (4/16/2012)
Lynn Pettis (4/16/2012)
1. Get out a blank piece of paper.
2. Put your name...
April 17, 2012 at 12:48 pm
EL Jerry (4/16/2012)
L' Eomot Inversé (4/15/2012)
Revenant (4/14/2012)
Steve Jones - SSC Editor (4/13/2012)
Evil Kraig F (4/13/2012)
Some days, this helps:Or this (my drink of choice tonight)
The image does not display in my...
April 17, 2012 at 12:44 pm
Ernie Schlangen (4/17/2012)
sknox (4/16/2012)
April 17, 2012 at 12:26 pm
Revenant (4/17/2012)
EL Jerry (4/17/2012)
Daniel Bowlin (4/17/2012)
crookj (4/17/2012)
ProtractorAngle
Acute.
You pick either < 90 degrees or without cuteness (a-cute). 🙂
"El" Jerry.
Thinker
BTW, a suggestion that acute thinker is one that is not cute is...
April 17, 2012 at 12:09 pm
EL Jerry (4/17/2012)
Daniel Bowlin (4/17/2012)
crookj (4/17/2012)
ProtractorAngle
Acute.
You pick either < 90 degrees or without cuteness (a-cute). 🙂
"El" Jerry.
Right.
You pick 90 degrees or it's wrong.
April 17, 2012 at 12:06 pm
Viewing 15 posts - 4,576 through 4,590 (of 7,484 total)