Viewing 15 posts - 3,646 through 3,660 (of 49,571 total)
Venki508 (2/7/2016)
So dont we have like this export script in Sql SERVERexpdp username/password schemas=scott exclude=table:"IN('emp','history')" directory=data_pump_dir dumpfile=test.dmp logfile=data_dump_dir:test.log
Hugo Kornelis (2/7/2016)
February 8, 2016 at 1:38 am
kenny 40254 (2/7/2016)
February 7, 2016 at 2:58 pm
Take a full backup, copy it, restore, drop the tables you don't need. It'll be the fastest way of doing what you want.
Backups are of the entire database, there's no...
February 7, 2016 at 9:01 am
Venki508 (2/7/2016)
bcs some of the unnecessary tables having more than...
February 7, 2016 at 5:33 am
Partitioning is not for performance.
Spreading data across multiple files may give a performance improvement if the files are on separate IO subsystems and the current bottleneck is IO.
February 6, 2016 at 2:00 am
DBADave (2/5/2016)
Either way I’m not proposing folder limitations, rather tighter drive permissions.
It would have to be permissions at a folder level. Because NTFS permissions are folder/file based with inheritance...
February 5, 2016 at 2:08 pm
You need to drop the index, then alter the table, then create the index again. You can't alter a column with an index on it
That error is probably because you...
February 5, 2016 at 2:24 am
DBADave (2/4/2016)
It's not allowing drives to be restricted. Someone doesn't need to have access to a tempdb drive to store a backup.
How does SQL know that's a TempDB...
February 5, 2016 at 1:56 am
Drop the indexes, alter the column, recreate the indexes
February 5, 2016 at 1:42 am
Because it has to do with certain plan forms. Clear the plan cache and the next compile may generate a different for. It's not a fix though.
February 5, 2016 at 1:42 am
DBADave (2/4/2016)
The above statement makes me believe drive permissions get inherited from SQL Server for all backups.
Not inherited from. SQL runs the backup operation to disk, using its service account....
February 4, 2016 at 1:07 pm
jasona.work (2/4/2016)
The curiosity...
February 4, 2016 at 11:49 am
Phil Parkin (2/4/2016)
February 4, 2016 at 6:32 am
Are you moving to Azure SQL DB or to Azure VMs with SQL installed?
February 3, 2016 at 3:24 pm
Honestly, that's something that you should be discussing with your thesis advisor, after you've done a thorough reading of the scientific literature in the area. You also need to decide...
February 3, 2016 at 2:05 pm
Viewing 15 posts - 3,646 through 3,660 (of 49,571 total)