Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack 2 has been released. It includes resolutions for 21 issues and the inclusion of fixes for 61 issues previously resolved. Along with the resolution of those issues, Service Pack 2 includes a few new … Continue reading SQL Server 2008 Service Pack 2 Released
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage … Continue reading Index Black Ops Part 4 – Index Overhead and Maintenance
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part … Continue reading Index Black Ops Part 3 – Index Usage
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 … Continue reading Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the information that the DMV contains. In this post, we are going to look at the locking and blocking columns. Base Columns Before we jump over to the meat and potatoes, let's first take a look at … Continue reading Index Black Ops Part 1 – Locks and Blocking
A couple weeks back someone asked me some questions about data types. Apparently, while implementing some financial data, each developer on the project had chosen their own data type. This was a bit of a problem that can lead to serious problems. When financial data is rounded unexpectedly - bad things can sometimes happen and … Continue reading Find Tables and Columns by Data Type
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter today at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of … Continue reading Webcast Today – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Database Administration Virtual Chapter next week. It’ll be on July 28 at 12 PM Eastern time. The topic will be Using XML to Query Execution Plans. The abstract for the event is the following: SQL Server stores its execution plans as XML in dynamic management views. The execution … Continue reading Webcast Next Week – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASS Performance Virtual Chapter later today starting at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following: User defined functions provide a means to encapsulate business logic in the database tier. Often the purpose of … Continue reading Webcast Today – Performance Impacts Related to Different Function Types
I was asked to take a look at an issue the other day regarding displaying Microsoft Project Task’s Notes in SSRS 2008. If you’ve worked with building reports for Microsoft Project Server, you have no doubt dealt with the RTF data that is stored in the Task’s Notes fields. With SQL Server 2005 Reporting Services … Continue reading Displaying Microsoft Project Task’s Notes in SSRS 2008
Strate SQL 