GilaMonster (2/16/2011)

---

The other two cases I will use table variables are:

1) When the table variable is not joined to any other tables for the final query. Maybe it's used to...

I advise my clients to only use table variables in 2 (pretty uncommon) scenarios:

1) VERY high call volume sprocs where extra recompilations from temp tables may be an issue

2) VERY...

1) you are into some VERY complex stuff here that is CRITICAL to both high availability AND disaster recovery. you REALLY REALLY should get a qualified consultant on board...

You will get much better much more quickly by reading a few books on sql server development (and working through their examples) than you will by asking basic questions such...

Ramkumar (LivingForSQLServer) (2/15/2011)

---

Kevin,

as Server is running in 32 GB RAM, I forgot the possibility of keeping/reading all pages from memory irrespective of hard disk and fusion-io.

As you suggested, I 've...

rameshbhumi (2/14/2011)

---

Hi,

We are also seeing these Queries getting triggered from BO Server to Database. I would like to know what exactly the purpose of these Queries. It will be Great...

You have a very complex situation here and you have been hunting-and-pecking on a forum for 10 days now. Way past time to hire a performance...

Lock pages in memory would be about the worst thing you could do here -...

Michael Valentine Jones (2/14/2011)

---

Before you implemented the fusionIO drive, did you verify that the server was actually IO bound so that you could expect to see an increase in performance?

If...

Steve-3_5_7_9 (2/15/2011)

---

You should also look at disk contention (waits mentioned above). Disk contention will cause high cpu as processes are waiting for the disk and queuing up. SQL...

IIRC Idera's Diagnostic Manager has had a mobile interface for quite a few years now. I don't recall for what mobile platforms, but I think blackberry was one of...

What do you mean by manage?? If you mean do things like SSMS does then I think DBArtisan from Embarcadero is a great tool. If you mean MONITOR...

perform waitstats and IO stall analysis during day. Likely issues are too little RAM, too slow IO, BLOCKING, too little CPU power.

You have 32GB of memory. If you have small data, EVERYTHING will be sitting in the buffer pool in RAM and drive speed will be virtually irrelevant except for...

1) get rid of functions around columns in exists clauses

2) refactor exists into single exists

3) do not use explicit field for exists (unless NULLable issues are afoot) - use *...