This. It's the stupidest option I've ever seen in a maintenance plan (back up tail of log being close)

If this is happening, it means...

You can't set master to single user mode and you don't need single user mode to run a normal checkDB.

Why are you running repair? What's damaged? Do you know what...

Honestly, the question is a little too vague to answer. Depends on any filtering done, the joins and a whole lot more.

paul.knibbs (8/12/2013)

---

Of course, if the server has less than 4Gb of RAM, then actually *using* the full 4Gb of virtual address space requires you to swap memory to disk, and...

A little vague, but in general

INSERT INTO @TableVariable

SELECT <column list> FROM dbo.Function(<parameters>)

SQL Server's configuration setting Max Server Memory.

With the max server memory configuration setting.

Easy method - drop them all and see which ones SQL recreates. Those are the ones it thinks it needs

Accurate method - google for which traceflag turns on the optimiser...

The select will take a shared lock, probably at the table level. The update will take an exclusive lock, can't tell what granularity without knowing more about indexes and data...

Look up the DMVs in Books Online, or google them. There are plenty of sample scripts available that use them.

That's a bit convoluted, you don't need two nested subqueries

select SubjectCode,SubjectName,Description

from Subject

Where SubjectCode In

(select SubjectCode

Where SubjectCode like 'BS%' and LessonDate = '20130305');

That'll do the same thing.

Does that subquery return...

On 32-bit windows, VAS is 2GB kernel, 2GB user, that's universal no matter whether the server has 10MB memory or 64GB.

Sure you can. Full backups do not in any way interfere in...

Identify what's using so much TempDB (the task_space_usage and session_space_usage DMVs), tune the culprits to use less TempDB.

SQL uses memory outside of the buffer pool (which is what max server memory sets). Nothing wrong, this is normal behaviour, however you cannot set how much extra. It's usually...