Yes

Max server memory limits the buffer pool. SQL uses additional memory over and above the buffer pool for things like thread stacks, backup buffers, linked server drivers and other. It's...

Well, no, it...

IsNull can be used on NVarchar columns, it can be used on any data type. It works fine on nvarchar

DECLARE @SomeValue nvarchar(4000);

SELECT isnull(@SomeValue,'The variable is null');

What exactly is 'not working'?

Snapshots are not primarily there to prevent data loss. Start with a good solid backup strategy, full and log backups.

Long-term recommendation - upgrade to...

Post the exact update you're running, because the two above will not update the values to null unless the parameter is null and the column value is already null

homebrew01 (11/18/2013)

---

Not sure if I'm reading it correctly

"Total Server Memory (kb)" shows a flatline at "100" in the graph. The "last", "avg", "min" and "max" boxes all show 3.2...

Task manager lies. Don't use task manager to check SQL Server's memory usage, it will often show far too low (limitation in Task Manager). Use performance monitor and the Total...

If you're going to add -g700, I would suggest dropping that to 2.5GB. Otherwise, 3GB for SQL buffer pool, 700MB for the MemToLeave, doesn't leave much for the OS.

It's not limited to web apps, and by the looks of your update, your code is vulnerable. Do not concatenate user input into a sql statement that will be executed....

Aside, do you know how vulnerable that is to SQL injection attacks?

Get the vendor's permission before you make any chances and ensure that you're not breaking support agreements.

Nothing wrong with that query. Let me guess, you're running it from a database with compatibility level set to 80. If that's the case, change the database context to master...

You can get service packs from...