How to join all these tables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to join all these tables

Author

Topic

jagpalsingh4@gmail.com
Starting Member

3 Posts

Posted - 2008-04-09 : 10:37:58

Hi,

Hello how can we see the result of this query in single table . I am new with this and i dont know how to use join and all syntax.

SELECT request_session_id,resource_type,
request_status, request_type,request_reference_count,

resource_database_id FROM sys.dm_tran_locks

go

select getdate () as Date,@@servername as servername, name ,size*8/1024 as size_MB
from sys.master_files;

go

SELECT request_session_id,resource_type,
request_status, request_type,request_reference_count,

resource_database_id FROM sys.dm_tran_locks

select cpu ,memusage,hostname from sysprocesses

CREATE PROCEDURE dbo.usp_ShowAvailableSpace

AS

SELECT name AS NameOfFile,

size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB
FROM dbo.SYSFILES

GO

EXEC usp_ShowAvailableSpace

select * from sys.sysprocesses

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]

FROM (SELECT *, 1 x FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio')

a

,

(SELECT *, 1 x FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio base')

b

select * from sys.dm_exec_sessions

select creation_time ,last_execution_time,execution_count ,

total_physical_reads,last_physical_reads,min_physical_reads,

max_physical_reads,total_logical_writes,

last_logical_writes,min_logical_writes,max_logical_writes,

last_elapsed_time,min_elapsed_time,max_elapsed_time

from sys.dm_exec_query_stats

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2008-04-09 : 10:59:06

before talking about joins and syntax, do you have any idea whats the output of these queries?

jagpalsingh4@gmail.com
Starting Member

3 Posts

Posted - 2008-04-09 : 11:32:31

Yes basically i got all details which comes as output with thses queries .u just try this query thn u will see output .the thing is output comes fine but i need to see in one table .this query i made according to my needs ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources