Viewing 15 posts - 676 through 690 (of 1,825 total)
Good work one and all on the true / false nonsense, its very dispiriting when all you get is grief when you are trying to help.
My favourite part of...
September 13, 2010 at 12:12 am
Paul White NZ (9/3/2010)
Gianluca Sartori (9/3/2010)
Some things simply can't be done set-based in Oracle. Triggers, for instance, have to process modified rows RBAR.
Probably just as well - most people struggle...
September 3, 2010 at 2:04 am
Steve Jones - Editor (9/1/2010)
Brandie Tarvin (9/1/2010)
September 1, 2010 at 8:36 am
jcrawf02 (8/27/2010)
Dave, interesting idea for the "nugget" presentations for your Kent usergroup. Has anyone else done that? (5-10 minute presentations on a specific feature)
Ive done a few at the London...
August 30, 2010 at 8:53 am
First Kent Sql server user group done and dusted.
Start got delayed by filming of a Jack the Ripper tv show, not what i needed. Flustered enough as it...
August 19, 2010 at 6:23 am
Whats everyone's thoughts on the SSWUG newsletter ?
In todays there is a summary of one of my blog posts. It doesn't specify that it is a free web resource and...
August 16, 2010 at 7:30 am
Brandie Tarvin (8/12/2010)
Kwit larnin' things! That ain't what this here site be for!😀
Well not this thread anyway 🙂
Unless you count accent and bacon preferences.
August 12, 2010 at 7:44 am
Paul White NZ (8/12/2010)
Table variables have none, it is assumed that they will have 1 row.
True, unless the OPTION (RECOMPILE) query hint is used. If that...
August 12, 2010 at 7:40 am
jcrawf02 (8/12/2010)Just general knowledge seeking, not specifically trying to do anything with it 🙂
Remember that the optimizer uses statistics to decide to use an index. Table variables have none,...
August 12, 2010 at 6:32 am
Gianluca Sartori (8/11/2010)
That's GREAT, Dave! Congratulations! Don't worry, I'm sure you'll be exceptional!
Thanks for the vote of confidence, happy with my material , its just my skills at joining...
August 11, 2010 at 4:25 am
Jeff Moden (8/9/2010)
Dave Ballantyne (8/9/2010)
Woot woot , just got my speaker selection email for sqlbits. Time to get some material together now..
Congratulations and I understand the EXCITEMENT!!!!! :-P;-):-P;-)...
August 11, 2010 at 2:00 am
Woot woot , just got my speaker selection email for sqlbits. Time to get some material together now..
August 9, 2010 at 1:44 pm
The UK market is not buoyant by any means , and the pound is pretty worthless at the moment, but you should easily be able to double that rate here....
August 2, 2010 at 7:04 am
martin.whitton (7/30/2010)
Remember that if @date is a Saturday, then datepart(dw,@date)=7
Wrong , this is not a fact. @@DateFirst depends on regional settings.
From http://blog.sqlauthority.com/2007/04/22/sql-server-datefirst-and-set-datefirst-relations-and-usage/
SET LANGUAGE italian
GO
SELECT @@DATEFIRST
GO
----This will return result as...
July 30, 2010 at 2:33 am
Viewing 15 posts - 676 through 690 (of 1,825 total)