Viewing 15 posts - 8,281 through 8,295 (of 8,416 total)
A good summary Barry.
In my experience, most 'proprietary' code is best kept hidden because it's quality is generally so lacking! I have yet to see any truly wonderful SQL...
April 19, 2009 at 6:42 am
Noel is exactly right - partition for manageability (for example the ability to rebuild indexes for a single partition) rather than for performance - at least in 2K5.
For performance, partitioned...
April 19, 2009 at 2:46 am
RBarryYoung (4/16/2009)
The inserted and deleted tables are created from the data that your current transaction just wrote into the transaction log....
Hey Barry,
That used to be so; howver SQL 2K5 uses...
April 19, 2009 at 1:11 am
steve dassin (4/18/2009)
...snarky and hutch 🙂
:laugh: but also :pinch: !!!
April 19, 2009 at 12:31 am
Hey Matthew,
The error code appears to be COR_E_OUTOFMEMORY.
Can you tell us a bit more about the server and SQL Server configuration please, especially as far as memory is concerned. ...
April 19, 2009 at 12:28 am
Jeff Moden (2/27/2009)
MrBaseball34 (2/27/2009)
So you must ALSO create a TSQL wrapper for them. Man, what good is having to do that?Someone must be nuts to use CLR SPs...
Heh... finally... someone...
April 19, 2009 at 12:12 am
Hey guys,
I can't help but wonder what is driving the perceived need to 'encrypt' at all?
If someone could explain that clearly for me, I'd love to add my $0.02 to...
April 18, 2009 at 11:36 pm
Steve,
We should start a new thread for the discussion of table 'variables'.
I want to respond, but this thread is for discussion of Jeff's article on cross-tabs and pivots.
Cheers,
Paul
April 18, 2009 at 11:27 pm
Hey everyone,
If you don't like what Steve's posting, just ignore it eh?
There's nothing more tedious than scrolling through pages of quoted-quoted-quoted-quotes with pointless snarky comments on the end.
Steve's product sounds...
April 18, 2009 at 10:37 pm
Phil Factor (4/18/2009)
I hate to disagree, ...
:unsure: Uh oh... :laugh:
Phil Factor (4/18/2009)
April 18, 2009 at 8:32 pm
Good answers, Jeff!
Amusing too.
Keep up the good work 🙂
Paul
April 18, 2009 at 8:25 pm
Hey Jeff,
Well that makes sense!
I would just add though that compiled code marked SAFE (as mine was) cannot access external resources:
BOL
April 18, 2009 at 9:15 am
Jeff Moden (4/17/2009)
I won't be able to test the CLR methods on my machine to compare apples with apples.
Why not Jeff? You don't need to compile any C# or...
April 18, 2009 at 7:12 am
Flo,
I was thinking originally of the second approach - a T-SQL chunking loop. However, the data access from CLR idea is intriguing - it would be nice to have...
April 18, 2009 at 6:50 am
Hey Flo,
Great stuff - the optimized CLR routines you and Daniel came up with are very impressive!
Note to self: don't pass strings - pass SqlChars!
Paul
April 18, 2009 at 6:41 am
Viewing 15 posts - 8,281 through 8,295 (of 8,416 total)