Browse by Tags

SQL Server Audit Trace - things you need to take care!

Published 6 March 8 3:17 AM | SSQA.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...

Filed under: SOX, sql server, microsoft, solution, dmv, trace, audit, tsql, trace flag, c2

How to use TSQL to find the size of total and free physical memory within the SQL Server?

Published 24 January 8 4:28 PM | SSQA.net

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...

Filed under: sql server, performance, memory, microsoft, dump, physical, tsql, select, css, size

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)

Published 15 November 7 7:16 AM | SSQA.net

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 &...

Filed under: sql server, performance, microsoft, technet, dmv, top, tsql, reads, system resources, expensive query, identity, writes

Learn LINQ in relation to TSQL, Orcas and many more

Published 25 July 7 5:4 AM | SSQA.net

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?...

Filed under: microsoft, blogs, linq, location, tsql, learning, backups

Capitals or small letters - which one you choose when you are writing TSQL code?

Published 13 July 7 9:25 AM | SSQA.net

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...

Filed under: sql server, microsoft, table, tsql, code