Sunday, February 28, 2010

Favourite 10 Perfmon counters

›
With a boring intro of perfmon already written here , lemme get started with my favourite 10 perfmon counters.In my not so humble opinion, i...
Monday, February 22, 2010

Perfmon - Boredo Intro

›
Perfmon Counters: Perform is perhaps the most popular Performance monitoring tool provided by Microsoft, and by far my favourite tool. Brief...
2 comments:
Wednesday, February 17, 2010

Database Server is slow. Can you please check?

›
As a DBA, you are going to hear the title of this many many times. This post will discuss the quick list of things a DBA does when such a qu...
2 comments:
Monday, February 8, 2010

Checking detached data file details

›
DBCC CheckPrimaryfile DBCC   checkprimaryfile   (   'C:\Program Files\Microsoft SQL Server\MSSQL$RAJ\data\master.mdf'   ,   1   ) ...

Windows accounts accessing SqlServer

›
xp_logininfo: Useful sp to check the list of Windows logins/users that have access to the SQL Server. Provides the list of Windows account...
Sunday, January 31, 2010

Database on a Network Drive

›
How to create a database on a network drive? Though not a recommended practice, if you need to resort to this option, due to space constrain...
Wednesday, January 27, 2010

Recursive CTE vs temp table - Performance comparison

›
I ended last post discussing the query plan of a recursive cte. On this one, we will see the performance comparison of recursive cte based...
2 comments: