Viewing 15 posts - 2,086 through 2,100 (of 4,745 total)
please post the actual BCP command you are running.
October 25, 2010 at 12:55 pm
physical fragmentation can hurt performance. diskkeeper is one tool that can defragment disks whilst SQL is online.
October 25, 2010 at 12:52 pm
you will probably be sold a SQL2008 R2 backward compatibility license. Which means you are paying for R2 and could use it if you wanted, but the license allows the...
October 25, 2010 at 12:48 pm
this will look for the file on the C drive of the SQL server, is that where the file is?
October 25, 2010 at 8:30 am
Grant Fritchey (10/25/2010)
george sibbald (10/24/2010)
October 25, 2010 at 5:57 am
DataDog (10/25/2010)
The question that remains is whether archiving records in perfect equence will still result in a heavy rebuild(ie: engine might physically move all records "to the left" some distance)
no....
October 25, 2010 at 5:54 am
Brandie,
difficult one. I am always connected with sysadmin so difficult to know for certain what would stop working if my rights were reduced without testing lots of combinations. Pretty much...
October 25, 2010 at 5:48 am
Stefan Krzywicki (10/24/2010)
george sibbald (10/24/2010)
October 24, 2010 at 1:08 pm
I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans.
Whats the advantage over...
October 24, 2010 at 12:36 pm
A full backup only contains that part of the log needed to bring the database to a consistent point on recovery.
October 24, 2010 at 12:24 pm
GilaMonster (10/23/2010)
I did, however, play around with...
October 24, 2010 at 7:02 am
Oh - and never believe WIKI
October 22, 2010 at 4:38 pm
The books are misleading when they say 'physical' order. this is only true when index is first built.
You say yourself you thought all the pages would be 'painfully' reorganised if...
October 22, 2010 at 4:35 pm
I seriously doubt you need to be concerned about this, certainly not to the point of changing your index.
a clustered index only guarantees the logical order of data, not physical...
October 22, 2010 at 1:05 pm
SOX people in?
apply patches.
must be tons more but would have to think about.
Are they trying to take sa away from DBAs?
October 22, 2010 at 10:53 am
Viewing 15 posts - 2,086 through 2,100 (of 4,745 total)