Setting max memory will do the job.

it might be . there could be another reason too like memory , IO , table/index scan happening. Please post the...

can you tell me what columns you need in report other then these tax(calculated) columns ?

and do you have any related query ?

A side question .

Does DML operations or index rebuild/reorg (or any other operations which grow the log file ) get impacted DURING the...

mahesh.dasoni (1/11/2013)

---

Logshipping is out of sync for 2 days and so i have a huge amount of logfiles to copy and restore to DR Server.Is there any way by which...

mahesh.dasoni (1/11/2013)

---

i have publisher & distributor on same server with pull subscription but after configuration of replication my publisher and subscriber are comes in sync but again after some...

Thats INCORRECT .In PULL subscription, The Distribution Agent or the Merge Agent runs at the Subscriber.

Couple of question

1) what is the...

CELKO (1/10/2013)

---

Since a table is a set, your table is “Customers” -- unless you have only one (sorry business is bad). It is called Strong entity; it can exist by...

NO , NUll is not...

see this link too http://blog.sqlauthority.com/2011/02/09/sql-server-pageiolatch_dt-pageiolatch_ex-pageiolatch_kp-pageiolatch_sh-pageiolatch_up-wait-type-day-9-of-28/

PAGEIOLATCH_SH means slowness in IO operations. this is the one cent which will come to anyone's mind who will look into your posts.its might be happening because BIg tables invole...

APA0876 (1/10/2013)

---

there is a SQL Query that is causing 90% of CPU on one of the SQL servers also it run in 14 seconds, on other server with similar specs...

ravi@sql (1/10/2013)

---

No actually i exported 3 lakh records with around 150 columns dude , i splitted the records based on source using query . for that only it...

Database admin(DBA) (1/10/2013)

---

please see the below query.it returns 3122 rows and query is running 0.55.indexs also their and but its running on views(its basicallly views)

so how to altered the query...