Kwisatz78 (7/26/2012)

---

Hi thanks for the replies.

So there would be some manual intervention involved in certain scenarios, but I think they are something we could live with.

I am actually hoping we...

Sorry it was a...

TheSQLGuru (6/19/2012)

We cannot tell you which of these is best for your environment. LOTS of things come into play such as memory usage, latching, locking, CPU use, etc. ...

Thanks for the replies.

@Grant

Yes the whole optimization effort was done based on the readings of the execution plan.I have achieved significant gain in terms of the execution time(screenshot attached).

@opc.three

I did...

Ideally you shouldn't be having a log backup job when you have log shipping doing it for you.

Thanks.

There is absolutely nothing logged in there for that error.In fact before posting the issue on this forum I had thoroughly went through the installation steps multiple times to see...

Wow I am also facing the same issue for SQL 2012 Rc0 installation.

http://www.sqlservercentral.com/Forums/Topic1304837-1549-1.aspx

No its not sharing any of the host resources.The version is 7.1.4 build 385536

Is there a possibility that this is happening due to corrupt installation media ?

Its still running.

In the Task Manager "scenarioengine.exe" seems to be running and using the most memory.Not sure what that exe does.

Also you can deny view definition to the user

Deny View Definition To [User]

Isnt it more suited for OLAP than OLTP applications cause I think it is more of a read only index.

sp_change_users_login is going to be deprecated

http://msdn.microsoft.com/en-us/library/ms174378.aspx

Yes we have this weekend job...

Ok the data was deleted about 2 weeks back and I think in these 2 weeks approximately 100000 records might have been added as data from this table is archived...

Dev (1/2/2012)

---

I am not very sure how ‘sys.dm_db_index_physical_stats’ gets its data & how you retrieved 36 GB on Index space. But it’s very common that a file’s actual...