Browse by Tags

All Tags » scripts (RSS)
02 February 2011 23:03

The Exceptional EXCEPT clause

Ok, I exaggerate, but it can be useful… I came across some ‘poorly-written’ stored procedures on a SQL server recently, that were using sp_xml_preparedocument. Unfortunately these procs were not properly removing the memory allocated to XML structures...
Posted by steveh99999 | 1 comment(s)
Filed under: ,
17 January 2011 22:01

The overlooked OUTPUT clause

I often find myself applying ad-hoc data updates to production systems – usually running scripts written by other people. One of my favourite features of SQL syntax is the OUTPUT clause – I find this is rarely used, and I often wonder if this is due to...
Posted by steveh99999 | 5 comment(s)
Filed under: ,
02 April 2010 12:31

DBCC MEMUSAGE in 2005/8 ?

I used to like using undocumented command DBCC MEMUSAGE in SQL 2000 to see which tables were using space in SQL data cache. In SQL 2005, this command is not longer present. Instead a DMV – sys.dm_os_buffer_descriptors – can be used to display data cache...
Posted by steveh99999 | 3 comment(s)
Filed under: ,