I was just curious to know how it sends text alerts. Can you please explain? Thanks in advance.

Blitz index report will be a great addition to this report.

http://www.brentozar.com/blitzindex/

This script has a lot of potential to become one of the best free monitoring tools. The output HTML report looks so professional. Thanks a lot for putting in so...

The script doesn't work for SQL Server 2012. Especially the log area DBCC LOGINFO and memory

--SQL Server 2008 version

--SELECT physical_memory_in_bytes/1048576.0 as [SystemPhysicalMemoryMB],

--virtual_memory_in_bytes/1048576.0 as [SystemVirtualMemoryMB],

--(bpool_committed*8)/1024.0 as [BufferPoolCommitMB],

--(bpool_commit_target*8)/1024.0 as [BufferPoolCommitTgtMB]

--FROM sys.dm_os_sys_info

--SQL Server...

Could not find the XmlSourceDemo.dtsx package :hehe:

Hi Manu,

Thanks for your reply.

According to you if I use Upper(Name) then the policy will allow only if all the letters in 'dim' are DIM for a table name DIMCustomer.

But...

Both options A and B work perfectly.There is no problem with either of them.

But the answer says option B is the right one...:hehe:

Please give me back my point!!!:w00t:

I am pretty upset about the fact that the questions posted doesn't seem to be appropraitely matching with the options specified in the list of answers.

I don't seem to understand...

Hi,

I would like to know if you are passing all the parameters from the main report to the linked report.

I don't see any reason why you are unable to hide...

Hi,

I would suggest a small change in your MDX calculation assuming our [Dim Date] is a hierarchy containing all the levels of the time period.

Try using the below query in...

I am totally confused.

The explanation for the answer says that SQL Server 2005 SP2 or greater is required to be fully compatible with vista and office.

But the correct answer seems...