Posted inSQL Server
SQL Object Decryption
Background The ability to "decrypt" an object in SQL Server be it stored procedure, view, function or trigger is something that I have run into a few times. In this…
Posted inSQL Server
SQL Server Memory Usage – Buffer
What is the SQL Server Buffer Pool? I am purposely keeping this post short because I simply want to offer up my script to show the current amount buffered. My…
Posted inSQL Server
Failing the MCM Lab exam
Well I failed the MCM Lab exam which I spoke about last time. The results came in 3 weeks so nice and quick. In a few ways I am happy…
Posted inSQL Server
Post MCM Lab Exam 88-971 thoughts etc
This is a quick update on my MCM progress as yesterday (5th July) I took the lab portion 88-971. I am afraid this post will not go into any content detail as…
Posted inSQL Server
TORN_PAGE_DETECTION Internals (SQL 2005 onwards)
CHECKSUM is in the majority of cases the more appropriate PAGE_VERIFY option as it provides a much more complete check (slightly higher overhead) when compared to TORN_PAGE_DETECTION. I thought today however I…
Posted inSQL Server
SQL Server Max Row Size 8060 Part 2
In my previous post on row maximum length I showed that the largest row size that could be stored on page was 8053 byte. So to recap a table with…
Posted inSQL Server
Passed MCM Knowledge Exam 88-970
Well back in January I mentioned my plan to study towards the MCM certification. Well... I passed 88-970... for those who want to know more read on. I said I…
Posted inSQL Server
Page Life Expectancy
Page Life Expectancy Page Life Expectancy is often quoted as being a key metric to watch out for memory pressure within SQL Server. If you search you will often see 300 listed…
Posted inSQL Server
SQL Servers Virtual Columns and Row Cracking
In order to access row structures there are several functions within SQL Server that are beneficial. I have listed these below with the descriptions taken from the actual functions. sys.fn_GetRowsetIdFromrowdump --…
Posted inSQL Server
SQL Server Max Row Size 8060
When asked the size of the largest row that could be placed on to a single SQL Server data page the answer that most give is 8060 bytes. If you…