Viewing 15 posts - 3,961 through 3,975 (of 8,416 total)
You can also find out about the intended uses of SSIS by looking at some of the free samples:
April 9, 2010 at 10:54 pm
I use SSIS to extract, transform and load data from production systems to a data warehouse.
April 9, 2010 at 10:52 pm
peter-757102 (4/9/2010)
Strange, indeed column defaults and primary keys seem not be properly mapped transparently when applied to temp tables.
Constraints are always schema-scoped objects - see sys.objects.
This is true for 'real'...
April 9, 2010 at 10:34 pm
kajalchatterjee (4/9/2010)
So it is not Myth that table variables are stored in Memory but it seems tobe tru. Please let me know if am i missing anything.
Your code is not...
April 9, 2010 at 10:29 pm
Lynn Pettis (4/9/2010)
April 9, 2010 at 10:14 pm
RBarryYoung (4/9/2010)
This is actually a problem that I've seen with iTVFs before, the constant-per-row calculations just don't seem to get factored out by the optimizer...
This is why I tend to...
April 9, 2010 at 10:11 pm
david_wendelken (4/9/2010)
April 9, 2010 at 10:04 pm
Ninja's_RGR'us (4/9/2010)
Any luck on the clr routine?
Been busy on another thread - writing a SQLCLR routine to return the phase of the moon for a given date :w00t:
Blame Lowell. ...
April 9, 2010 at 9:54 pm
gsej.sql (4/9/2010)
Here's one:http://www.sqlmag.com/article/sql-server/sql-server-2005-system-diagram.aspx
GSEJ
That's a subscription site (luckily I am a subscriber) and the link therein takes you to the same link posted previously by Andrew 🙂
April 9, 2010 at 9:51 pm
Viewing 15 posts - 3,961 through 3,975 (of 8,416 total)