Viewing 8 posts - 1 through 8 (of 8 total)
A few months ago,there is the same issue in our live DB.
But I do not want to set MAXDOP and the cost threshold for parallelism.
Because such actions are palliatives, so...
December 24, 2012 at 11:27 pm
I have done a test.
There has two servers 192.168.1.129 and 192.168.1.173
1.Create an account and grant the db_owner permission to it. Then create a job on 192.168.1.173,but its owner is sysadmin.
The...
December 24, 2012 at 8:15 pm
For database log file space stats,you can run " dbcc sqlperf ".
dbcc sqlperf('LOGSPACE')
December 19, 2012 at 9:43 pm
please run this command.
ALTER INDEX [index_name ] ON [table_name] SET ( ALLOW_PAGE_LOCKS = ON )
December 19, 2012 at 8:56 pm
You can use the code as follow which use cursor to grant permission.
declare @sp_name nvarchar(300)
declare @sql nvarchar(300)
declare cursor_name cursor
for select quotename(b.name)+'.'+ quotename(a.name)
from sys.objects a inner join sys.schemas b...
December 19, 2012 at 8:49 pm
J Good's code most of the time is useful, because the service often won't restart, but in order to insurance, we need to monitor the server if there is a...
December 19, 2012 at 8:16 pm
Please provide the table,index structure and T-SQL statement.
December 17, 2012 at 8:57 pm
Viewing 8 posts - 1 through 8 (of 8 total)