Viewing 15 posts - 14,926 through 14,940 (of 59,063 total)
GilaMonster - Thursday, May 21, 2009 3:50 AM
Ian Scarlett (5/21/2009)
Why it doesn't work with a datetime2 must be down to the underlying datatypes Microsoft are using internally.
Datetime is...
May 31, 2017 at 7:46 pm
May 30, 2017 at 3:02 pm
May 30, 2017 at 2:16 pm
Personally, I wouldn't use either. Use a TIME datatype. It'll save you on a huge number of conversion problems and implicit casts in the future.
May 30, 2017 at 12:17 pm
I absolutely agree with Gail on ignoring the "fragmentation" you're seeing. Without writing a whole article about it here (Brent Ozar has several, which is where I got the idea...
May 30, 2017 at 9:10 am
This will likely be the 2nd to the last update on this wonderful community effort. Thank all of you again for the great help and ideas.
I've converted the...
May 30, 2017 at 8:50 am
May 30, 2017 at 8:20 am
That's a great idea, Eirikur. Simple and will have a major impact by probably reducing the amount of work that actually needs to be done to hundreds instead of tens of...
May 29, 2017 at 7:44 am
There's only one term that comes to mind after all the incredible tutelage I've received on this thread and what it has resulted in and that would be UNBELIEVABLE!
May 28, 2017 at 4:24 pm
Going for the brass ring... here's a progress report.
The following code does the "temp table" optimization that Eirikur suggested. It examined 84,817 execution plans, eliminated about 6% of...
May 28, 2017 at 3:10 pm
F
May 28, 2017 at 12:14 pm
May 27, 2017 at 9:59 pm
May 27, 2017 at 11:17 am
OMG. You folks are going to actually make me smart about XML. Eirikur, that's more in the direction of where Johan was going and that's awesome. Thanks for the demo.
May 27, 2017 at 9:46 am
Viewing 15 posts - 14,926 through 14,940 (of 59,063 total)