Hello,

This error can also occur if the INBOX is full for the account running SQL Mail!

Regards,

Hanslindgren

Hi,

Well, XML is not thought for performance. If you are processing 7000+ rows and you want real performance, you should use CSV files or similar files with much less overhead....

Maqsood Ahmad: A sleeping connection at most cosumes a couple of KB of memory (totally neglible). If your application is not restarted then the connections will linger and save you...

Maqsood Ahmad:

Why do you think that SQL Server would destroy your SPIDs? Having SQL Server doing that sounds rather absurd...

Hanslindgren

And to summarize the topic on BOL:

BACKUP DATABASE NorthWind

TO DISK='C:\NorthWind.20080515.SQLBackup.Full.bak'

This is also an excellent link: http://www.sommarskog.se/arrays-in-sql-2005.html#CSV

TheSQLGuru (5/14/2008)

---

I wonder about this. Per BOL: "autoclose: When true, the database is shut down cleanly and its resources are freed after the last user logs off."...

I just wanted to point out that if the DB is being hit 600 times per minute no SQL Server Instance would close the...

Ensure that your constraints have/are created using the WITH CHECK option. If not, SQL Server will look att all your tables even if they do have corretc constrains on them....

toniupstny (4/29/2008)

---

Hi. I too had seen the SET QUERY_GOVERNOR_COST_LIMIT value out there in BOL . My question would be how could you be sure that all ad-hoc...

matt stockham (4/28/2008)

---

Gail was referring to resource governor ... new in 2008. It lets you assign connections to different workloads, then place those workloads into groups which can be...

I had these problems once with a coupld of tables.

I divided the data_space with the number of rows and got an absurdly high value.

I tried to find out why but...

Or use SET CONCAT_NULL_YIELDS_NULL OFF in your SP...

george sibbald (4/22/2008)

---

HAns,

I can think of no way to reallocate which is the primary filegroup.

possibly....

BACKUP DATABASE

add another file to the primary filegroup on your other drive

use dbcc shrinkfile(current primaryfile,emptyfile)

alter database...

Just wanted to point it out to help our friends/poster that might not know what system configuration which is most likely to cause this effect...

Regards,

Hanslindgren