SqlServer-QA.net

Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need to know which column and table you need to get the relevant information. There is a difference ...

Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With VASummary(Size,Reserved,Free) AS (SELECT   Size = VaDump.Size,   Reserved = ...

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read & write). November2007 magazine refers as follows: SELECT TOP 20 SUBSTRING(qt.text, ...

In continuation to my post on Linq-TSQL I was drowing on web to know more about LINQ and how-to in relation to TSQL. Here comes the resources I have used and using so far in getting information about LINQ: First,  MSDNForum link on ''What is LINQ?  DLINQ?  XLINQ?''  Hands-On labs for LINQ MSDN-Blog featured ...

Have you ever gave a thought about writing a code within your development environment, I'm talking about writing TSQL scripts and not going for programming languages such as C# or ASP.net. So what is your favourite in this case: Look at this SQLBlog discussion, going interesting.