Viewing 15 posts - 3,991 through 4,005 (of 7,168 total)
A solution using PrimaryFilePath will only account for the location of the primary data file for the database specified. If that database has multiple data files and one of those...
May 22, 2012 at 10:15 am
mw112009 (5/22/2012)
Is this tool free of charge ?
I am sure you will find all the information you need at the link I provided 😉
May 22, 2012 at 10:06 am
How many rows is your query trying to delete? What else is happening on that table while you are running your delete? Are you running the delete in a transaction...
May 22, 2012 at 10:00 am
It sounds like you did not do all the steps or you may not have a current enough build. What does this return on your system:
SELECT SERVERPROPERTY('Edition') AS Edition,
...
May 22, 2012 at 9:53 am
If all you are looking for are insert statements generated from an existing table then I would recommend the SSMS Tools Pack:
Generate Insert statements from resultsets, tables or databases
Insert statements...
May 22, 2012 at 8:58 am
pradeep.mohan (5/22/2012)
you mean 'Data conversion' component using next to multicast (OLE DB Source --> Multicast --> Data Conversion --> OLE DB Commend)
It will depend on the destinations. If all destinations...
May 22, 2012 at 7:20 am
pradeep.mohan (5/22/2012)
In my package source table and destination table datatype is different.So is it possible to transfer the data from Source to Destination?
Yes. Look into using the Data Conversion transformation...
May 22, 2012 at 7:08 am
What I see a lot of people chasing when thinking about implementing partitioning is 'partition parallelism'. The idea that if a query asks for data from multiple partitions were parallelized...
May 19, 2012 at 6:57 pm
So would you say this is simply one area where the concept does not transfer from Oracle to SQL Server? Oracle touts partitioning as a way to improve performance by...
May 19, 2012 at 11:09 am
GilaMonster (5/19/2012)
May 19, 2012 at 9:07 am
Uripedes Pants (5/17/2012)
you've helped me before and I really appreciate you and all the good folks on this forum. sorry it took so long for me...
May 18, 2012 at 3:43 pm
Jeff, your comments helped settle me down. It's nice to have a timeline now on when I might see the article accepted and potentially published. Thanks as always for all...
May 18, 2012 at 12:11 pm
Jeff Moden (5/18/2012)
Any idea when the first one is coming out, Orlando?
I do not. I have not received any feedback since submitting the article earlier this week. This being my...
May 18, 2012 at 8:53 am
Raunak Jhawar (5/18/2012)
I want to do one. One fo you and one for me 😛
Well, I was going to do three that build on one another so it would be...
May 18, 2012 at 6:55 am
Raunak Jhawar (5/18/2012)
I can take one on 'File Watcher Task", but will this article describe more about .NET classe "FileSystemWatcher" or any other task or .NET class in particular?
I got...
May 18, 2012 at 6:38 am
Viewing 15 posts - 3,991 through 4,005 (of 7,168 total)