GilaMonster (4/27/2009)

---

If you can't change the SQL code then, other than ensuring good indexes on the permanent tables, there's very little that can be done.

How many rows are in those...

Heh thanks. I was thinking same thing; but I don't have access to code. That is just my example, thanks for suggestion :D.

Thanks.

Mohit.

According to MSDN online yeap it can. This can happen because the server doesn't have enough memory, statistics are old or don't exist.

Have a read at http://technet.microsoft.com/en-us/library/ms190736(SQL.90).aspx.

Check...

Hi Robert,

That red line states the Cache for the Intellisense is not up-dated. When you create a table, or objects the intellisense does not update all...

Hi Jaya,

I think of two options...

1) If the files can be attached, then attach it and delete the database. This will delete physical...

Hi Gale,

This is an example from me, I created exact same style. I did not post their code; any recommendations I can do from SQL...

It can read from the log but to find out who executed a command it keeps track of commands executed in MSDB on the server in question. If you...

Hey...

Only other way I can think of doing this is if you bring the store proc over to the other side; and link the tables over... I think.

Mohit

Since you restored the master database from another server it might be having issues finding MSDB/Model databases which might be in different paths on your other server.

As DB2008 suggested look...

Heh, I am like Matt.

I started typing and stopped; because when I wrote an answer like "I expect", "I think". Someone told me not to reply to post if...

The Cache setting are subjective but in general I think more on write then read is recommended. I am not SAN expert ... But I would start with 50/50...

Many things can cause high DQL; thing you have to consider why? For example I had a system that caused high disk queue length the problem was not in...

Please don't cross post, it cases fragmented replies. Replies here.

Thanks.

Mohit.

By default primary keys are unique and clustered; if you create it on such wide key it will be very expensive primary key. Unless you create your primary key...

As Jeff was saying if you are using Transactions you will have to enabled MSDTC on the servers...

Thanks.

Mohit.