I just learned how to view history of SQL Server service stops using Powershell: [code] # 17148 SQL Server is terminating in response to a 'stop' request ... get-EventLog Application | where {$_.EventID -eq 17148 -and $_.TimeGenerated -gt "1 June 2011"}

I just learned how to view history of SQL Server service stops using Powershell: [code] # 17148 SQL Server is terminating in response to a 'stop' request ... get-EventLog Application | where {$_.EventID -eq 17148 -and $_.TimeGenerated -gt "1 June 201...

I just learned how to view history of SQL Server service stops using Powershell: [code] # 17148 SQL Server is terminating in response to a 'stop' request ... get-EventLog Application | where {$_.EventID -eq 17148 -and $_.TimeGenerated -gt "1 June 201...

I rarely recommend OPENXML these days, but was able to pick this up using the edge table format: DECLARE @x XML SELECT @x = ' <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schem...

OK, just for completeness (and because no-one else has used it) my OPENXML solution. I tend not to use it much these days though, due to its 1/8th total server memory grabbing feature, plus I prefer the flexibility of the XML data-type methods and the ...

I rejected a few solutions due to performance, including a failed OPENXML solution! DECLARE @x XML = N' <bloggers> <name bloggerId = "1">Jacob Sebastian</name> <name bloggerId = "2">Adam Machanic</name> ...

Sequence expression, normal PIVOT, and avoiding expensive parent axis (..): SELECT bloggerId, name, url FROM ( SELECT x.y.value('@bloggerId', 'INT') bloggerId, x.y.value(...

The post explains how we can parse space-delimited string to column using the xsd list type and SQL Server's xml data type....

I learned a new technique recently for shredding delimited strings. It uses the xsd list type and SQL Server's xml data type and is quite powerful. It's a bit different to most shredding techniques in that it allows easy shredding to columns (instead ...

<p>In SQL 2005 you can do that using dynamic SQL, eg</p> <p><a href="http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/806e2f28-7181-4716-bad2-5982a7c919ec">http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/806e2f28-7181-4716-bad2-5982a7c919...