Go into SQL configuration manager, right click that SQL service and select Stop.

stevewes (9/23/2013)

---

our Help desk ticketing application gets lots of email request into a particular table and seem to break when it gets to 100 !! so it's so we can...

I can simplify that...

;

Um...

GilaMonster (9/25/2013)

---

You can't do it in one statement, because updating a column to one value and then updating it to another require two...

So update it, then update it back?

Update MyTable

SET City = 'B'

WHERE City = 'A';

Update MyTable

SET City = 'A'

WHERE City = 'B';

You can't do it in one statement, because updating a...

Indeed, but you don't use a jackhammer to put a nail in the wall. Powerful tool != use all the...

Koen's query will work because SQL does updates in two phases, first where it reads the data second where it changes.

If it's not doing what you want, please post actual...

Why are you altering model? If you're adding files to TempDB, add the files to TempDB, don't mess with model.

You've got the queries from profiler, so that should be enough to get started. If you're still having something outside of SQL allocating memory and forcing SQL to reduce its...

You can't.

Have you found and fixed whatever was allocating memory and forcing SQL to reduce its memory usage?

http://channel9.msdn.com/Events/Speakers/Mark-Russinovich The two Mysteries of Memory Management.

No.

Virtual address space is 2GB on 32 bit, many hundreds of TB on 64 bit. Commitable virtual memory is physical memory + page file size.

It's complex, there's a couple of...

That's not database corruption (you'd get errors from SQL if it was, not adobe)

Without seeing how you're importing, make sure that nothing's getting truncated anywhere or converted to incorrect data...

How do you know they're corrupt?

dan-572483 (9/24/2013)

---

On a related note (similar software versions but the opposite range of RAM)

Windows Server 2003

SQL Server 2005

1GB Ram

How to best divide the 1GB of RAM between the OS and...