Viewing 15 posts - 3,916 through 3,930 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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 😉
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 30, 2012 at 6:58 am
SQL Kiwi (5/29/2012)
opc.three (5/29/2012)
Using ALTER TABLE ... REBUILD can actually make things worse in terms of fragmentation depending on the heap's DDL.What do you mean?
I mean that fragmentation reported in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 29, 2012 at 10:55 pm
Using ALTER TABLE ... REBUILD can actually make things worse in terms of fragmentation depending on the heap's DDL. If you're exploring the fragmentation of a heap as a means...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 29, 2012 at 1:19 pm
Viewing 15 posts - 3,916 through 3,930 (of 7,164 total)