Viewing 15 posts - 3,541 through 3,555 (of 8,416 total)
Garadin (5/3/2010)
Fleshed out example of what I was referring to:
Thanks for the code Seth! That explained it nicely.
May 3, 2010 at 8:09 pm
Goldie Graber (5/3/2010)
1. Impact. How much would insert speed slow down?
Very little. Run some tests.
2. Complexity. As mentioned before, the trigger logic would be complex. This would probably impact...
May 3, 2010 at 8:05 pm
I'm pretty sure Hugo posted the NULLIF 'solution' as a bit of fun - though the idea behind it is very clever and worth posting just for that.
My comment was...
May 3, 2010 at 7:58 pm
Hugo Kornelis (5/3/2010)
Using ISNULL can work around this - although the result is admittedly not trivial to understand:AND NULLIF(Column1, Column2) IS NULL
AND NULLIF(Column2, Column1) IS NULL
:w00t: Hugo!!! Yuk!...
May 3, 2010 at 9:55 am
Goldie Graber (5/3/2010)
Out of curiosity, what is the difference between a UDF that accesses data and a trigger that accesses data? Won't the trigger also get called once per row?
You're...
May 3, 2010 at 9:48 am
dmoldovan (5/3/2010)
I still think this is a useful addition 🙂
Um, I agree (didn't I say that?) 😉
May 3, 2010 at 9:43 am
Bhuvnesh (5/3/2010)
May 3, 2010 at 9:42 am
Bhuvnesh (5/3/2010)
yes this is partitioned table
I know - I was wondering why it is a partitioned *heap* rather than a clustered table. That's quite unusual.
May 3, 2010 at 7:18 am
dmoldovan (5/3/2010)
It's a general overview of aggregating over several columns. For me it was a good resource.
Yes, I agree. I just don't think it directly solves the particular problem...
May 3, 2010 at 5:39 am
dmoldovan (5/3/2010)
Also checkhttp://www.sqlmag.com/blogs/PuzzledbyTSQL/tabid/1023/entryid/12611/Aggregate-Over-Columns.aspx
Seems to be solving a different problem from that asked in this thread though...?
May 3, 2010 at 4:14 am
Sqlfrenzy (5/3/2010)
I haven't compared it with native backups and it's difficult because the problem is on production server.
Understood. Remember that COPY_ONLY backups are available if that helps.
May 3, 2010 at 3:49 am
Nine times out of ten a SQLCLR solution is faster than the Tally table and uses fewer resources:
This by MVP Adam Machanic:
Performance comparison:
http://florianreischl.blogspot.com/2009/09/high-performance-string-split-functions.html
Sample code:
CREATE ASSEMBLY Utility
...
May 3, 2010 at 3:26 am
Drammy (4/29/2010)
One particular INSERT statement is causing me problems. I have found that the INSERT statement stalls whilst TempDB autogrows.
INSERTs are fully logged in SQL Server 2005, and excessive...
May 3, 2010 at 3:17 am
Sqlfrenzy (4/29/2010)
May 3, 2010 at 3:07 am
pradeepmsbi (5/2/2010)
how to do exception in sql server 2005
SET ANSI_WARNINGS ON;
PRINT 1/0;
May 3, 2010 at 2:57 am
Viewing 15 posts - 3,541 through 3,555 (of 8,416 total)