You can get that info with sys.dm_db_session_space_usage and, at a more granular level, sys.dm_db_task_space_usage.

Pages are 8kB each, so multiply the alloc_page_count and dealloc_page_count values by 8 to get the number...

I generally use info from sys.dm_exec_connections to get that info:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ServerName,

@@SERVERNAME AS FullInstanceName, @@SERVICENAME AS InstanceName,

...

select count(*) as mycount

from partno_table

...is the same this as summing the individual counts.

If you leave the parenthesis off, the NOLOCK becomes a table alias, not a hint.

-- NOLOCK is not a hint here, it's an alias, and has no effect on the...

If you are using a query tool that can connect to pultiple instances, such as SQL 2008's SSMS or RedGate's MultiScript (there are several others), you can issue the following...

There is a create_date column in sys.objects, and there...

Do you have some sort of weekly deployments or script refreshes? If you drop and re-create a procedure, any explicit permissions granted for that procedure get dropped with the...

A couple things:

1. < and > are not allowed in attribute values. Change all of the "<Unassigned>" values to "& lt;Unassigned& gt;" (remove the spaces between "&" and...

MSDN Article "How to resolve blocking problems that are caused by lock escalation in SQL Server":

http://support.microsoft.com/kb/323630/en-us

Note: Sessions can deadlock themselves, due to parallelism. Rare, but it happens, and troubleshooting it is a real pain.

Not one hand clapping so much as the fingers getting into...

The problem is that the base string value must be assigned a datatype in order to be processed before it can be assigned to your variable. Even though that...

Correct. With SQL Server 2000, you cannot feed a TVF from the query itself.

SELECT *

FROM @source_data sd

CROSS APPLY dbo.ft_kulcs_lista(sd.kulcsok) fkl

Without seeing the table DDL, I'm guessing you're storing the encrypted values as varbinary. String values can easily be converted into binary values (each byte represents an ASCII character...

At 25 bytes per row, and only 700 rows, this is a tiny table taking up only a few data pages.

From Books OnLine, in the ALTER INDEX topic, under the...