Viewing 15 posts - 451 through 465 (of 1,193 total)
BrainDonor (3/3/2014)
SQL Bits XII has finally been announced http://www.sqlbits.com/.
Cool! But, Telford? ...
March 3, 2014 at 5:09 am
Rodney Landrum (2/28/2014)
I would like to see Snow Crash by Neal Stephenson
Yes please!
February 28, 2014 at 5:28 am
chris.puncher (2/28/2014)
markradley (2/28/2014)
Gazareth (2/28/2014)
I always thought David Eddings' Elenium and Tamuli series would make cracking films.
The Belgariad and Malloreon by Eddings would also make a good film series I think....
February 28, 2014 at 5:25 am
I always thought David Eddings' Elenium and Tamuli series would make cracking films.
Peter Jackson may currently be exhausting people's taste for swords 'n' sorcery though.
Banks' Against a Dark Background would...
February 28, 2014 at 5:12 am
You could backup & restore using the 'with checksum' option which I think could replace the immediate need for a checkdb run - someone better versed than me in the...
February 25, 2014 at 3:29 am
It's a common gotcha, always good to be reminded of it!
One of the reasons I always always use aliases 🙂
February 24, 2014 at 4:00 am
Grant Fritchey (2/19/2014)
The nicest man in the world in real life by the way.
So I hear. All meant in good humour 🙂
Those boilerplate-esque posts just tickle me!
February 19, 2014 at 7:26 am
Grant Fritchey (2/18/2014)
February 19, 2014 at 2:32 am
LAG/LEAD in SQL 2012 would be the best bet I think.
http://technet.microsoft.com/en-us/library/hh231256.aspx
Otherwise, have you investigated the windowing functions?
February 19, 2014 at 2:27 am
I'll try and knock up an example for you, but I'm pretty sure I've faked table-level constraints using a function called by a CHECK constraint in the past.
Could #1 be...
February 17, 2014 at 10:25 am
Hi Brandie,
Went through a similar headache-inducing process myself a few months ago!
IIRC, Space Available = Total Size - Size of Log - SpaceUsed in data file.
Gaz
February 11, 2014 at 8:01 am
raulggonzalez (11/15/2013)
Gazareth (11/15/2013)
Bob Cullen-434885 (11/15/2013)
the function LEFT can return NULL values therefore the computed column is created as NULL
Just how can LEFT return a NULL when operating on a...
November 15, 2013 at 5:43 am
Bob Cullen-434885 (11/15/2013)
Odd, though, in the table designer, how...
November 15, 2013 at 5:41 am
Bob Cullen-434885 (11/15/2013)
the function LEFT can return NULL values therefore the computed column is created as NULL
Just how can LEFT return a NULL when operating on a CHAR(8) NOT...
November 15, 2013 at 4:28 am
Viewing 15 posts - 451 through 465 (of 1,193 total)