Viewing 15 posts - 166 through 180 (of 8,416 total)
Adam Machanic (10/3/2012)
Where's Florian these days?
Haven't seen him for ages on SSC. He is @Florian_Reischl on twitter, if that helps.
Voted.
October 3, 2012 at 7:24 pm
RBarryYoung (10/3/2012)
October 3, 2012 at 7:22 pm
RBarryYoung (10/3/2012)
I am using this one here: http://www.sqlservercentral.com/Forums/FindPost1356773.aspx, I had assumed that it was Paul's...
Yes that's mine.
October 3, 2012 at 7:06 pm
siggemannen (10/2/2012)
I have added my first connect item now: https://connect.microsoft.com/SQLServer/feedback/details/765777/sys-default-constraints-empty-for-temporary-tables-in-tempdb
Added my vote.
October 2, 2012 at 2:16 pm
SQLSACT (9/26/2012)
If the page in memory cannot accomodate the insert, does SQL then just bring an extra page blank page from disk into memory?
No, there's no need to do that....
September 26, 2012 at 11:27 am
Eugene Elutin (9/26/2012)
No! Sorry, I was not explicit enough. My post addressed to OP. :blush:
No worries, just checking in case I was expected to respond.
September 26, 2012 at 10:20 am
Eugene Elutin (9/26/2012)
If you work with monetary datatypes you should understand how SQL works with them and when rounding is performed.
Are you talking to me?
September 26, 2012 at 8:46 am
Matt Miller (#4) (9/25/2012)
Paul and I answered in the same vein
Ooo I missed that one - must have come in while I was writing mine. I might not have...
September 25, 2012 at 10:40 am
Grant Fritchey (9/25/2012)
That was a very thorough answer. I'll bet you it's not what he wants though. I'm still not sure where he's trying to get to.
My best guess 🙂
But...
September 25, 2012 at 10:26 am
terry999 (9/25/2012)
smallmoney type takes up to 4 bytesdecimal(9,4) can only store 21474.3647 but use one more byte
The ranges of the two types have been discussed already, but there...
September 25, 2012 at 10:23 am
Grant Fritchey (9/25/2012)
I'm not getting what this guy is after, so I'm clearly not helping. Could someone else check it out please?
I tried my best, but it is an awful...
September 25, 2012 at 9:44 am
Using prepare and a loop will be fine for a very small number of rows, but it will not scale well. Using prepare is effectively the same as creating...
September 25, 2012 at 9:42 am
EdA ROC (9/24/2012)
Paul - Can you give me an example of what you mean by 'break such queries up'? Maybe my example, or something simpler.
No, not CTEs; I'm referring to...
September 25, 2012 at 3:28 am
Viewing 15 posts - 166 through 180 (of 8,416 total)