SELECT OBJECT_NAME(object_id) AS TableName ,

name AS IndexName ,

type_desc AS IndexType ,

CASE WHEN is_unique = '1' THEN 'UNIQUE'

...

This worked for me

CAST(Tbl.date as DATETIME) + CAST(Tbl.TimeFrom AS TIME)

I have tested this in SQL Server 2008.

Fix the statement to read like this:

ALTER TABLE...

Run this to see all your history... and no UI necessary 🙂

get-eventlog System | where-object {$_.EventID -eq "6005"} | sort -desc TimeGenerated

This article defines many options to speed up the backup, maybe it will help

http://henkvandervalk.com/how-to-increase-sql-database-full-backup-speed-using-compression-and-solid-state-disks

You may use [File is a Directory] instead of [File Exist] to check if the UNC path is folder, not file.

If object_ID(N'tempdb.dbo.#File_Results') is not NULL

Drop table...

EXEC [msdb].[dbo].[sp_send_dbmail]

@profile_name = 'DBA TEAM',

@subject = 'DBCC Results',

@recipients = 'lmacdonald@mywebgrocer.com',

...

Have you checked the box to compress the backup? There is lots of air in many databases.

Justin Manning SA (10/13/2015)

-- The following resulted in the following error message:

DBCC CHECKDB (ObfuscatedName);

/*

Msg 945, Level 14, State 2, Line 18

Database 'ObfuscatedName' cannot be opened due to inaccessible files...

Hope this will help you out: http://blogs.msdn.com/b/sqlcat/archive/2015/07/08/sql-2014-clustered-columnstore-index-rebuild-and-maintenance-considerations.aspx

SQL Sentry & Dell both are great monitoring with user-friendly interface

The error occurs due to following reasons: -

[font="Times New Roman"]The OLEDB provider is not yet installed.

The OLEDB provider is not registered.

[/font]

Review the list of linked servers defined on the...

Double-click the MSI to start installation.

In the Open file dialog box, click Run to start the Installation Wizard.

Follow the wizard to complete the installation