It depends on whether the process is running in 32-bit or 64-bit mode. This is also true of DSNs. If you are referencing a DSN in your connection string when...

I am taking CDC to mean Change Data Capture.

Please don't cross post, it just fragments the conversation:

http://www.sqlservercentral.com/Forums/Topic1095501-392-1.aspx

LutzM (4/19/2011)

---

Brandie Tarvin (4/19/2011)

---

I'm going to violate the rule and add a "technical" question to The Thread under the caveat that I don't really need an answer for a problem...

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? 😀