Browse by Tags

• clr
• css
• dump
• managed code
• microsoft
• physical
• select
• server
• size
• sql server
• tsql

How to use TSQL to find the size of total and free physical memory within the SQL Server?
24 January 08 03:28 PM | SQL Master | 2 Comments   

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

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

Performace overhead and resolution when using CLR vs TSQL
31 July 07 01:42 AM | SQL Master | 2 Comments   

Integration with .NET framework CLR within SQL Server gives extra flexibility for the developers to use other programming languages such as C# or VB.net by creating functions, stored procedures, triggers, data types, and aggregates are among the kinds Read More...

Filed under: tsql, sql server, performance, server, managed code, memory, clr