Browse by Tags

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

KBA: Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting Services or in SQL Server 2000 Reporting Services

Published 10 July 7 4:50 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting...

Filed under: sql server, server, reporting, kba, 2000, physical, 2005