Have you checked the "non buffer pool" memory how much being uhsed there ?

from nvarchar(10) to nvarchar(300) plus XML.

nvarchar(30)

Jason-299789 (12/17/2012)

---

By any chance did you update one or more of the XML columns, as these (from memory) are stored as LOB's so pointers would be created to them hence...

see this link http://msdn.microsoft.com/en-us/library/ms177500(v=sql.105).aspx

mpradeep23 (12/17/2012)

---

Hi

We have a table which contains allmost 1 lak to 2 lak of records

querring on that table getting delayed give me idea how to make it faster

Thanks...

Boris Pazin (12/16/2012)

---

Is there any option to remove full text catalog from only second database, and not delete it because it should be used by first database. What will happen...

gad you found the solution yourself but in future always try to post table defintion , query you tried (though its incorrect) along with test data so that people can...

440692 I am just a number (12/14/2012)

---

I can go for a reboot out of office hours, but need to get it cleared by onhigh ( we offer a 24/7 SLA).I...

1) you can use the back compression method of sql server 2008

2) is the database is in full recovery mode ?

3) if the vendors request is one time...

avdhut.k (12/16/2012)

---

Hi John,

Thanks for the reply,

But I want to excute this SP Step by Step,

And If in any one of the SP error comes then next one should...

any reference for...

Did you mean to say that heavy DML operation consuming the space (like work table , tabl...

first you need to know what are these two terms

see link http://realworlddba.wordpress.com/2008/02/04/index-rebuild-versus-reorganize-whats-the-difference/

funny play 😛 😀 (to make the table empty)

use this in every database

select 'truncate table ' + name + '; ' from sys.objects where type = 'U'

this indicates that application (sql...