lionelpenuchot

3 Topics

Last Known Good Backup/DBCC
First published on MSDN on Feb 09, 2010 Based on Paul Randal’s post telling how to get the last known good DBCC ran against a database, based on my job requirements, I decided to write a T-SQL script which has nothing new but returns last known good DBCC execution time and last backup time for all databases of a SQL Server instance.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
1.1KViews
0likes
0Comments
SQL Server memory models (Part II)
First published on MSDN on Dec 22, 2009 So what is part II about? It is about a change in Standard 64 bit Editions of SQL Server 2005 and 2008.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
963Views
0likes
0Comments
SQL Server memory models (Part I)
First published on MSDN on Aug 05, 2009 You may have questioned why, on 64 bit enterprise Edition, DBCC MEMORYSTATUS reports non zero “AWE allocated” memory even if ‘AWE enabled’ option is not enabled.
SQLPFE
Apr 28, 2020 Place Core Infrastructure and Security Blog
2.5KViews
0likes
0Comments