Viewing 15 posts - 9,886 through 9,900 (of 11,676 total)
Nice and easy, thank you very much.
(Easy is not a bad thing, it is good for one's self esteem that it is not necessary to dive into BOL to find...
March 8, 2011 at 2:05 am
In the somewhat special case of ETL, I'd sometimes like to turn of logging.
If a data load fails, the destination table can be truncated and the load can start over...
March 8, 2011 at 2:02 am
If I'm not mistaken, the estimated buffer length is the sum of sizes of the data types of all your columns. If you have data types with variable size, you...
March 7, 2011 at 7:39 am
I have been looking around the net a bit, but I don't seem to find a solution for your problem.
You could try to convert the file to a more appropriate...
March 7, 2011 at 7:36 am
camiloaguilar1 (3/7/2011)
Thank you very much to both of you. I'll check that right know.
Great! If you have additional questions, don't hesitate to ask.
ps: it is my opinion that anyone working...
March 7, 2011 at 6:47 am
The first step you have to take is determine what the maximum timestamp is. You do this in a seperate Execute SQL Task and you store the result in a...
March 7, 2011 at 5:16 am
You downloaded the SQL 2008 version, which is different from the 2008 R2 version.
You can find the R2 download here:
March 7, 2011 at 5:08 am
goldspoon (3/6/2011)
In change data capture the new tables(Audit tables) are created in that database only.i want to give other database as destination (capture instance).. is it possible?
I do not think...
March 7, 2011 at 4:01 am
You'll need a recursive CTE for that.
This MSDN article explains the concept:
March 7, 2011 at 3:41 am
As datawarehousing is an important aspect of BI, I would recommend the Kimball's Data Warehouse Toolkit:
A great book with some introduction to the concepts of BI and a general overview...
March 6, 2011 at 11:49 am
eric.johnson 33562 (3/4/2011)
March 5, 2011 at 4:23 am
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Congratulations!
March 5, 2011 at 4:11 am
jcrawf02 (3/4/2011)
Koen Verbeeck (3/4/2011)
According to this thread, some dll's should be registred to solve the error:Register the xml parser dlls with the below commands.
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
Thanks Koen, I'll check it...
March 4, 2011 at 2:45 pm
Viewing 15 posts - 9,886 through 9,900 (of 11,676 total)