Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

sys.tables

1
August 26, 2009  12:50 PM

Damn rollback scripts are a pain



Posted by: Denny Cherry
sys.tables, T/SQL

Writing release scripts for a database is easy.  What ever new objects you want you create you create, and what ever objects you need to change you change.  Piece of cake.  Rollback scripts however are a bit trickier since you need to know what everything should look like after the script is...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

October 16, 2008  11:00 AM

Handy Query to look at amount of data in Buffer Cache



Posted by: Denny Cherry
Cache, SQL Server 2005, SQL Server 2008, sys.allocation_units, sys.dm_os_buffer_descriptors, sys.partitions, sys.tables

Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache.  It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk. SELECT...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

1