27,129 reputation
54890
bio website tstringer.azurewebsites.net
location In the Ocean somewhere...
age
visits member for 3 years, 9 months
seen 1 hour ago

SQL Server Support Escalation Engineer at Microsoft.

Twitter: @SQLife
Blog: http://tstringer.azurewebsites.net
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.


Mar
27
revised SQL AlwaysOn Availability 2 synchronous nodes on either side of an asynchronous link
edited tags
Mar
27
answered SQL AlwaysOn Availability 2 synchronous nodes on either side of an asynchronous link
Mar
14
comment reorganize and UPDATE
No data needs to be updated here. select * from TICKETS order by TicketID;
Mar
14
comment Log shipping and SIMPLE recovery mode
What you can do and should do is stop setting your database's recovery model to simple. What is the root reason for doing this?
Mar
14
comment Take action from extended event?
What you can do is hook into XEvents event stream and take action that way. Very powerful, the sky is the limit. Information on how to accomplish this can be found here: tstringer.azurewebsites.net/?p=821
Mar
11
awarded  Famous Question
Mar
4
comment Backup terminating abnormally
@AaronBertrand The command is in the input buffer, and the error is an access violation. RFSonders, my recommendation would be to open up a case with SQL support.
Mar
4
comment SQL Server: get meta-Info about LDF-File
See my answer below for more information, but what are you trying to accomplish with this data? What's the bigger picture?
Mar
4
answered SQL Server: get meta-Info about LDF-File
Mar
3
comment How can I speed SQLPS connection when I don't have WMI permissions at the server
Can you add to your question the PowerShell that you're running, as well as the verbose warning messages?
Mar
2
awarded  Announcer
Feb
27
comment Long running DBCC CHECKDB
Have you looked to see if the DBCC CHECKDB request is being blocked during this time?
Feb
27
awarded  Enlightened
Feb
27
awarded  Nice Answer
Feb
27
revised Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
added 4 characters in body
Feb
27
comment Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
Can the downvoters please explain why the downvotes?? This looks like a fine question to me.
Feb
27
revised Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
added 342 characters in body
Feb
27
answered Why adding SQL Server user to “Perform volume maintenance tasks” improves the speed of database resizing so much?
Feb
27
comment Return list of columns in user-provided subquery
@MisterMagoo No problem at all!
Feb
26
comment Return list of columns in user-provided subquery
@MisterMagoo There you go :-) Only the necessary code to eliminate any confusion.