Viewing 15 posts - 1 through 15 (of 21 total)
The default setting for truncation is failure / error.
from MSDN:
Fail Component The Data Flow task fails when an error or a truncation occurs. Failure is the default option for an...
July 13, 2016 at 9:10 am
BOL citation:
FOR ATTACH [ WITH < attach_database_option > ]
Specifies that the database is created by attaching an existing set of operating system files. There must be...
June 21, 2012 at 2:11 pm
I'd use Slowly Changed Dimension transformation - much simpler for support / development / performance optimization / etc.
January 26, 2012 at 8:37 am
I mentioned Visual Studio 2010 Ultimate or Premium Editions.
It has everything you need now - don't wait for 2012:-)
The only problem - no multi-sever deployment tool
December 30, 2011 at 8:53 am
Very long discussion... Visual Studio was mentioned just once I'd say...
Why do not use Visual Studio Database project functionality (with any code version control system)?
Use normal build functionality, get *.DBSchema...
December 30, 2011 at 8:12 am
Brandie Tarvin (2/4/2011)
Toreador (2/4/2011)
Brandie Tarvin (2/4/2011)
The trick is that date doesn't actually exist in some countries, including the U.S.
But given that the date does exist in many other countries, SQLServer...
February 4, 2011 at 2:05 pm
Executed without any problem as it was expected :unsure::Whistling:
Cannot add screenshot 🙁
What's the trick - missed point 🙂
January 26, 2011 at 8:40 am
Just wonder about user data meaning. If I have user defined table it means that it keeps user defined data.
Here the very simple example of filtered index on computed column
CREATE...
September 30, 2010 at 12:17 pm
There is a simpler alternative for using Script Task for emailing - just use Execute SQL Task with the following code
EXEC msdb.dbo.sp_send_dbmail @recipients='name1@example.com;name2@example.com',
@subject = @Subj,
...
September 14, 2010 at 1:10 pm
Hugo Kornelis (8/26/2010)
da-zero (8/26/2010)
September 8, 2010 at 9:08 am
michael.kaufmann (7/22/2010)
first of all thank you for compiling a QotD.
However, I do not quite agree with the solution.
'Unique' is just taking the definition of a clusterd or non-clustered index a...
July 22, 2010 at 6:56 am
dbowlin (7/15/2010)
Not being able to use an increment of 0 makes sense, so an error makes sense.
What about situations when you need table with the only row 🙂
Logically thinking system...
July 15, 2010 at 1:06 pm
JosephDMarsh (2/5/2010)
February 5, 2010 at 8:44 am
Viewing 15 posts - 1 through 15 (of 21 total)