Archive

Posts Tagged ‘SQL Server 2005’

Using fn_dblog


I like the fn_dblog function even if it is undocumented. It enables you to read from you transaction log which contains very valuable information about stuff that is happening in your database. It is for example the only way I now at this time to determin which object experienced a page split if you search for the LOP_DELETE_SPLIT operation.

SELECT *
FROM ::fn_dblog(NULL, NULL)
WHERE operation = ‘LOP_DELETE_SPLIT’

Read more…

Advertisements
Categories: News, SQL Server 2005 Tags: , ,

Do I have to assign the Lock Pages in Memory privilege for Local System?


This article has been written in the beginning of 2007 but, anyway, I face quite often with memory related issues dealing with costumers who are using Standard Edition of SQL Server. From my point of view it is worth to read this article through and systematize your knowledge about Locked Pages in SQL Server Standard Edition. Read more…

Important support changes for SQL Server 2000 and SQL Server 2005


There are some important support changes coming up for Microsoft SQL Server 2000 and SQL Server 2005. We want to make sure you know what’s happening so you can avoid the risk of running unsupported products and choose the right version of SQL Server for your business. Read more…