Run EXEC sp_configure 'show', 1

reconfigure

EXEC sp_configure

Verify Priority Boost is set to 0, verify Max Server Memory (MB) is set below physical memory after leaving multiple GB for the...

Don't recode on a hunch??. Look at the astimated execution plan! Given that I too do not have that plan, and given your inserted data is not the large amount...

You need to look for 1 occurrence(s) of [an] I/O request. That I/O request lasted at least 15 seconds. Using a 10 second Solarwinds polling interval should be barely adequate...

Really depends on the before and after sys.dm_db_index_physical_stats, plus unit testing. Plans may become inappropriate if stats are not updated, so I would update them, even if the increase in...

https://technet.microsoft.com/en-us/library/bb490920.aspx?f=255&MSPPError=-2147217396, 3rd example

if [not] exist FileName command [else expression]

and

https://technet.microsoft.com/en-us/library/bb490987.aspx, 2nd example:

ren [Drive:][Path] filename1 filename2

Consider the header for pages 1, 2, and 3.

Data type binding/mapping is performed by the provider. For your situation that provider should be a Jet driver. Please check its documentation and/or post your question on an Access or...

I've always relied upon SELECT @@VERSION, because the version to which a client can connect is more important to me. My second choice would be to inspect the errorlog, after...

I assume that was accomplished using a T-SQL development effort. You may have to partition tables by machine name. Otherwise the subscriber could overwrite the publisher. If the publisher had...

Here is how Ola Hallengren creates a backup job step:

EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'DatabaseBackup - USER_DATABASES - FULL',

@step_id=1,

@cmdexec_success_code=0,

@on_success_action=1,

@on_success_step_id=0,

@on_fail_action=2,

@on_fail_step_id=0,

@retry_attempts=0,

@retry_interval=0,

@os_run_priority=0, @subsystem=N'CmdExec',

@command=N'sqlcmd...

Replace the RETURN and the PRINT with a RAISERROR, and any error severity that is greater than 10. I suggest trying severity level 11 (simply because your failure condition appears...

The full text index create statement's KEY INDEX clause is looking for a unique index or a primary key.

Do you have a unique index or a primary...

The bank is probably adhering to https://www.pcisecuritystandards.org/, which is useful for Sales :).

TDE is not compressible (pragmatically, you might be able to reduce file size by a pitiful...

@Databases = 'database1, database2',

To do what you want, change the Database Backup job step's parameters, not Ola's script. See Ola's web site for examples.

If you want different databases to be treated differently (when...