Viewing 15 posts - 1,906 through 1,920 (of 3,348 total)
john.arnott (1/2/2013)
January 3, 2013 at 1:29 am
john.arnott (1/2/2013)
Just testing to see if we're reading carefully? 😉
Looks as though your option 2 is screwed up somehow, returning dates years off.
SELECT dateadd(month, datediff(month, getdate(), '20110101'), '20101231');
........
January 2, 2013 at 3:48 pm
Not very happy with this question.
The first answer option is very clearly wrong - no idea where that 0.12 could possibly come from.
The other two options are the same. Arithmetically,...
January 2, 2013 at 3:50 am
Kevin Gill (1/1/2013)
Just to be picky, it actually won't work after the 28th Jan due to that dateadd of a month in there 😛
And to be even more picky, all...
January 1, 2013 at 4:38 am
SanDroid (12/27/2012)
Hugo Kornelis (12/21/2012)
My point is also not that I want the current implementation of UNIQUE removed from the product.
My point is that IF a feature is implemented that has...
December 27, 2012 at 12:41 pm
SanDroid (12/27/2012)
:ermm: You do not know the difference between creating a new TSQL batch and a control flow function? 😛
I don't even know what a control flow function is. All...
December 27, 2012 at 8:22 am
rals (12/27/2012)
From this we know that deleting records from the heap will not deallocate pages. Shriking will help to deallocate the pages from the heap ?
I know...
December 27, 2012 at 6:21 am
ronmoses (12/27/2012)
Yeah, I'm gonna need someone to draw me a picture for this one. 😉ron
I'm bad at pictures, so how about a step-by-step description of the query evaluation?
(Note that this...
December 27, 2012 at 6:02 am
gkganeshbe (12/26/2012)
Is there any performance difference in the below given three queries.Note: Col1 is NOT NULL column
SELECT COUNT(*) FROM Sales.SalesOrderDetail;
SELECT COUNT(Col1) FROM Sales.SalesOrderDetail;
SELECT COUNT(0) FROM Sales.SalesOrderDetail;
Not really. The second one...
December 27, 2012 at 3:57 am
L' Eomot Inversé (12/26/2012)
Here's where I get confused: Can Hugo's ";)" be a misprint for something else?
Nope!
When I started typing my first reaction in this topic, I was wondering whether...
December 27, 2012 at 3:55 am
Sean Lange (12/26/2012)
Hugo Kornelis (12/26/2012)
Thanks for a good question, Sean. I think I once read or heard that after deleting all rows...
December 26, 2012 at 4:05 pm
SanDroid (12/26/2012)
However part of your explination seems incomplete or missleading.
If statements and other control flow language create new batches, and that...
December 26, 2012 at 4:03 pm
Basics? That's not how I would describe it! :w00t:
Thanks for a good question, Sean. I think I once read or heard that after deleting all rows from a page, a...
December 26, 2012 at 3:39 am
Thanks for the question, Steve.
And a very happy Christmas to everyone at SQLServerCentral.com
December 25, 2012 at 3:10 am
Viewing 15 posts - 1,906 through 1,920 (of 3,348 total)