Phew, glad I am not the only one. It took me 30 minutes reading various articles online, and re-reading Gail's posts on this thread, just to get to to a...

Unfortunately BULK EXPORT does not exist. Please vote for the suggestion here:

http://connect.microsoft.com/SQLServer/feedback/details/224026/sql-engine-bulk-export-command

Just curious really, your index name has PK, but your DDL is only creating a UNIQUE CLUSTERED INDEX.

CREATE UNIQUE CLUSTERED INDEX PK_TABLENAME

ON dbo.TableName(ColumnA ASC,ColumnB ASC)

WITH DROP_EXISTING

ON NEWFILEGROUP

Is there a reason...

A derived table may not perform as well as an EXISTence check using a correlated subquery. Try something like this:

SELECT p.*

FROM People p

WHERE NOT...

What kind of trigger, AFTER or INSTEAD OF? Without seeing the trigger code and your table definitions it is difficult to say much. Also, are you receiving any error or...

You can either issue a series of ALTER PARTITION FUNCTION statements to create the additional partitions or you create a new table with the partitioning you want and then INSERT...

Thanks Gail, that helped. The relationship between virtual address space and physical memory, what relationship there is, is becoming more clear...I just stumbled into a really big topic.

You said "The...

Answer:

http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/bbc1c753-c5df-4d52-a567-c982cf506051

Something else worth checking immediately after an instance restart, as your process is running and after your process completes:

-- credit to Bob B: http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/bbc1c753-c5df-4d52-a567-c982cf506051

SELECT SUM(pages_allocated_count) / 128.0 AS CLR_memory_MBs

FROM...

I guess was thinking about it all wrong...if a 64-bit instance has 10GB memory allocated to it, I figured you may want to tell SQL Server to start out with...

Bob B said -g has no effect on 64-bit systems. Anyone else have a theory?

http://www.sqlservercentral.com/Forums/Topic1095860-391-1.aspx

Tomas, have you (re)considered writing a process in T-SQL to replace your CLR proc? 😀

Bob Beauchemin said no:

http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/edf53293-d8f5-4a3c-b395-d9d53d255dd6

I see the issue now...I assumed the query was telling us something specific about the section of VAS not allocated to the buffer pool, as set by using the -g...

Per the original post the DB server in question has 120GB physical RAM.

That's beside the...

asso.al-hamawandi (4/18/2011)

---

I had the same problem in the SSIS 2008 data flow package . I had a CSV (comma delimited) source data with one of the columns data quoted with...