Browsing articles tagged with " t-sql"
Feb
5
2012

T-SQL to find Physical and Logical Processors (CPU)

Today while searching for t-sql scripts to collect Physical and Logical CPU count for around 100+ SQL servers (all version SQL 2000, 2005 and 2008 R2) came across following articles and the useful scripts, read below for more details, The basic limitation behing finding physical CPU count is you can’t find directly using t-sql in SQL Server 2000, from SQL 2005 onwards you can easily find it using DMV sys.dm_os_sys_info Script provided at following links, […]

Dec
15
2011

How do I check SQL replication status via T-SQL?

While searching for t-sql script which can check replication agent status came across a good script which works well for all versions of SQL Server i.e. 2000/2005/2008/2008R2 and above…

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 446 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

June 2017
M T W T F S S
« May    
 1234
567891011
12131415161718
19202122232425
2627282930  

View Post by Categories

%d bloggers like this: