Viewing 15 posts - 3,916 through 3,930 (of 7,168 total)
The free Microsoft SQL Server Migration Assistant (SSMA) makes it easy to migrate data from Oracle, Microsoft Access, MySQL, and Sybase to SQL Server. SSMA converts the database objects to...
June 1, 2012 at 1:05 pm
Points for showing your work so far!
I would urge you to look into the Conditional Split Transformation for SSIS. Also, I think tokenize is spelled with a z.
If you...
June 1, 2012 at 12:55 pm
Any diff between the perms serviceaccountname has on the problematic server and the ones acting proper? By perms I mean OS perms, Local Admin membership, etc. I am thinking there...
June 1, 2012 at 12:38 pm
I use compressed backups for full and log backups and have never had an issue. The only way to know is to test on your hardware. You have a non-trivial...
June 1, 2012 at 12:11 pm
I am in the process of migrating some 2005 database instances to 2008R2 but will have some boxes running 2005 packages against the new 2008R2 databases for a while. I...
June 1, 2012 at 12:05 pm
If the source and destination are the same then a stored procedure should suffice, unless you want to run some of the data through one of the SSIS transformation. At...
May 31, 2012 at 9:49 pm
Stop the SQL Server service or disable the service and reboot the server. Delete all the mdf, ldf and ndf files for the database in question. Start SQL Server and...
May 31, 2012 at 9:39 pm
I have to rescind my statement about possibly increasing fragmentation after rebuilding a heap on SQL 2008 using ALTER TABLE...REBUILD. I revisited my project notes and noted increased fragmentation in...
May 31, 2012 at 5:30 pm
SQL Kiwi (5/30/2012)
opc.three (5/30/2012)
Nice paper, I can tell a lot of work went into producing it, but I have a few issues with it.
You should comment on Alberto's blog and...
May 31, 2012 at 5:13 pm
ddonck (5/31/2012)
We've been trying to find out why one of our users can't log in through Windows Authentication. One of the problems we have run into is that this...
May 31, 2012 at 1:10 pm
I could not figure a way to do this natively either. Here is a convoluted option to add to your choices. You could output the bad data output from your...
May 30, 2012 at 3:04 pm
deep_kkumar (5/30/2012)
I know it depends on many factors.
It does depend on a lot of factors. So many that it is not worth trying to answer your question. This is not...
May 30, 2012 at 2:09 pm
amosafr2003 (5/30/2012)
Thanks a lot opc.three for taking time to answer my question.🙂
Anytime. Thanks for posting the solution for others to see. Check out SQLCLR when you have a moment 😉
May 30, 2012 at 8:27 am
SQL Kiwi (5/30/2012)
The issue is far more pronounced when adding a clustered index and then immediately dropping it in an attempt to defragment a heap, however the same behavior can...
May 30, 2012 at 7:37 am
SQL Kiwi (5/30/2012)
ashley.wardell (5/30/2012)
Or maybe write a new bulk insert CLR.I've seen this done before, and it worked very well using SqlBulkCopy. You might be tangentially interested in http://sqlblog.com/blogs/alberto_ferrari/archive/2009/11/30/sqlbulkcopy-performance-analysis.aspx
Nice...
May 30, 2012 at 6:58 am
Viewing 15 posts - 3,916 through 3,930 (of 7,168 total)