quote:

---

Have you heard anything specific I can test???

---

Hmm, no not anything I can think of....

If I understand your question correctly, you have used double quotes as text qualifiers in your file or query, and you want to specify bcp to use them. If so,...

More-or-less no. It does use a little bit of memory (each connection uses 12 KB + (3 * Network Packet Size), default network packet size is 4KB), but you probably...

Are you running any DBCC commands or backups during the specific times your server is slow for the users?

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

It seems it uses just above 1 GB of memory. But this is the amount of memory it uses, not what it sees (sorry, didn't notice that this was what...

Antares, I have sometimes seen recommendations to use TOP instead of SET ROWCOUNT because the optimizer doesn't work very well with SET ROWCOUNT. I haven't tested enough to be sure,...

SELECT db_id('pubs')

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

Also, I do want the encryption to be done in the database, not in ASP/components.

---

Just...

There is no real equivalent to rownum in SQL Server. Depending on what you want to do, you can use the TOP keyword (SELECT TOP 10 a, b, c FROM...

As I work at a company that are specialized at designing search engines (that beat FTS or Oracle Context or other similar applications by a mile) I am the first...

Try checking what it says in SQL:

select * from master..sysperfinfo where counter_name = 'Total Server Memory (KB)'

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

Or, even better- "clock*" will find "clocktower", but "*tower" won't!

---

The simple answer is that this...

Have you tried running DBCC CHECKTABLE ('tablename') on this table? Have you tried restoring your backups to a new database, possibly on a different server?

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Andy, you are absolutely right. In the conditions mcinmx01 describes it is possible to use the /3GB switch to use up to 3 GB. But, since the question was how...

quote:

---

Or should we create a single connection for each user-session, then reuse for the duration of the session? (perhaps putting the...