Possibly unused space?

select

[FileSizeMB]=

convert(numeric(10,2),sum(round(a.size/128.,2))),

[UsedSpaceMB]=

convert(numeric(10,2),sum(round(fileproperty( a.name,'SpaceUsed')/128.,2))) ,

[UnusedSpaceMB]=

convert(numeric(10,2),sum(round((a.size-fileproperty( a.name,'SpaceUsed'))/128.,2))) ,

[Type] =

case when a.groupid is null then ''...

The usage of memory reported in task manager from sqlserver isn't an accurate representation of the memory currently utilized by SQL Server. When you do not have your max server...

http://bwunder.com/ArchiveUtility.aspx

Actually, I think I got it ... I used Use as Windows credentials when connecting to the data source, and took off Impersonate ... appears to be working just fine.

AH! I know this has to be possible ...

Yeah I thought about that as well ... but not really a route I want to take ... was hoping there was something I was overlooking.

One more bump ... hopefully someone has had this issue ...

Well ... haven't had much luck ... anyone got something I'm missing here?

Thanks

For the time being I'm using sys.sysprocesses ... but I'd really like to find an alternative.

Thanks

Can anyone think of a better way to do the join? It’s not pretty, but this appears to be working …

SELECT

CASE

WHEN p.program_name LIKE 'SQLAgent - TSQL JobStep%' THEN 'Job:...

The thing that is really killing me is that if you cast the job_id from sysjobs as varbinary, it looks identical to the program_name in sysprocesses …

SELECT program_name FROM sys.sysprocesses

WHERE...

Haven't had much progress ...

Awesome ... but I need to get this into a view, no dynamic sql ...

I'm close, but having some serious issues when converting char to uniqueident ...

This is what I...

Also, do you know if the hex # in sysprocesses is always the same length? I am trying to figure out the best way to parse out the number to...

Woah, how is this possible? How can I convert that number to match the...