If your tempdb is on separate disks, then use it as much as possible.

You can also add some files each with equal size and equal auto-growth, and it will...

I've resolved the issue, simply, and want to share. I run

exec sys.sp_configure 'default trace enabled',0

reconfigure

and the timeout-type error is not being reported in the app log anymore.

Regards,

Igor

Hi

You can use this code for example

if object_id(@tablename) is not null

begin

print 'exists...'

--do other steps

end

else

begin

print 'doesn''t exist...'

--do other steps

end

Regards,

Igor

Check also the statistics of the tables that are taking part in the view.

Regards,

Igor

Reading chapter 4 - Memory management of book http://www.sqlservercentral.com/articles/books/76296/

will probably help you with wider scope of understanding some matters.

Regards,

Igor

Hi

1400+ virtual log files is a high fragmentation into the log file(s).

These three articles should be enough to understand how to configure your log

http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

http://www.sqlskills.com/blogs/paul/bug-log-file-growth-broken-for-multiples-of-4gb/

Regards,

Igor

Hi

No, you cannot go your way - according to http://msdn.microsoft.com/en-us/library/ms190273.aspx

You can go with the ADDs and DROPs of columns since there is [ ,...n ] in the syntax

Regards,

Igor

🙂

I'd have gone with the last option if I haven't reminded of this blog http://blogs.technet.com/b/microsoft_blog/archive/2014/03/18/sql-server-2014-released-to-manufacturers-will-be-generally-available-april-1.aspx

Today, you have everything on the i-net, you only need to know how to search for something and how to develop an approaching strategy to suppress it . There are...

Hi,

Should you have put the second expression of the Exists() into brackets?

SELECT

[Project Dim].[Project Title].Children on 0

FROM (

SELECT

Exists([Mandant Dim].[Mandant Name].CHILDREN,

{[User Dim].[Username].&[Peter], "User Mandat Fact"}) on 0

FROM [Security Concept])

Second, what about...

Note a quite low percentage of correct answers so far.

Hi,

1. You don't have to add all fields/columns, unless you must to. Indexed view is very close to table. It's biggest utility comes when the goal is to optimize aggregate...

Carefully designed question. Thanks.

"The revert operation failed" is the essential in the question.

I usually have an issue when other sessions are alive while trying to restore from a snapshot.

Regards,

Igor

Nice question! I love filtered indexes. They are very useful for the data mining algorithms.

Thanks

Igor

You...