Check out this link.

http://www.sanssql.com/2011/03/t-sql-query-to-find-number-of-instances.html

Remove auto grow option. This will restrict the Log file growth.

Regards,

Sandesh Segu

http://www.SansSQL.com

anything wrong??? 🙁

Guys,

How about the below queries which use only 1 table or view to get the required info.

Also the stress on the system will be reduced by using less number...

For more such scripts, tips and SQL related stuff, please visit http://sanssql.blogspot.com

For more such scripts, tips and SQL related stuff, please visit http://sanssql.blogspot.com

Check if the fact table have null values for sk's which are not present in dimensions, if exists then fix the null values for sk's and the cube be processed

NTLM is an authentication protocol used in various Microsoft network protocol implementations and supported by the NTLM Security Support Provider ("NTLMSSP"). Originally used for authentication and negotiation of secure DCE/RPC,...