Viewing 15 posts - 8,176 through 8,190 (of 8,416 total)
Tao Klerks (4/28/2009)
SELECT *
FROM SomeTable
WHERE (SomeColumn >= '2009-04-01'...
April 28, 2009 at 4:06 am
craig.lovegren (4/28/2009)
April 28, 2009 at 3:58 am
Tao Klerks (4/28/2009)
Interesting approach - we use Convert, relying on the fact that DateTime values are internally stored as floating-point values, with every whole number representing a day
The FLOAT method...
April 28, 2009 at 3:45 am
benr (4/28/2009)
April 28, 2009 at 3:37 am
Tao Klerks (4/28/2009)
The following statement is untrue: "it is always a good practice to use DATEDIFF method for date comparison instead of making comparison using logical operators (,=)".
Agreed.
Tao Klerks (4/28/2009)
April 28, 2009 at 3:04 am
henrik staun poulsen (4/28/2009)
Is SQL Server able to use indexes when using DateDiff(Day, D1, D2) = 0 ?Best regards
Henrik Staun Poulsen
FTFY 🙂
The answer is yes.
But only if:
There is an index...
April 28, 2009 at 2:40 am
I can't resist it.
You lose physical/hardware redundancy because water leaking onto a box running four VMs downs four servers.
In Active/Active you can run at close to full tilt so long...
April 27, 2009 at 9:21 pm
andrew.hatfield (4/27/2009)
Sometimes you just can't win 🙂
True. It has been a fun discussion. We clearly disagree and I guess that's ok.
andrew.hatfield (4/27/2009)
April 27, 2009 at 7:08 pm
andrew.hatfield (4/27/2009)
April 27, 2009 at 6:44 pm
andrew.hatfield (4/27/2009)
By definition those success stories are based on experience.
...or marketing deals :laugh:
andrew.hatfield (4/27/2009)
April 27, 2009 at 6:25 pm
Hey good answers Flo.
Never be afraid of posting theoretical or odd examples of stuff without a production requirement!
And yes there is always someone that knows more about a given subject...which...
April 27, 2009 at 5:01 pm
@Phil - Jeff convinced me that posting compiled code was a no-no. Even if tools like .NET reflector are available. Maybe Adam will post a script for you*...
April 27, 2009 at 3:46 pm
Adam Machanic (4/27/2009)
April 27, 2009 at 3:42 pm
Thank you to whomever fixed the formatting on this page!
I had to scroll right about 50 metres to find the reply button earlier... 🙂
@Flo: Yes scripting is easy, but if...
April 27, 2009 at 3:30 pm
Phil Factor (4/27/2009)
April 27, 2009 at 8:04 am
Viewing 15 posts - 8,176 through 8,190 (of 8,416 total)