Thomas Stringer

14,244 reputation

22352

bio	website	sqlsalt.com
	location
	age
visits	member for	1 year, 10 months
	seen	53 mins ago
stats	profile views	405

SQL Server Premier Field Engineer at Microsoft.

Twitter: @SQLife
Blog: http://sqlsalt.com
Email: sqlsalt [at] outlook [dot] com

Disclaimer
The views expressed on my posts on this site are mine alone and do not reflect the views of my company. All posts of mine are provided "AS IS" with no warranties, and confers no rights.

The following disclaimer applies to all code, scripts and demos available on my posts:

This Sample Code is provided for the purpose of illustration only and is not intended to be used in a production environment. THIS SAMPLE CODE AND ANY RELATED INFORMATION ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. We grant You a nonexclusive, royalty-free right to use and modify the Sample Code and to reproduce and distribute the object code form of the Sample Code, provided that You agree: (i) to not use Our name, logo, or trademarks to market Your software product in which the Sample Code is embedded; (ii) to include a valid copyright notice on Your software product in which the Sample Code is embedded; and (iii) to indemnify, hold harmless, and defend Us and Our suppliers from and against any claims or lawsuits, including attorneys’ fees, that arise or result from the use or distribution of the Sample Code.

	14,244 reputation	bio	website	sqlsalt.com	visits	member for	1 year, 10 months
22352 badges		location			seen	53 mins ago

summary answers questions tags badges favorites bounties reputation activity

1,412 Actions

suggestions reviews revisions comments badges posts accepts all

Apr 11	comment	Tool to list down resultset from SQL Server for bulk data Also, please work on your acceptance rate by accepting answer to your previous questions.
Apr 10	comment	SQL Server Database Mail failing to send emails with error Sender address rejected: Access denied Sounds like SMTP credentials have changed. Have you verified this?
Apr 10	comment	Unable to telnet to port 1433 in SQL Server clustered instance? Are the instances in separate subnets?
Apr 9	comment	Availability Strategies in MS SQL Server 2008 Are you talking about availability or recoverability? Those are two different things, and depending on what you mean then Log Shipping and DB Mirroring might be way over kill.
Apr 9	awarded	Vox Populi
Apr 9	revised	SQL Server 2008/R2 recovery model edited tags
Apr 9	awarded	Enlightened
Apr 9	awarded	Nice Answer
Apr 9	revised	SQL Server 2008/R2 recovery model added 31 characters in body
Apr 6	revised	SQL ServerRecovery Model Change Tracking added 4 characters in body; edited tags
Apr 6	comment	SQL ServerRecovery Model Change Tracking @ooutwire Glad to help.
Apr 6	answered	SQL ServerRecovery Model Change Tracking
Apr 6	comment	How to assign CTRL+F1 to sp_whoisactive in ssms 2012? Ah, good catch. The OP probably didn't change it in the Query Shortcuts part, but the main Keyboard section.
Apr 6	comment	How to assign CTRL+F1 to sp_whoisactive in ssms 2012? @AaronBertrand Isn't that unnecessary, as a prefix of `sp_` causes SQL Server to look in the `master` database first anyways?
Apr 6	comment	How to assign CTRL+F1 to sp_whoisactive in ssms 2012? Does that stored procedure actually exist in your instance? That is not an ms-shipped SP. Can you run it manually?
Apr 6	comment	Exporting SQL Server 2008 R2 Activity Monitor Log I'm pretty sure the Activity monitor just pulls the root of its data from `sys.dm_exec_query_stats` (and obviously with `sys.dm_exec_sql_text`). As for a way to directly import it form Activity Monitor? I don't think that's possible. But you could just work with the direct DMV to get the data.
Apr 5	revised	querying multiple values from one column edited tags
Apr 5	revised	querying multiple values from one column added 73 characters in body
Apr 5	answered	querying multiple values from one column
Apr 5	comment	CTE Running in Infinite Loop You would find that as your `ID` is joined to a `Parent_ID`, and somewhere in that chain the `Parent_ID` is joined to a same `ID`. That would be the cause of the loop.