Viewing 15 posts - 25,096 through 25,110 (of 26,490 total)
Which means in dimensional table, if it is type2, it gets a new set of PK with every update. Thus, comes with the need of remapping the fact table's FK...
March 12, 2008 at 1:21 pm
We may know it, but some newbies may not...:w00t:
Heck, would you like to know what we paid? I'll PM you if you do.
March 12, 2008 at 1:08 pm
Not sure this is exactly what you are looking for but it has helped me and my co-worker with developing SSIS packages: Professional SQL Server Integratin Services 2005 (I...
March 12, 2008 at 6:48 am
As this is an SSIS forum, you can also use the File System Task.
😎
March 11, 2008 at 1:53 pm
You are missing a comma (,) after todate. Here is the corrected code:
SELECT id, todate,
STUFF((SELECT ' ' + comment
FROM TEST2 a
WHERE...
March 11, 2008 at 1:41 pm
I see you creating the @tableHTMLapplication at the top of the procedure, then importing the data, then I see to executions of the sp_send_dbmail procedure.
You are creating the body of...
March 11, 2008 at 11:43 am
I subscribe to SQL Server Magazine, and it is well worth the investment.
😎
March 11, 2008 at 10:25 am
Jeff, Only problem with that, what if they don't have the budget for Enterprise Edition? That puppy can get expensive at street prices, and most discounts that private industry...
March 11, 2008 at 10:14 am
Plus the cost of the Developer Edition is well worth the investment ($49 per developer).
As Matt also indicated, if you will not be deploying to Enterprise Edition, be sure to...
March 11, 2008 at 9:08 am
If its a staging table that is emptied and reloaded everytime, then I'm sorry but truncate would be faster.
What you may want to do is setup a seperate stage environment...
March 11, 2008 at 8:55 am
Jeff, the real killer in that process at my previous employer wasn't the cursor, but the data. About half of the processing time was a result of about 20...
March 11, 2008 at 6:31 am
When you say the lookup transformation failed, how did it fail? How were you trying to use it?
😎
March 10, 2008 at 11:05 pm
I agree with Jeff. That's what I started doing at my last employer when I was trying to learn more about Analysis Services and OLAP cubes. I created...
March 10, 2008 at 10:23 pm
Now for your other 2 questions.
Max number of columns: 1,024
Max number of rows: probably restricted by the amount of disk space available.
😎
March 10, 2008 at 10:19 pm
I'll answer your third question right now. Don't use text, ntext, or image data types in SQL Server 2005. If converting a SQL Server 2000 data base to...
March 10, 2008 at 10:15 pm
Viewing 15 posts - 25,096 through 25,110 (of 26,490 total)